I'm sure this one will be easy for many of you, but right now I just don't see why I'm getting a Run-time error '9", Subscript out of range on my assignment statement. Here's the code:
LastRow = 442 in my case, and it fails on the first assignment statement. I'm just trying to make the 7th column = a concatenation of the 1st 6 columns. Any ideas?
Please Login or Register to view this content.
Try:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Change
toPlease Login or Register to view this content.
Please Login or Register to view this content.
That worked! Can you explain why yours works and mine wouldn't? I'm pretty new to arrays.Originally Posted by jindon
Change
toPlease Login or Register to view this content.
Please Login or Register to view this content.
Even you dimension the array to a particular size, it will automatically resize when you load the value from the range.
So you will need to resize the array afterwords.
Makes sense. I never knew that. Thanks.
Deleted. Jindon already provided an answer.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
You are welcome and thanks for the rep.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Your tagline, "Avoid using Select, Selection and Activate in your code. Use With ... End With instead." intrigues me. Is there a write-up on this somewhere? I'm always wanting to learn better techniques.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks