vidyavallaba
New Member
- Joined
- Dec 17, 2013
- Messages
- 42
Hi,
I tried recording and macro but it did not help me.
I have a formula in "B2" and i want to copy it till last row of B.
last_row=Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row
and then i want to copy the values in B2 to last_row and paste them in column c.
Can anyone help me??
I tried recording and macro but it did not help me.
I have a formula in "B2" and i want to copy it till last row of B.
last_row=Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row
and then i want to copy the values in B2 to last_row and paste them in column c.
Can anyone help me??