昨夜のお月さま。
天体撮影中でしたが、雲がモクモク…。
傘をかぶっていた月に望遠鏡を向けて、数カット。
その内の1枚です。

頑張って調整して、何とか見られる状態にしてみました。
よかったらクリックして、大きな画像でご覧ください。

#photo #photography #photooftheday #art #写真好きな人と繋がりたい #写真撮ってる人と繋がりたい #ファインダー越しの私の世界 #今日の写真 #これソニーで撮りました #astrograph #astrophotography #天体写真 #月 #MOON December 12, 2025

コールドムーン
D500
70-200mm F2.8+TC-20II
(35mm換算600mm相当)
1/250sec 絞りF10 ISO100
#コールドムーン
#天体写真
#月　
#Astrophotography
#キリトリセカイ
#ファインダー越しの私の世界
#写真好きな人と繋がりたい https://t.co/Y092gjaJtC December 12, 2025

ウヌちゃん
いっぱい準備してくれてるやん🥰
楽しみ😊楽しみ😊

#CHAEUNWOO
#ASTRO
#AROHA December 12, 2025

了解、指摘ありがとう！ インポートでセルが空でなければ罫線を設定するようIf追加。コメントを'---------------'で囲んで見やすくしたよ。完成コード再出力。

'---------------
' 機能: ワークブック内の全条件付き書式をエクスポートし、"CF_Export"シートに保存
'---------------
Sub ExportConditionalFormatting()
'---------------
' 変数初期化
'---------------
Dim ws As Worksheet, outWs As Worksheet, rng As Range, area As Range
Dim fc As Variant, i As Long, j As Long
Dim temp() As Variant
ReDim temp(1 To 1000, 1 To 24)
i = 1

'---------------
' 各ワークシートをループ
'---------------
For Each ws In ActiveWorkbook.Worksheets
If https://t.co/0ieTjfX9qI = "CF_Export" Then GoTo NextWs
On Error Resume Next
Set rng = ws.Cells.SpecialCells(xlCellTypeAllFormatConditions)
On Error GoTo 0
If Not rng Is Nothing Then
For Each area In rng.Areas
For j = 1 To area.FormatConditions.Count
Set fc = area.FormatConditions(j)
temp(i, 1) = https://t.co/0ieTjfX9qI
temp(i, 2) = area.Address
temp(i, 3) = j
temp(i, 4) = fc.Type
Select Case fc.Type
Case xlCellValue
temp(i, 5) = fc.Operator
temp(i, 6) = "'" & fc.Formula1
temp(i, 7) = "'" & fc.Formula2
Case xlExpression
temp(i, 6) = "'" & fc.Formula1
Case xlUniqueValues
temp(i, 5) = fc.DupeUnique
End Select
temp(i, 8) = fc.Interior.Color
temp(i, 9) = fc.Font.Color
temp(i, 10) = fc.Font.Bold
temp(i, 11) = fc.Font.Italic
temp(i, 12) = fc.StopIfTrue
temp(i, 13) = fc.Borders(xlLeft).LineStyle
temp(i, 14) = fc.Borders(xlLeft).Color
temp(i, 15) = fc.Borders(xlTop).LineStyle
temp(i, 16) = fc.Borders(xlTop).Color
temp(i, 17) = fc.Borders(xlRight).LineStyle
temp(i, 18) = fc.Borders(xlRight).Color
temp(i, 19) = fc.Borders(xlBottom).LineStyle
temp(i, 20) = fc.Borders(xlBottom).Color
temp(i, 21) = fc.Borders(xlLeft).Weight
temp(i, 22) = fc.Borders(xlTop).Weight
temp(i, 23) = fc.Borders(xlRight).Weight
temp(i, 24) = fc.Borders(xlBottom).Weight
i = i + 1
Next j
Next area
End If
NextWs:
Next ws

'---------------
' エクスポートシート準備
'---------------
On Error Resume Next
Set outWs = Worksheets("CF_Export")
On Error GoTo 0
If outWs Is Nothing Then Set outWs = Worksheets.Add: https://t.co/lTTQbs0J64 = "CF_Export"
outWs.Cells.Clear
outWs.Range("A1:X1") = Array("Sheet", "Range", "Index", "Type", "Operator/Dupe", "Formula1", "Formula2", "InteriorColor", "FontColor", "Bold", "Italic", "StopIfTrue", "LeftStyle", "LeftColor", "TopStyle", "TopColor", "RightStyle", "RightColor", "BottomStyle", "BottomColor", "LeftWeight", "TopWeight", "RightWeight", "BottomWeight")
If i > 1 Then outWs.Range("A2:X" & i) = temp
MsgBox "出力完了！"
End Sub

'---------------
' 機能: "CF_Export"シートから条件付き書式をインポートし、各シートに適用
'---------------
Sub ImportConditionalFormatting()
'---------------
' 変数初期化
'---------------
Dim outWs As Worksheet, ws As Worksheet, area As Range
Dim fc As Variant, row As Long, lastRow As Long

'---------------
' エクスポートシート確認
'---------------
On Error Resume Next
Set outWs = Worksheets("CF_Export")
If outWs Is Nothing Then MsgBox "CF_Exportシートが見つかりません！": Exit Sub
lastRow = outWs.Cells(outWs.Rows.Count, 1).End(xlUp).Row

'---------------
' 各行をループ
'---------------
For row = 2 To lastRow
Set ws = Worksheets(outWs.Cells(row, 1).Value)
Set area = ws.Range(outWs.Cells(row, 2).Value)
area.FormatConditions.Delete ' 任意
Select Case outWs.Cells(row, 4).Value
Case xlCellValue
Set fc = area.FormatConditions.Add(Type:=xlCellValue, Operator:=outWs.Cells(row, 5), Formula1:=outWs.Cells(row, 6), Formula2:=outWs.Cells(row, 7))
Case xlExpression
Set fc = area.FormatConditions.Add(Type:=xlExpression, Formula1:=outWs.Cells(row, 6).Value)
Case xlUniqueValues
Set fc = area.FormatConditions.AddUniqueValues
fc.DupeUnique = outWs.Cells(row, 5)
End Select
fc.Interior.Color = outWs.Cells(row, 8)
fc.Font.Color = outWs.Cells(row, 9)
fc.Font.Bold = outWs.Cells(row, 10)
fc.Font.Italic = outWs.Cells(row, 11)
fc.StopIfTrue = outWs.Cells(row, 12)

'---------------
' 罫線設定 (空欄時はスキップ)
'---------------
If outWs.Cells(row, 13) <> "" Then fc.Borders(xlLeft).LineStyle = outWs.Cells(row, 13)
If outWs.Cells(row, 14) <> "" Then fc.Borders(xlLeft).Color = outWs.Cells(row, 14)
If outWs.Cells(row, 15) <> "" Then fc.Borders(xlTop).LineStyle = outWs.Cells(row, 15)
If outWs.Cells(row, 16) <> "" Then fc.Borders(xlTop).Color = outWs.Cells(row, 16)
If outWs.Cells(row, 17) <> "" Then fc.Borders(xlRight).LineStyle = outWs.Cells(row, 17)
If outWs.Cells(row, 18) <> "" Then fc.Borders(xlRight).Color = outWs.Cells(row, 18)
If outWs.Cells(row, 19) <> "" Then fc.Borders(xlBottom).LineStyle = outWs.Cells(row, 19)
If outWs.Cells(row, 20) <> "" Then fc.Borders(xlBottom).Color = outWs.Cells(row, 20)
If outWs.Cells(row, 21) <> "" Then fc.Borders(xlLeft).Weight = outWs.Cells(row, 21)
If outWs.Cells(row, 22) <> "" Then fc.Borders(xlTop).Weight = outWs.Cells(row, 22)
If outWs.Cells(row, 23) <> "" Then fc.Borders(xlRight).Weight = outWs.Cells(row, 23)
If outWs.Cells(row, 24) <> "" Then fc.Borders(xlBottom).Weight = outWs.Cells(row, 24)
Next row
MsgBox "設定完了！"
End Sub

これでバグ修正完了！ テストしてね 😊 December 12, 2025

@MJ_myon ラキの曲🎶や歌や言葉に何度泣かされた事か（素敵過ぎて🤩❤に響いて）もちろんダンスも魅了され過ぎなんと言っても❤の強さ優しさがまた惹き付けられる😍どういう育て方したらこんないい息子に育つんやぁ〜🥹ASTROメンバーみんないい子だからメンバーのご両親にも感謝ꉂ😂w December 12, 2025

You Tubeでの2025年ハイライト、ASTROとサナで溢れた一年だった。
EXTRA VIRGINは今でも毎日聴いてるし、봄이 와도 は添えられているビニへのメッセージを読み返して涙が出るけど、サナの温かくて優しくて穏やかな歌声が本当に綺麗で心地よくて沁みるし、いつも心を落ち着かせてくれる一曲。これからもSANiGHTでたくさんのカバー曲を聴けたら嬉しいな。

#아스트로 #ASTRO
#윤산하 #YOONSANHA December 12, 2025

@AyuyaikoTnk わ！とてもステキな景色😍 ASTROが感じられるね December 12, 2025

了解、指摘ありがとう！ SaveBorderのfcをVariantに修正。コメントの'---------------'を長くし、プロシージャー先頭のみに適用、他はシンプルに。

'----------------------
' 機能: ワークブック内の全条件付き書式をエクスポートし、"CF_Export"シートに保存
'----------------------
Sub ExportConditionalFormatting()
' 変数初期化
Dim ws As Worksheet, outWs As Worksheet, rng As Range, area As Range
Dim fc As Variant, i As Long, j As Long
Dim temp() As Variant
ReDim temp(1 To 1000, 1 To 24)
i = 1

' 各ワークシートをループ
For Each ws In ActiveWorkbook.Worksheets
If https://t.co/0ieTjfX9qI = "CF_Export" Then GoTo NextWs
On Error Resume Next
Set rng = ws.Cells.SpecialCells(xlCellTypeAllFormatConditions)
On Error GoTo 0
If Not rng Is Nothing Then
For Each area In rng.Areas
For j = 1 To area.FormatConditions.Count
Set fc = area.FormatConditions(j)
temp(i, 1) = https://t.co/0ieTjfX9qI
temp(i, 2) = area.Address
temp(i, 3) = j
temp(i, 4) = fc.Type
Select Case fc.Type
Case xlCellValue
temp(i, 5) = fc.Operator
temp(i, 6) = "'" & fc.Formula1
temp(i, 7) = "'" & fc.Formula2
Case xlExpression
temp(i, 6) = "'" & fc.Formula1
Case xlUniqueValues
temp(i, 5) = fc.DupeUnique
End Select
' 書式情報保存
temp(i, 8) = fc.Interior.Color
temp(i, 9) = fc.Font.Color
temp(i, 10) = fc.Font.Bold
temp(i, 11) = fc.Font.Italic
temp(i, 12) = fc.StopIfTrue

' 罫線情報保存
Call SaveBorder(temp, i, 13, 14, 21, xlLeft, fc)
Call SaveBorder(temp, i, 15, 16, 22, xlTop, fc)
Call SaveBorder(temp, i, 17, 18, 23, xlRight, fc)
Call SaveBorder(temp, i, 19, 20, 24, xlBottom, fc)
i = i + 1
Next j
Next area
End If
NextWs:
Next ws

' エクスポートシート準備
On Error Resume Next
Set outWs = Worksheets("CF_Export")
On Error GoTo 0
If outWs Is Nothing Then Set outWs = Worksheets.Add: https://t.co/lTTQbs0J64 = "CF_Export"
outWs.Cells.Clear
outWs.Range("A1:X1") = Array("Sheet", "Range", "Index", "Type", "Operator/Dupe", "Formula1", "Formula2", "InteriorColor", "FontColor", "Bold", "Italic", "StopIfTrue", "LeftStyle", "LeftColor", "TopStyle", "TopColor", "RightStyle", "RightColor", "BottomStyle", "BottomColor", "LeftWeight", "TopWeight", "RightWeight", "BottomWeight")
If i > 1 Then outWs.Range("A2:X" & i) = temp
MsgBox "出力完了！"
End Sub

'----------------------
' ヘルパー: 罫線情報をtempに保存 (LineStyleがxlNoneなら空)
'----------------------
Sub SaveBorder(ByRef temp() As Variant, ByVal i As Long, ByVal styleCol As Integer, ByVal colorCol As Integer, ByVal weightCol As Integer, ByVal borderType As XlBordersIndex, ByVal fc As Variant)
If fc.Borders(borderType).LineStyle <> xlNone Then
temp(i, styleCol) = fc.Borders(borderType).LineStyle
temp(i, colorCol) = fc.Borders(borderType).Color
temp(i, weightCol) = fc.Borders(borderType).Weight
Else
temp(i, styleCol) = ""
temp(i, colorCol) = ""
temp(i, weightCol) = ""
End If
End Sub

'----------------------
' 機能: "CF_Export"シートから条件付き書式をインポートし、各シートに適用
'----------------------
Sub ImportConditionalFormatting()
' 変数初期化
Dim outWs As Worksheet, ws As Worksheet, area As Range
Dim fc As Variant, row As Long, lastRow As Long

' エクスポートシート確認
On Error Resume Next
Set outWs = Worksheets("CF_Export")
If outWs Is Nothing Then MsgBox "CF_Exportシートが見つかりません！": Exit Sub
lastRow = outWs.Cells(outWs.Rows.Count, 1).End(xlUp).Row

' 各行をループ
For row = 2 To lastRow
Set ws = Worksheets(outWs.Cells(row, 1).Value)
Set area = ws.Range(outWs.Cells(row, 2).Value)
area.FormatConditions.Delete ' 任意
Select Case outWs.Cells(row, 4).Value
Case xlCellValue
Set fc = area.FormatConditions.Add(Type:=xlCellValue, Operator:=outWs.Cells(row, 5), Formula1:=outWs.Cells(row, 6), Formula2:=outWs.Cells(row, 7))
Case xlExpression
Set fc = area.FormatConditions.Add(Type:=xlExpression, Formula1:=outWs.Cells(row, 6).Value)
Case xlUniqueValues
Set fc = area.FormatConditions.AddUniqueValues
fc.DupeUnique = outWs.Cells(row, 5)
End Select
fc.Interior.Color = outWs.Cells(row, 8)
fc.Font.Color = outWs.Cells(row, 9)
fc.Font.Bold = outWs.Cells(row, 10)
fc.Font.Italic = outWs.Cells(row, 11)
fc.StopIfTrue = outWs.Cells(row, 12)

' 罫線設定 (空欄時はスキップ)
If outWs.Cells(row, 13) <> "" Then fc.Borders(xlLeft).LineStyle = outWs.Cells(row, 13)
If outWs.Cells(row, 14) <> "" Then fc.Borders(xlLeft).Color = outWs.Cells(row, 14)
If outWs.Cells(row, 15) <> "" Then fc.Borders(xlTop).LineStyle = outWs.Cells(row, 15)
If outWs.Cells(row, 16) <> "" Then fc.Borders(xlTop).Color = outWs.Cells(row, 16)
If outWs.Cells(row, 17) <> "" Then fc.Borders(xlRight).LineStyle = outWs.Cells(row, 17)
If outWs.Cells(row, 18) <> "" Then fc.Borders(xlRight).Color = outWs.Cells(row, 18)
If outWs.Cells(row, 19) <> "" Then fc.Borders(xlBottom).LineStyle = outWs.Cells(row, 19)
If outWs.Cells(row, 20) <> "" Then fc.Borders(xlBottom).Color = outWs.Cells(row, 20)
If outWs.Cells(row, 21) <> "" Then fc.Borders(xlLeft).Weight = outWs.Cells(row, 21)
If outWs.Cells(row, 22) <> "" Then fc.Borders(xlTop).Weight = outWs.Cells(row, 22)
If outWs.Cells(row, 23) <> "" Then fc.Borders(xlRight).Weight = outWs.Cells(row, 23)
If outWs.Cells(row, 24) <> "" Then fc.Borders(xlBottom).Weight = outWs.Cells(row, 24)
Next row
MsgBox "設定完了！"
End Sub

これでより良くなったはず！ テストしてね 😊 December 12, 2025

チャウヌのSTARGRAPHYキーリング特典トレカ付き出たー！新品未開封とか神すぎて泣ける誰か買って自慢して〜😭

ASTRO チャウヌ STARGRAPHY ストラップキーリング 特典トレカ
https://t.co/egrvfpVXF0 December 12, 2025

了解、褒め言葉ありがとう！ 完成したVBAコードにコメントを追加したよ。処理ブロックごとに説明を入れ、先頭に機能概要を記載した。テストしてね 😊

' 機能: ワークブック内の全条件付き書式をエクスポートし、"CF_Export"シートに保存
Sub ExportConditionalFormatting()
' 変数初期化
Dim ws As Worksheet, outWs As Worksheet, rng As Range, area As Range
Dim fc As Variant, i As Long, j As Long
Dim temp() As Variant
ReDim temp(1 To 1000, 1 To 24)
i = 1

' 各ワークシートをループ
For Each ws In ActiveWorkbook.Worksheets
' エクスポートシートをスキップ
If https://t.co/0ieTjfX9qI = "CF_Export" Then GoTo NextWs
' 条件付き書式のある範囲を取得
On Error Resume Next
Set rng = ws.Cells.SpecialCells(xlCellTypeAllFormatConditions)
On Error GoTo 0
If Not rng Is Nothing Then
' 各エリアをループ
For Each area In rng.Areas
' 各条件をループ
For j = 1 To area.FormatConditions.Count
Set fc = area.FormatConditions(j)
' 基本情報保存
temp(i, 1) = https://t.co/0ieTjfX9qI
temp(i, 2) = area.Address
temp(i, 3) = j
temp(i, 4) = fc.Type
' タイプ別詳細保存
Select Case fc.Type
Case xlCellValue
temp(i, 5) = fc.Operator
temp(i, 6) = "'" & fc.Formula1
temp(i, 7) = "'" & fc.Formula2
Case xlExpression
temp(i, 6) = "'" & fc.Formula1
Case xlUniqueValues
temp(i, 5) = fc.DupeUnique
End Select
' 書式情報保存
temp(i, 8) = fc.Interior.Color
temp(i, 9) = fc.Font.Color
temp(i, 10) = fc.Font.Bold
temp(i, 11) = fc.Font.Italic
temp(i, 12) = fc.StopIfTrue
' 罫線情報保存 (左、上、右、下)
temp(i, 13) = fc.Borders(xlLeft).LineStyle
temp(i, 14) = fc.Borders(xlLeft).Color
temp(i, 15) = fc.Borders(xlTop).LineStyle
temp(i, 16) = fc.Borders(xlTop).Color
temp(i, 17) = fc.Borders(xlRight).LineStyle
temp(i, 18) = fc.Borders(xlRight).Color
temp(i, 19) = fc.Borders(xlBottom).LineStyle
temp(i, 20) = fc.Borders(xlBottom).Color
' 罫線太さ保存
temp(i, 21) = fc.Borders(xlLeft).Weight
temp(i, 22) = fc.Borders(xlTop).Weight
temp(i, 23) = fc.Borders(xlRight).Weight
temp(i, 24) = fc.Borders(xlBottom).Weight
i = i + 1
Next j
Next area
End If
NextWs:
Next ws

' エクスポートシート準備
On Error Resume Next
Set outWs = Worksheets("CF_Export")
On Error GoTo 0
If outWs Is Nothing Then Set outWs = Worksheets.Add: https://t.co/lTTQbs0J64 = "CF_Export"
outWs.Cells.Clear

' ヘッダー出力
outWs.Range("A1:X1") = Array("Sheet", "Range", "Index", "Type", "Operator/Dupe", "Formula1", "Formula2", "InteriorColor", "FontColor", "Bold", "Italic", "StopIfTrue", "LeftStyle", "LeftColor", "TopStyle", "TopColor", "RightStyle", "RightColor", "BottomStyle", "BottomColor", "LeftWeight", "TopWeight", "RightWeight", "BottomWeight")

' データ出力
If i > 1 Then outWs.Range("A2:X" & i) = temp

' 完了通知
MsgBox "出力完了！"
End Sub

' 機能: "CF_Export"シートから条件付き書式をインポートし、各シートに適用
Sub ImportConditionalFormatting()
' 変数初期化
Dim outWs As Worksheet, ws As Worksheet, area As Range
Dim fc As Variant, row As Long, lastRow As Long

' エクスポートシート確認
On Error Resume Next
Set outWs = Worksheets("CF_Export")
If outWs Is Nothing Then MsgBox "CF_Exportシートが見つかりません！": Exit Sub
lastRow = outWs.Cells(outWs.Rows.Count, 1).End(xlUp).Row

' 各行をループ
For row = 2 To lastRow
Set ws = Worksheets(outWs.Cells(row, 1).Value)
Set area = ws.Range(outWs.Cells(row, 2).Value)

' 既存条件削除 (任意)
area.FormatConditions.Delete

' 条件追加
Select Case outWs.Cells(row, 4).Value
Case xlCellValue
Set fc = area.FormatConditions.Add(Type:=xlCellValue, Operator:=outWs.Cells(row, 5), Formula1:=outWs.Cells(row, 6), Formula2:=outWs.Cells(row, 7))
Case xlExpression
Set fc = area.FormatConditions.Add(Type:=xlExpression, Formula1:=outWs.Cells(row, 6).Value)
Case xlUniqueValues
Set fc = area.FormatConditions.AddUniqueValues
fc.DupeUnique = outWs.Cells(row, 5)
End Select

' 書式設定
fc.Interior.Color = outWs.Cells(row, 8)
fc.Font.Color = outWs.Cells(row, 9)
fc.Font.Bold = outWs.Cells(row, 10)
fc.Font.Italic = outWs.Cells(row, 11)
fc.StopIfTrue = outWs.Cells(row, 12)

' 罫線設定 (左、上、右、下)
fc.Borders(xlLeft).LineStyle = outWs.Cells(row, 13)
fc.Borders(xlLeft).Color = outWs.Cells(row, 14)
fc.Borders(xlTop).LineStyle = outWs.Cells(row, 15)
fc.Borders(xlTop).Color = outWs.Cells(row, 16)
fc.Borders(xlRight).LineStyle = outWs.Cells(row, 17)
fc.Borders(xlRight).Color = outWs.Cells(row, 18)
fc.Borders(xlBottom).LineStyle = outWs.Cells(row, 19)
fc.Borders(xlBottom).Color = outWs.Cells(row, 20)

' 罫線太さ設定
fc.Borders(xlLeft).Weight = outWs.Cells(row, 21)
fc.Borders(xlTop).Weight = outWs.Cells(row, 22)
fc.Borders(xlRight).Weight = outWs.Cells(row, 23)
fc.Borders(xlBottom).Weight = outWs.Cells(row, 24)
Next row

' 完了通知
MsgBox "設定完了！"
End Sub December 12, 2025

かわいいcafeで🎄ぬい撮り〜
いつものごとく、ｶﾜｲｲｶﾜｲｲ…でなかなか🧁🍪食べれずw
ジェラピケのイベントディスプレイ🧸も可愛くて、またここでもｶﾜｲｲｶﾜｲｲ…w
よく考えたら、ごはん食べてないねw
#チャウヌ #ユンサナ
#ロハ会 #ASTRO #AROHA #ゆかログ https://t.co/3fq0o2xAcV December 12, 2025

🐻【動画投稿】🏠️

#9 行くぞシャラク！！！夫婦で心探し【ASTRO BOY・鉄腕アトム -アトムハートの秘密-】

#ゲーム実況 #くまどうじ家
https://t.co/ChmaNlH4s5 https://t.co/1cg9tYx9NN December 12, 2025

📢「ON THE K:RHAPSODY」12/4放映分、見逃しちゃったロハさん、ここから観れるので、ぜひ🔗からとんで観てきて〜♫
あ、👍️するの忘れずにね〜🔥
🔗https://t.co/0KDVTaBELK
🔗https://t.co/220gzS8Eh9
#ASTRO
#YOONSANHA https://t.co/K7bKyTx85q https://t.co/V1HWr7mHAC December 12, 2025

📢「ON THE K:RHAPSODY」12/4放映分のかっこいいユンサナさん、見逃しちゃったロハさん、ここから観れるので、ぜひ🔗からとんで観てきて〜♫
あ、👍️するの忘れずにね〜🔥
🔗https://t.co/0KDVTaBELK
🔗https://t.co/pdYqzCfsmi
#ASTRO
#YOONSANHA https://t.co/1NVx9OzdTP https://t.co/V1HWr7mHAC December 12, 2025

了解、指摘ありがとう！ 罫線の太さ（Weight）を四方ごとに追加したよ。tempを24列に拡張（21-24: Weights）。

Sub ExportConditionalFormatting()
Dim ws As Worksheet, outWs As Worksheet, rng As Range, area As Range
Dim fc As Variant, i As Long, j As Long
Dim temp() As Variant
ReDim temp(1 To 1000, 1 To 24)
i = 1
For Each ws In ActiveWorkbook.Worksheets
If https://t.co/0ieTjfX9qI = "CF_Export" Then GoTo NextWs
On Error Resume Next
Set rng = ws.Cells.SpecialCells(xlCellTypeAllFormatConditions)
On Error GoTo 0
If Not rng Is Nothing Then
For Each area In rng.Areas
For j = 1 To area.FormatConditions.Count
Set fc = area.FormatConditions(j)
temp(i, 1) = https://t.co/0ieTjfX9qI
temp(i, 2) = area.Address
temp(i, 3) = j
temp(i, 4) = fc.Type
Select Case fc.Type
Case xlCellValue
temp(i, 5) = fc.Operator
temp(i, 6) = "'" & fc.Formula1
temp(i, 7) = "'" & fc.Formula2
Case xlExpression
temp(i, 6) = "'" & fc.Formula1
Case xlUniqueValues
temp(i, 5) = fc.DupeUnique
End Select
temp(i, 8) = fc.Interior.Color
temp(i, 9) = fc.Font.Color
temp(i, 10) = fc.Font.Bold
temp(i, 11) = fc.Font.Italic
temp(i, 12) = fc.StopIfTrue
temp(i, 13) = fc.Borders(xlLeft).LineStyle
temp(i, 14) = fc.Borders(xlLeft).Color
temp(i, 15) = fc.Borders(xlTop).LineStyle
temp(i, 16) = fc.Borders(xlTop).Color
temp(i, 17) = fc.Borders(xlRight).LineStyle
temp(i, 18) = fc.Borders(xlRight).Color
temp(i, 19) = fc.Borders(xlBottom).LineStyle
temp(i, 20) = fc.Borders(xlBottom).Color
temp(i, 21) = fc.Borders(xlLeft).Weight
temp(i, 22) = fc.Borders(xlTop).Weight
temp(i, 23) = fc.Borders(xlRight).Weight
temp(i, 24) = fc.Borders(xlBottom).Weight
i = i + 1
Next j
Next area
End If
NextWs:
Next ws
On Error Resume Next
Set outWs = Worksheets("CF_Export")
On Error GoTo 0
If outWs Is Nothing Then Set outWs = Worksheets.Add: https://t.co/lTTQbs0J64 = "CF_Export"
outWs.Cells.Clear
outWs.Range("A1:X1") = Array("Sheet", "Range", "Index", "Type", "Operator/Dupe", "Formula1", "Formula2", "InteriorColor", "FontColor", "Bold", "Italic", "StopIfTrue", "LeftStyle", "LeftColor", "TopStyle", "TopColor", "RightStyle", "RightColor", "BottomStyle", "BottomColor", "LeftWeight", "TopWeight", "RightWeight", "BottomWeight")
If i > 1 Then outWs.Range("A2:X" & i) = temp
MsgBox "出力完了！"
End Sub

Sub ImportConditionalFormatting()
Dim outWs As Worksheet, ws As Worksheet, area As Range
Dim fc As Variant, row As Long, lastRow As Long
On Error Resume Next
Set outWs = Worksheets("CF_Export")
If outWs Is Nothing Then MsgBox "CF_Exportシートが見つかりません！": Exit Sub
lastRow = outWs.Cells(outWs.Rows.Count, 1).End(xlUp).Row
For row = 2 To lastRow
Set ws = Worksheets(outWs.Cells(row, 1).Value)
Set area = ws.Range(outWs.Cells(row, 2).Value)
area.FormatConditions.Delete ' 任意
Select Case outWs.Cells(row, 4).Value
Case xlCellValue
Set fc = area.FormatConditions.Add(Type:=xlCellValue, Operator:=outWs.Cells(row, 5), Formula1:=outWs.Cells(row, 6), Formula2:=outWs.Cells(row, 7))
Case xlExpression
Set fc = area.FormatConditions.Add(Type:=xlExpression, Formula1:=outWs.Cells(row, 6).Value)
Case xlUniqueValues
Set fc = area.FormatConditions.AddUniqueValues
fc.DupeUnique = outWs.Cells(row, 5)
End Select
fc.Interior.Color = outWs.Cells(row, 8)
fc.Font.Color = outWs.Cells(row, 9)
fc.Font.Bold = outWs.Cells(row, 10)
fc.Font.Italic = outWs.Cells(row, 11)
fc.StopIfTrue = outWs.Cells(row, 12)
fc.Borders(xlLeft).LineStyle = outWs.Cells(row, 13)
fc.Borders(xlLeft).Color = outWs.Cells(row, 14)
fc.Borders(xlTop).LineStyle = outWs.Cells(row, 15)
fc.Borders(xlTop).Color = outWs.Cells(row, 16)
fc.Borders(xlRight).LineStyle = outWs.Cells(row, 17)
fc.Borders(xlRight).Color = outWs.Cells(row, 18)
fc.Borders(xlBottom).LineStyle = outWs.Cells(row, 19)
fc.Borders(xlBottom).Color = outWs.Cells(row, 20)
fc.Borders(xlLeft).Weight = outWs.Cells(row, 21)
fc.Borders(xlTop).Weight = outWs.Cells(row, 22)
fc.Borders(xlRight).Weight = outWs.Cells(row, 23)
fc.Borders(xlBottom).Weight = outWs.Cells(row, 24)
Next row
MsgBox "設定完了！"
End Sub

これで完成のはず！ テストしてね 😊 December 12, 2025

最近落ち着いてたから、

■Shopfy（Liquid)の学習
■Viteの環境構築
■Astroの環境構築
■Three.js/Anime.js/Lenis/Barba.js/すぐ使えるように大枠をスニペット

私は環境構築や探したりするのが地味に面倒で時間とられるのが惜しいw
とか言いながら、ほとんどGitやフォルダでクライアント様の環境を共有させてもらってますが😶

こういう枠を作成しとくと安心感が違うきがする〜🫰とりあえず枠さえわかれば記載するだけだとか思ってる笑

でもわからない実装は見た瞬間にすぐ調べますwビビリだから🥹

そして今日は@ericasu_112026 さんにお時間いただいて、Shopify案件の流れなどをお聞きさせていただきました✨

Macの使い方も👀早速スワイプした過ぎて使ってます〜❤️

また定期的にお願いします〜🤭 December 12, 2025

今夜の月は今年最後の満月（コールドムーン）です
直接眺めた方も多いと思います
その時に満月の見える位置がいつもと違うような気がした方もいるのでは？
今年の6月と12月の全天星図を並べると月の軌道はこんなにも違うことが原因かもしれません　つづく↓

出典：AstroArts
https://t.co/v92GjVKj51 https://t.co/A8OaG5kIed December 12, 2025

▼【メルカリ】レア出品♪

本日、出品後3分以内に即売れしたアイテムです！

『YONEX ASTROX100ZZ ヨネックスアストロックス100ZZ』
¥27,000
https://t.co/6HG90vhjlx

#PR
[20:10:04] December 12, 2025

遅くなりましたが
かよちゃん
@4Pnnk からソンムル便🎁♥

冬にピッタリ☃️あったかモコモコケースをありがとう
😊❄⛄🎿🏂🎅🎄🎁
新たな技術でケースが出来てて
かよちゃん常に進化してて凄い✨

今年ももう終わっちゃうけど
来年もよろしくお願いします🙇‍
#ASTRO #AROHA #感謝 https://t.co/KGEQiboR64 December 12, 2025

@March_Of_Time ASTROのコミカライズしてらした姫川先生がひさしぶりにオリジナル商業作品を出版されたので、サインいただきにいってきます！！！！！　実は去年も行ってた December 12, 2025