activesheet

  1. J

    How to use ActiveSheet when sorting/filtering in VBA

    I'm trying to create a macro to, among other things, sort, filter, and delete rows. From the macro recorder, I get: Range("A2").Select ActiveWorkbook.Worksheets("TXHLPFKP381540").sort.SortFields.Clear ActiveWorkbook.Worksheets("TXHLPFKP381540").sort.SortFields.Add Key:=Range( _...
  2. G

    Possible to use ActiveSheet.name in formula? NOOB

    First, I believe the activesheet.name is a value that changes each time a new tab is selected? If I'm wrong there, the rest of this is not going to make sense. Please correct me if mistaken. If Sheet3 has lots of data collected, I'd like to sort the data depending on which of the other Sheets...
  3. V

    Reference Sheet in Add-In not Active Workbook

    I have an add-in that has a formula that uses a named range on one of it's sheets to lookup values needed to complete the calculation. My question is how do I in the formula located in the Add-in reference the sheet in the Add-in and not the ActiveWorkbook: Snippet of my code in the add-in...
  4. Felix Atagong

    Workbooks.Open does not activate the workbook

    I have a workbook containing macros that opens a second one (no macros) and does some 'data mining'. The following VBA is used for that (I use this code on dozen of files and it has always worked, except here): Set WshShell = CreateObject("WScript.Shell") ChDir...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top