LinkBack URL
About LinkBacks
I can't see the problem with this formula but I get the following error message.
Method range of object global failed
Thanks in advance
Please Login or Register to view this content.
I can't see the problem with this formula but I get the following error message.
Method range of object global failed
Thanks in advancePlease Login or Register to view this content.
Try Range("AW3:AW" & SecondLastRow - 1).value
Elegant Simplicity............. Not Always
I found the problem. I had not used Dim for SecondLastRow. I have used the following code to select two entire columns:, but get an error message. Can someone correct this please?Please Login or Register to view this content.
I am now getting this formula in the cell range?
=VLOOKUP(AT3,Range("J3:J" & LastRow - 1),8,FALSE)
Thanks in advance
The formula reflects #NAME? in the cells. It is not selecting my LastRow range?
Thanks in advance
I changed the code as follows but get the following error: [Object variable or With block Variable not set]:
Thanks in advancePlease Login or Register to view this content.
This is the code I am using but the formula in the cell uses [LookupRange] instead of the range J3:J2565?
Thanks in advancePlease Login or Register to view this content.
I would really appreciate some help as I have been struggling to resolve without success.
Thanks in advance.
The Original problem where it was posting a NAME error was because the function was being entered into the worksheet like :
=VLOOKUP(AT3,Range("J3:J" & LastRow - 1),8,FALSE)
The problem there is with LastRow which is only applicable in the VBA script NOT the worksheet.
The second mistake was in the use of quotation marks
Third mistake was in your VLookup - you only looked up a single column but wanted a return from the 8th column
4th was to specify a worksheet range in the worksheet using VBA syntax
Incorrect
Range("AW3:AW" & SecondLastRow - 1) = "=VLOOKUP(AT3,Range(""J3:J"" & LastRow - 1),8,FALSE)"
Correct
Range("AW3:AW" & SecondLastrow - 1) = "=VLOOKUP(AT3,(J3:U" & LastRow - 1 & "),8,FALSE)"
Don't forget to Dim Lastrow and assign a viable value to it
Thank you very much Andy. Much appreciated.
Any Time bud... Sorry I didn't give it as much attention yesterday ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks