Hi,
currently I have the following code that allows me to change the number format to % for each range.
However, I now need to insert a column after each initial column, and this number format will be $.00
So how can I amend the code to ensure each column has the desired format?
Now I need for % format: col D,F, H, J,L,N, etc.
Please Login or Register to view this content.
and $ format for col E,G,I,K,M, etc.
How about this ?
Then for the $ format the same but starting from 5 instead of 4.Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
thanks bakerman.
It works until it gets to col I but then I have a blank col (J) and it starts again from K:P. This is followed by a few more blanks. Col K shows % but then so does L and then I have $ format in col M and % in Col P. Perhaps I haven't done it correctly?
I am using:
Please Login or Register to view this content.
hmmmm set first two columns then copy and paste special for the rest?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
No probs here, every second column has the correct format.Now I need for % format: col D,F, H, J,L,N, etc.
and $ format for col E,G,I,K,M, etc.
Or else I'm missing something.
Please Login or Register to view this content.
thanks but I tried this again and when it reaches col K it is in $ format. This throws the rest out.Originally Posted by bakerman2
No probs here, every second column has the correct format.
Or else I'm missing something.
Please Login or Register to view this content.
Col J is blank but I noticed it is in % format. So perhaps I need to account for this blank column as it should start with % again from col K?
it should start out as every second column, but the problem is then the ranges change. So it starts with col D-I (and this works fine), then K-P, then V-AA, then AC-AH, AN-AS, and so on.
Last edited by maym; 09-28-2017 at 09:05 PM.
how about
HTH,Please Login or Register to view this content.
Maud
Why didn't you mention this in your opening post ????
This is something completely different then what you first said.
So basically you have 6 filled columns - 1 blank - 6 filled columns -5 blank - 6 filled columns - 1 blank .....and so on.
account for the blanks....
i'm sure the "I" structure can be done algebraically ..but left it as is so you can follow why its being changed like it isPlease Login or Register to view this content.
sorry yes, I wasn't clear in my opening post. Apologies.Why didn't you mention this in your opening post ????
This is something completely different then what you first said.
So basically you have 6 filled columns - 1 blank - 6 filled columns -5 blank - 6 filled columns - 1 blank .....and so on.
Yes, this is how it is set out. 6 filled columns, 1 blank, 6 filled columns, 5 blank, and so on.
thanks humdingaling. Yes that will work, the only problem is that I have over 100 columns, so I will need to go and add more of the "I" structure to account for this.account for the blanks....
i'm sure the "I" structure can be done algebraically ..but left it as is so you can follow why its being changed like it isPlease Login or Register to view this content.
sorry did testing didnt work properly refer to next post
Last edited by humdingaling; 09-28-2017 at 10:16 PM.
try this instead
Please Login or Register to view this content.
mod and k not required as i reset counter in codePlease Login or Register to view this content.
perfect humdingaling! Seems to be working fine, but I will do some more testing. Thanks so much for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks