Copy/paste formula to variable # of data
Solved/Closed
Related:
- Copy/paste formula to variable # of data
- Transfer data from one excel worksheet to another automatically formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Tmobile data check - Guide
- Number to words in excel formula - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 14, 2011 at 04:51 AM
Nov 14, 2011 at 04:51 AM
not clear. whatever be the length of colun A and you are having a formula in B1(or B2 if B1 is column heding) you can copy B2 down provided you take care of absolute and relative references of cells in the formula
post the formula in B2
post the formula in B2
Nov 20, 2011 at 06:30 PM
Selection.AutoFill Destination:=Range("B7:H" & Range("A" & Rows.Count).End(xlUp).Row)