Is it possible to have an absolute reference for part of a vba formula...
I want to copy a formula in each of the cells up to the last column (which varies) but there is a constant in P2.
I currently have
The first R[-5]C[13] needs to be absolute .. is this possible?
Please Login or Register to view this content.
If R[-5]C[13] must refer $P$2 you may use R2C16 instead.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Nonsense deleted. Blonde moment!
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
In your spreadsheet, change the formula set up to R1C1. Paste your formula into a cell. Now change the R1C1 back to the standard method, change your formula to make P2 absolute. Now change back to R1C1. Copy the formula and paste into your VBA. Don't forget to change R1C1 back to standard.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks