I would like to adjust the range in this VLOOKUP to include more of a range sometimes my range is only 1000 rows and sometimes it is over 100000 rows.
right now it is only reading 5281 rows how can I adjust this?
Please Login or Register to view this content.
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Would I just try the same thing with
for when it auto fills the range F3:F5264Please Login or Register to view this content.
How would I change that one
Same thing:
Please Login or Register to view this content.
Thanks that worked great
Sorry heres another one this one is for inside the chart data ranges.
How could this one be changed to show entire range in know this range is over 4000 nowPlease Login or Register to view this content.
can it be done like the other one? Just the range with the last 2 "xvalues & values"
Other two, in fact.can it be done like the other one?
Probably worth giving it a try
Last edited by TMS; 09-02-2014 at 03:56 PM.
Didn't work application defined errorPlease Login or Register to view this content.
Look at where the quotes are in the other two.
I keep getting expectedthen I add those and get syntax errors then says the $ is invalid characters ....not having much luck
Please Login or Register to view this content.
Yes that is how I had it and you get a syntax error which highlights the entire first row and both rows are in red.
Please Login or Register to view this content.
lLR is lower case l, upper case L, upper case R ... not numeric one (1), upper case L, upper case R
If you use Dim to define (dimension) your variables you would find that you can't have a variable that starts with a number. And, if you use Option Explicit at the top of your module, you won't be able to use a variable that you haven't defined.
Thanks I got that to work finally Ill make new post now I'm getting new error "Method 'axes of object' _ chart Failed" If I use my old set for my Range it works fine but now with the set I got to work with your help I get that message.
Should I start new Thread?
Yes. New question, new thread.Should I start new Thread?
Thanks for the rep.
I tried to delete reply. All good as of now
Last edited by bdouglas1011; 09-03-2014 at 08:11 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks