VB help SELECT COLUMN / PASTE FORMULA'S
 

hi, i am trying to copy formula's down a sheet (1 column), will need separate
method of: paste-special: formula, forma, both

- will use shortcut keys: alt -x.. (so this goes to a module?)
- want to paste to column, from cell selected (anywhere in column)
dynamic select rows automatically from row x to x, and paste formulas
only in rows where column A does not have a period/ "."

don't know if any of following will help, but have / starting with:
(may not apply or be correct), thanks in advance


Dim C5 As String 'top row
Dim C6 As String 'bot row
Dim C7 As String 'range top to bot, if correct
C5 = Range("C5")
C6 = Range("C6")
C7 = Range("C7")


'C5 has: =ROW($A$225)
'C6 has: =ROW($A$2042)
'C7 has: =ROW(A$225)&":"&ROW(A$2024) 'works in other vb unhide rows..


'If Target.Row < C5 Then Exit Sub 'if need any of this
'If Target.Row C6 Then Exit Sub
'If Me.Cells(.Row, "A").Value = "." Then Exit Sub

Column(ActiveCell.Row).Select 'PROBLEM? maybe wrong, trying to
select 1 col in range of rows


'Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False