Hi,

I have this problem when I run excel macro below on a new worksheet
where there is no data except the header on row1, then the excel
formula still copying down the whole column A with 0 value and it will
stop copying until the last used cell if there is data on column A
How can I modify this excel macro to decide whether to copy the excel
formula will depend on the data available on column A ( ie starting
from A2 ) of new worksheet

Range("A1").Select
ActiveCell.FormulaR1C1 = "=VALUE(RC[2])&RC[6]"
Dim rng2 As Range
Set rng2 = Range(Cells(1, 2), Cells(1, 2).End(xlDown))
rng2.Offset(0, -1).Formula = Cells(1, 1).Formula

Thanks in advance, I’m a excel VBA beginner
Regards
Len