Error 1004: Application-defined or object-defined error on Range(Cells(x,y)) syntax

Hi all,

First post here, hope I can find an answer to my issue.

I'm designing a code where I try to have it to draw a line from a user-selected cell.

The code is:

Please Login or Register  to view this content.

The problem is on the fifth line of code, where I have the .Range(Cells(TRow, TColumn)) statement. I was trying building it with dummy cell references at first, but ultimately, I wanna use my variables in there, so it's dynamic.

As soon as I change the Range("H4") to Range(Cells(x,y)), I get the error. I have tried to qualify the range better, with .Range(.Cells(4,9)) (used numbers to make sure my variables were not the source of the problem) but to no avail. I have been looking all over the web for this type of error and I always get solutions of the type I just mentioned.

Hope someone can help!

Best,

Winch

Note: The code is in a userform. Variables are provided to the form via code (I checked and they do indeed contain the correct values). The code was originally in the Module, tried to move it to the form in my troubleshooting attempts.

range(cells(r,c).address)

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Try using the Worksheet.Cells property and not the the Range.Cells property e.g.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

etc.

.. and welcome to the forum!

Great, glads to be of help!
Please mark the thread as SOLVED
Barry