Cell Reference returns error

I have some code where I find the last cell in a column, and add 1 to it so that I can input information into the next row.Note the two lines below. The first is what I want as each time the value of Z will change. The second is a manual code just for testing. The second line works and the first does not. The value of Z in my test is 382.

What have I missed? Thanks in advance for your help.

Please Login or Register  to view this content.

Originally Posted by wiwchar

I have some code where I find the last cell in a column, and add 1 to it so that I can input information into the next row. Note the two lines below. The first is what I want as each time the value of Z will change. The second is a manual code just for testing. The second line works and the first does not. The value of Z in my test is 382. [....]

Please Login or Register  to view this content.

If Z is 382, Range("A382") is not an example of "add[ing] 1". Assuming you meant "A383", perhaps the following does what you require:

Please Login or Register  to view this content.

Jaslake,

Thanks for the quick response. Z is the variable here to provide the row number. I have a starting point of B3 and then

Please Login or Register  to view this content.

This provides me with a value of t from

Please Login or Register  to view this content.

Then I have

Please Login or Register  to view this content.

So in my testing, initially t = 381, then increments to 382 and assigns that value to Z. I want the information from another workbook that is in C1 to go into this workbook in cell A382.

Hopefully I have explained this a bit better. I tried the code, but could not get it to work.

Thoughts? Maybe there is a better way than what I am attempting.

Excellent. Thank you all for the quick responses.

Have a great day!