Hello Everyone
I need a VBA code which would insert one new row if a "1" appears in column N of my sheet. So if a 1 appears in Cell N4 then a new row is inserted above it....
Please Help
My code is actually going into an infinite loop....
Regards
Sourabh
The trick is to work from the bottom of the sheet UP to avoid an infinite loop:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
This code might help
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks