Unlimited Range for VlookUp in Macro Code
I am trying to program a Vlookup for Column C, however the macro will be used for more than one report. Can anyone show me how to program the range to be unlimited? When I put C655636 (the max amount of rows for Excel 2003), Excel freezes and will not respond. This is one part of a very large macro but I can not continue until this is solved.
Your help is appreciated!
Thanks!
Please Login or Register to view this content.
Last edited by fmfernandez11; 01-11-2013 at 11:16 AM.
Howdy:
Do you think that the problem may be memory-related with a range that large?
When I have that type of thing to do, I only copy the formula into the rows that actually need it. If only 200 cells have data, for instance, the range would be modified to read "range("c2:c200")". Partial prototype code is as follows:
HTH.Please Login or Register to view this content.
Bob
Thanks for your help. I tried using it the first option and I have the Vlookup formula in one cell and I am trying to drag the formula down to the rest of the cells. That number of cells is undefined. Any ideas?
Please Login or Register to view this content.
Last edited by fmfernandez11; 01-11-2013 at 11:14 AM.
upload a sample file
The error message appears in the
I have changed the range to "C2:C" and I have also changed the formulas to the ones given above by bstubbs. I recently tried this as well :Please Login or Register to view this content.
but it did not work. Im in a desperate need of help.Please Login or Register to view this content.
Last edited by fmfernandez11; 01-11-2013 at 11:15 AM.
We would love to continue to help you with your query, but first, before we can proceed, please see Forum Rule #3 about code tags and adjust accordingly...
HTH
Regards, Jeff
I have adjusted according to the rules.
Try this: The LastRow can be either the lastrow used in a particular column, OR it can be the last row used in your spreadsheet (but only one; you'll need to delete the line you DON'T want to use). After determining your LastRow, the VLookup is inserted in each cell in column C beginning with C2 to C and your LastRow.Please Login or Register to view this content.
Last edited by jomili; 01-16-2013 at 09:48 AM.
Thank you so much! It worked greated.
I really appreciate it.
It is very useful! Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks