Dear All Exceliers,
I have some code which I have trouble getting to work. It is for finding the value of the rightmost cell of each row. The "dd" variable is a string that is outputting column ranges as expected, but once it is place in as argument in the INDEX formula, it doesnt work. Can any kind soul help me out a little. Your help is greatly appreciated. Thanks, Andy!
Please Login or Register to view this content.
That's because you are actually typing the text value dd... you need to pass in the variable to build the string using ampersands & like this:
You appear to be using "+" where I would use a "&" ... so you may need to alter my code - but the idea is the same. The worksheet function INDEX() needs the Address the dd variable is storing - not the actual letter 'dd'Please Login or Register to view this content.
Edit: Also - I don't know what you are doing with the DD in the 'column' parameter. I don't believe that will work.
Wouldn't you just want this?
Please Login or Register to view this content.
Last edited by GeneralDisarray; 08-14-2015 at 09:37 AM.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks