Hi,
I am trying to extract a range reference for one column (looping for all columns) that can be used in an excel formula out of a predefined range in VBA.
So I have a predefined range of say A1:C10 called myRange and I am trying to output "A1:A10", "B1:B10" and "C1:C10" as range references. I have tried Index combined with address (and many other methods) but it doesn't seem to work.
Hello DH123,
Welcome to the Forum!
This will output the column number and the column address for the named range MyRange.
Please Login or Register to view this content.
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!)
Thanks for the help. I tried that method and it threw a global error. The workaround I found was to parse in as a string first and then use that string within the string for output as a formula as below.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks