Getting error in Range.End() function

[abdul hayee]

Hi Guys.
I am getting error in using Range.End() formula.
I am using this formula in two different functions but 1 function having an issue while 2nd function is working fine.
Take a look at the following image and tell me where is the issue?
excel_error.png

Thanks and best regards

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

[abdul hayee]

unable to attach excel file.
giving error "You are not allowed to post any kinds of links, images or videos until you post a few times."

following are the images of file may be it will helpful for you

form1.png
code-1.png
code-2.png

Please Login or Register  to view this content.

Thanks and best regards

[nigelog]

I have no idea why but if you cut and paste the LastRow line down to where you have lrow and rename it the code works. The only thing I can thing of is maybe the """ character

[abdul hayee]

nigelog i did it. copy and paste that line and change accordingly but the result is same. Getting Error

The only thing I can thing of is maybe the """ character

by removing "" has the same result.

[Fluff13]

On the line that doesn't work you have x1Up not xlUp it should be a lower case L, not the number one

[abdul hayee]

Thats great Fluff13.
I do it and its now working.
Thanks man

[Fluff13]

You're welcome & thanks for the feedback.