Hi Guys,
I was really hoping you can help here. I have a bit of code that I've been creating the issue is the VBA range keeps on shifting every time I run the macro. The Workbook has some set formulas in the cells. I've read that I should name ranges but I think there are too many. please could someone be so kind and assist, it's driving me insane. Thanks in advance
Example Range A:AA becomes B:AA or A:AB etc
Hello relo,
What did you expect to happen once columns were inserted into the worksheet ?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith, thanks for replying, much apprecaited. I expect the formula to remain static as intended.
For example in G12 the formula is =VLOOKUP(--RIGHT(C12,8),Tenant!A:BI,20,FALSE)
This will change once the macro is run to =VLOOKUP(--RIGHT(C12,8),Tenant!B:BK,20,FALSE) therefore producing N/A and this happenens for every formula.
Thanks
What about fixing the formula
=VLOOKUP(--RIGHT(C12,8),Tenant!$A:$BI,20,FALSE)
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Thought that initially but no difference. Example of a recent run
Pre macro
=VLOOKUP(--RIGHT(C12,8),Tenant!$A:$BI,20,FALSE)
post macro
=VLOOKUP(--RIGHT(C12,8),Tenant!$B:$BL,20,FALSE)
So every result becomes #N/A
Any other ideas, thanks again in advance
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks