Basically, I want the VBA to skip three rows and read the next line if the text in the current row is in bold font and skip 2 rows and read the next line if the text in the current row is not bold.
My code thus far:
Thanks!!Sub Bold()
Dim i As Range
For Each i In Range("A1:A6")
If FontBold = True Then
Range("A" & i).Select - This declaration of the range doesn't work! How can I fix it?
Selection.Copy
Range("F" & i).Select
ActiveSheet.Paste
i = i + 3
Else
Range("A" & i).Select
Selection.Copy
Range("F" & i).Select
ActiveSheet.Paste
i = i + 2
End If
Next
End Sub
Bookmarks