Refer to Code Name of Sheet not Name of sheet within sort

**forrestgump1980** · 07-20-2016, 11:11 AM

HI there,

I am trying to change the code below so that the code refers to the sheet code name and not the name of the sheet i.e. "TestData". I tried ActiveWorkbook.sheet2.Sort.SortFields.Clear and ActiveWorkbook.sheet2.name.Sort.SortFields.Clear. But to no avail. Any help would be appreciated.

Please Login or Register  to view this content.

Kind regards,

James Elwell

**Norie** · 07-20-2016, 11:25 AM

Just use the Sheet2 on its own without any workbook reference.

**forrestgump1980** · 07-20-2016, 11:29 AM

Thanks Works great!

Refer to Code Name of Sheet not Name of sheet within sort

LinkBack

Thread Tools

Rate This Thread

Display

Refer to Code Name of Sheet not Name of sheet within sort

Re: Refer to Code Name of Sheet not Name of sheet within sort

Re: Refer to Code Name of Sheet not Name of sheet within sort

Thread Information

Users Browsing this Thread

Similar Threads

Code For A Custom Sort Using A List On Another Sheet

Make macro on copied sheet refer to the new sheet?

[SOLVED] How to refer to the (NAME) of the Sheet rather than the Name of the sheet in my macro

1)Vlookup refer to diff sheet based on date 2)Dropdown populate from 1 cell in each sheet

help with vba code that will run a macro that will sort by name and create a new sheet

[SOLVED] How to refer to a sheet in the workbook when the name of the sheet is a value in a cell

[SOLVED] Refer new sheet to previous sheet

Bookmarks

Bookmarks

Posting Permissions