vba formula reference to unknown worksheet names

[andybhoy]

Hi can anyone help me with a problem I'm having around referencing unknown worksheet names. I've just started using VBA so not too clued up i'm afraid.

I currently have a user form and depending on the answers given, this creates the worksheet name. The worksheet therefore has an unknown name in my VBA coding
I then run a macro from this unknown named sheet which looks to other known named worksheets.
I then want to transfer the information from the known named worksheet back into the unknown one.

I can get the unknown worksheet name into a cell on the known named sheet, so maybe there is a way to reference the cell as the unkown worksheet name to put the information back in?

Any help much appreciated.
thanks

 

[DauntingGecko]

You're after a public variable my friend.

Plenty of help online if you google "VBA variables". They allow the PC to remember a value that changes.

Option Explicit

Sub myExample()

    Dim aVariable As Variant
    
    aVariable = "Hello!"
    
    MsgBox aVariable

End Sub

 

[andybhoy]

thanks mate, much appreciated. As I say just new to this and trying to learn as I go