Hi I need some help with some macro programming.
I need a code that will take the number in the first cell (eg.2.1 or 3.1 etc) and increase it by .1 for each cell in the selection after.
It needs to ignore hidden cells and increase the formatting to two decimal places once it gets to .10 and continue.
It also needs to ignore any hidden cells.
Your help would be greatly appreciated.
Hi,
as far as I understood this you don't want to just add 0.1 to the number but add it to the decimal part of it?
If this is true try this code:In case I misunderstood you, sorry.
Please Login or Register to view this content.
Regards
Please use [CODE]-TAGS
When your problem is solved mark the thread SOLVED
If an answer has helped you please clickto give reputation
Read the FORUM RULES
Another method.
Please Login or Register to view this content.
Last edited by AlphaFrog; 04-18-2013 at 08:38 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks