Name a range based on worksheet/tab name

[Lefemmenikita]

Hi


I have recorded a macro to see the code to do this though am stuck.


I am trying to create a named range in a worksheet, for a data range that changes monthly.

I want the name of the named range to be based on the name of the worksheet the data resides in.



For example, if the worksheet is named 'sheet1', I want the named range (cells A1; last used row & column) to be called 'sheet1'


Is there a way to do that via vba?


The problem is at the moment, the only way that I am able to 'extract' the name of the worksheet is by double clicking the tab name and copying & pasting it into the named range field.

I want to automate it so that the named range automatically picks up the worksheet/tab name


Thanks

 

[Rijnsent]

Hi Lefemmenikita,
how far did you get with your VBA? Did you already record/build something? If so, please post it here (in [CODE][/CODE] brackets).
Thanks,
Koen

 

[Lefemmenikita]

Hi. No I didn't manage to get a code to work. the issue is still around how to get the vba to recognise the name of the sheet without having to double click the tab name