I'm writing a small macro to copy and paste the partial row of data. The data will be updated everyday i.e. row 30 will row 31 tomorrow. I'm using a macro to indentify the poistion of the beginning cell and the end cell but I don't know how to put it in the Range() function.
Range("C458".Select
Selection.End(xlDown).Select ---> Start Cell
Range("AG458".Select
Selection.End(xlDown).Select ---> End Cell
Range("C459:AG459".Select ---> to be replace with start cell address and end cell address
Selection.AutoFill Destination:=Range("C459:AG460", Type:=xlFillDefault
I replace C459 with R1C1 and AG459 with R1C32. Execl won't accept them. I also try to use Cell("address" in order to copy and store the Start/End address then use in the Range() but I don't know how to copy them.
Thanks for your help and sorry for this long message.
Range("C458".Select
Selection.End(xlDown).Select ---> Start Cell
Range("AG458".Select
Selection.End(xlDown).Select ---> End Cell
Range("C459:AG459".Select ---> to be replace with start cell address and end cell address
Selection.AutoFill Destination:=Range("C459:AG460", Type:=xlFillDefault
I replace C459 with R1C1 and AG459 with R1C32. Execl won't accept them. I also try to use Cell("address" in order to copy and store the Start/End address then use in the Range() but I don't know how to copy them.
Thanks for your help and sorry for this long message.