Hey,
I just need to insert formula in a cell through vb code.
I use Leith Ross code for this macro. But I have more than 5000 rows.
Every time this macro insert formula from the first to till last row,
that consume more than 20 minutes.
Is it possible to find only the last Row and insert formula.?
Your help is much appreciated.
Please Login or Register to view this content.
Charles
Last edited by ebin charles; 06-29-2011 at 02:41 PM.
Try
Please Login or Register to view this content.
Martin
Hello Charles,
You only want to insert the formula into the last row the sheet? Use this macro.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you very much.
It's not working when I apply this code exactly.
I need to insert this formula last row of J, K and M. But I couldn't.
regards
charles
Try this change
...Please Login or Register to view this content.
Thank You, Mike
Some Helpful Hints:
1. New members please read & follow the Forum Rules
2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
3. If you are pleased with a solution mark your post SOLVED.
4. Thank those who have help you by clicking the scales at the top right of the post.
Here...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks