so i have assigned a row number to a variable 'rownum' . i have selected column B and gave it the named range of col_b_rng. in my code i have this:
on the col_b_rng = Range("B:B") line i am receiving a Method 'Range' of object '_Global' failed error
Please Login or Register to view this content.
can anyone help me rearrange this so it works? i was simply typing the column number in instead of a name but i am trying to simplify things. is this possible?? thanks!!
Hello fredderf81,
Excel will not allow you to rename a range column or row using the system labels "A,B,C..." for columns or 1,2,3... for rows. It would prevent Excel from working. The workaround is to create a named range that starts with the first cell of the range down to the last.
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!)
ahh yes! excellent!! thank you :-)
Hello fredderf81,
You're welcome. Thanks for marking the post as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks