Prev: retriving data from different work sheet
Next: Excel 2003 restarts after closing
From: XLtest on 23 Jan 2010 07:14
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

 | 
Pages: 1
Prev: retriving data from different work sheet
Next: Excel 2003 restarts after closing