LinkBack URL
About LinkBacks
Here is my current code but if I insert a new column its a hassle to make the same process again. Any suggestions?
Please Login or Register to view this content.
Here is my current code but if I insert a new column its a hassle to make the same process again. Any suggestions?Please Login or Register to view this content.
Last edited by saechaoc; 06-24-2015 at 03:45 PM.
Does this make it easier?
Please Login or Register to view this content.
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
You are referencing static column numbers. When you insert new columns they column numbers change but your static numbers in code do not. You need some type of dynamic column number. Without an example of your workbook it is hard to create a dynamic approach unless you want to just apply to all columns.
Try, here until column 8
Please Login or Register to view this content.
- Battle without fear gives no glory - Just try
What he said ^^ I need it to be dynamic but the columns are going to be enclosed. Meaning they start at i = 2 and end at iCol - 7.Originally Posted by stnkynts
icol being the range of columns - the outside columns (there are 7).
See
Please Login or Register to view this content.
that is something similar to what I want. thanks for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks