I have calculation sheet from column C to F at rows 2 there are formulas .
Trying how to use vba to insert the formula automatically still to last row based on A .
I have calculation sheet from column C to F at rows 2 there are formulas .
Trying how to use vba to insert the formula automatically still to last row based on A .
Select Developer then Start Macro Recorder
Select Each Formula cell in turn, click inside the formula bar and press enter
Stop the Macro Recorder.
You will have a macro like:
Please Login or Register to view this content.
Below is my list of Standard formulae.
Save it somewhere.
Please Login or Register to view this content.
From my list of standard Formulae use LR ie Last Row
Using that line we can easily modify the recorder macro to give:=Please Login or Register to view this content.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks