sheet.name

  1. A

    VBA - Hide or Unhide bunches of tabs

    Hi All - Note I did not say "Group" in the title of this post so no-one misconstrues this question with tab function of group and ungroup. After wrestling the following macro to the ground, I was wondering if I am asking too much to write a second worksheet.activation macro that would do the...
  2. A

    Excel not renaming the copied sheet if name already exits

    I have written below code but its not working as required: My requirement is: Copy Sheet1 of Source.xlsm workbook to another workbook, s.xlsx and then rename the copied worksheet to value of D1 cell of this sheet. If sheet name of same name do not exists then it should rename and if name exits...
  3. M

    How to use spinbutton to alternate among sheets?

    Hi, I imagined a command to open a spreadsheet containing a typed text (textbox1) in its name. CityName = textbox1.text For i = 1 To Sheets.count If InStr(1, CityName, sheets(i).name, 1) <> 0 and InStr(1, CityName, sheets(i).name, 1) <> Null Then Number_of_Found_Sheets(j) = i j = j+1 End...

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