Hi, can anyone help me with a VB code to drag down formulas in cells CZ,DA,DB,DC from row 2 to row n. Row n being the end of data on column B.
Thanks
Hi, can anyone help me with a VB code to drag down formulas in cells CZ,DA,DB,DC from row 2 to row n. Row n being the end of data on column B.
Thanks
Last edited by gautamacharya; 04-25-2011 at 07:08 PM.
Try thisA formula would be required in Cz2:dc2 before you run the code.Sub YourMac() Dim Rws As Long, Rng As Range Rws = Cells(Rows.Count, "B").End(xlUp).Row Set Rng = Range(Cells(2, "CZ"), Cells(Rws, "DC")) Range("CZ2:DC2").AutoFill Destination:=Rng, Type:=xlFillDefault End Sub
Fantastic Dave, worked like Magic. Thanks much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks