Hi Guys,
I require my "Example Sheet" to in a Blank Row based ont he value in Column "C4 to C25". If the numbers is <6 than insert a blank row below.
i.e. If C5 is Value is less than 6 than insert a new row below.
Please find attached the sheet for your attention.
Please Login or Register to view this content.
I copied the following code however it is not working. Thanks for trying though. Do i need to alter anything or just copy paste the code?
You might need to change the name "Example Sheet" in the code
And ofcours it needs to be placed in a sub
Please Login or Register to view this content.
If solved remember to mark Thread as solved , to mark your thread as Solved select Thread Tools and click Mark thread as Solved.
I can't read the mind of my wife so then I get picture but no sound .... and then I mostly get the idea, same goes here picture your outcome and I get the idea.
Obviously i am doing somethign wrong. Would you just able to upload the working sheet material for me if that is okey for you. Sorry to be the pain as i am not getting this to work at all.So Sorry once again.
wish i could but firewall setting do not allow file upload
oven VBA editor once your in your file
then insert new module
copy below to the righthand-side
now make sure you have some values in C5-C6-C7-C8 and then click on play to execute macroPlease Login or Register to view this content.
here you go , click button 1
Thank you so much. appreciate allt he help from you buddy. Thank you once again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks