Range references not working

Can anyone explain why this piece of code doesn't work?

Please Login or Register  to view this content.

I do get a value for a and I am trying to test to make sure the Cylsize value ends up in the right place.
I just get an error, whichever way I designate the range
John

What is the value of a and where are you trying to put "Z"?

Please Login or Register  to view this content.

A Range can take two cells (giving the upper left and bottom right points of a range), but I don't think it can take just one.

Without knowing the value of a, you might try:

Please Login or Register  to view this content.

Hi stevenM,
Thanks for your interest. a is an integer with a value of a row number. What I am trying to do is to edit and add to a large table. Me.tbRow gives the row number of the row I am working on,"Z" ,(or Me.CbCylSize, plus others) is the edited data that needs to be written into row a. I had first used the offset notation of the rem'd line, but that didn't work, so I then tried the cells notation that also fails.
I hope this explains things more
John

Have you stepped through the code? What went wrong? Toggle a Breakpoint on the line:

Please Login or Register  to view this content.

Then run you code.

What is the value of 'a' when your code stops on this line?

Assuming that the variable 'a' refers to a row (and assuming that these statements are inside a "With Worksheet ... End With"), then the following statements all mean the same thing:

Please Login or Register  to view this content.

Thanks for all your comments.
It became clear that I had missunderstood the meaning of .Cells(a,1). Once I got that straight all fell into place.
Once again thank you
John