Sheet name change.

[JapanDave]

I am trying to change the name of a sheet to coincide with the contents of a specific cell on a different sheet. In this case the cell will be "A2". The contents of cell A2 is "1002", and this is the problem. I will use this macro over and over and as it is it will always paste the value "1002". How do I make so the macro will copy the contents of the cell at that time and not actually write the value in the macro, but paste what is being copied at the time of running the macro?

Not much of an explanation , but that is the best I can do.

This is the code.

Please Login or Register  to view this content.

[Andy Pope]

Store the information in a variable rather than copying the cell.

Please Login or Register  to view this content.

[JapanDave]

Thanks Andy, That works for that application.

However I tried that for other copy/paste data and I get an error. I am not sure what I am doing wrong?

Please Login or Register  to view this content.

[snb]

or

Please Login or Register  to view this content.

[Andy Pope]

that code is naming a range not a sheet. Is that what you wanted to be doing?

Please Login or Register  to view this content.

[JapanDave]

Yes, you first reply answered that question. Thankyou.

But I found that I was have the same problem when coping data from one sheet to another sheet in specified cells, so I tried to use that code. Sorry , I am still only just learning the basics of VBA and I still don't know what you can and can't do.

Cheers

Dave

[JapanDave]

@Snb, does the last part of your code where is says "Cells(2, 1)" ,referring to the cell "A2"?

[Andy Pope]

If you want to copy and paste cell content then you can use

Please Login or Register  to view this content.

[snb]

Cells(2, 1) is equivalent to Range("A2") or [A2]

[JapanDave]

Can I use that copy from say sheet1 to sheet2, would it look like this?

Please Login or Register  to view this content.

Cheers

[JapanDave]

@Snb, thanks, thats what I thought.

Cheers.

[JapanDave]

Well ,my code did not work.

[Andy Pope]

because that is not how you reference sheets and ranges.

Please Login or Register  to view this content.

[JapanDave]

Thanks Andy, that really helps me out. Slowly but surely I am getting understand macros. You have rep points.