for example, col A1 has certain values. In col B1 i require 110% of the value in cell A1. example, value in A1=100 say B1 will have a formula =A1*110%
Now the first scenerio, i have a file with 100 records, and if i record the macro giving formula in B1 and then click on AUTOFILL the contents will be autofilled till the end of the record count (as in Col A ie upto A100)
Range("B1").Select
ActiveCell.FormulaR1C1 = "=RC[-1]*100%"
Range("B1").Select
Selection.AutoFill Destination:=Range("B1:B100")
Range("B1:B100").Select
But when i process the next file (say this has 200 records) so if i run the macro, the autofill works upto B100 only. I want the macro to automatically find out the no of records in Col A and execute the command till that range.
How should i go about