Hi,
I would like to seek for any help regarding below codes:
My concern is if column A is totally empty and someone attempt to click the button that contains the above macro then all the headers above (E3 and F3 will be messed up, they will also turn into formula.
I humbly ask you to please help me with this one. I wish to have a revised codes that even though I have empty column A and someone attempt to click the button with macro, my headers will not be cleared and turn into formula.
Please help me.
Any help will be highly appreciated. thanks a lot in advance!
best regards,
papajups
I would like to seek for any help regarding below codes:
Code:
Range("E3:F3").Autofill Destination:=Range("E3:F" & Cells(Rows.Count, "A").End(xlUp).Row)
My concern is if column A is totally empty and someone attempt to click the button that contains the above macro then all the headers above (E3 and F3 will be messed up, they will also turn into formula.
I humbly ask you to please help me with this one. I wish to have a revised codes that even though I have empty column A and someone attempt to click the button with macro, my headers will not be cleared and turn into formula.
Please help me.
Any help will be highly appreciated. thanks a lot in advance!
best regards,
papajups