temujin
01-24-2018, 01:39 AM
Hi,
I am relatively new working with VBA and I am having some troubles writing a macro. I have a Workbook with two worksheets. In the first one I introduce some data and the second one is some sort of backup worksheet where changes in some columns in the first one are saved.
I was able to program a script to detect Worksheet_Change so if I rewrite a single cell, the new data are also copied in the backup worksheet. The problem is that oft I need to do Autofill (click right-down and scroll) when I want to use the same formula in many cells and this is not detected by the Worksheet_Change routine. Is there anyway to detect this Autofill event so I can programm the require action?
Thank you very much
I am relatively new working with VBA and I am having some troubles writing a macro. I have a Workbook with two worksheets. In the first one I introduce some data and the second one is some sort of backup worksheet where changes in some columns in the first one are saved.
I was able to program a script to detect Worksheet_Change so if I rewrite a single cell, the new data are also copied in the backup worksheet. The problem is that oft I need to do Autofill (click right-down and scroll) when I want to use the same formula in many cells and this is not detected by the Worksheet_Change routine. Is there anyway to detect this Autofill event so I can programm the require action?
Thank you very much