pasting formulas into a selection
Hello,
I need to insert into cells some data.
i have <x amount of rows, and 5 columns
Column1: blank
Column2: blank
Column3: is a formula =IF(A<row="","",A<row&"/ "&B<row)
Column4: is a formula =IF($A<row = "","","Enter Email Address")
Column5: is a formula =IF($A<row = "","","Enter Role")
i can see selecting the rows
ActiveSheet.Range(Cells(1, 1), Cells(1, 5)).Select
then use selection, which is the Range object to do someting?
can anyone help?
thanks
|