retrieve name

  1. P

    Retrieve only visible Sheets Names to a range

    Hi I'm trying to retrieve the worksheet names to a specif cell and populate from that point only with the names of the visible sheets, but It keeps returning only the last visible sheet name and not the sheets that are visible. Could someone plase point me to where the code is failling - I'm...
  2. S

    Working with NamedRanges in VBA

    This might be elementary, but I cannot get it to work. I need to name range in VBA, work with the named ranges afterwards and change the names. I have split it into e couple of questions below. 1. Naming a range By using 'Worksheets("Ark1").Range("C4").Name =...

Some videos you may like

This Week's Hot Topics