worksheet access

  1. M

    vba function ThisCell.Address

    I have this function: Function student() student = Range("'" + Range("B1").Value + "student'!" + Application.ThisCell.Address).Value End Function I use this function in worksheet1. The value in B1 gives the name of another worksheet, let's say ws2. I need to pick up the value in that other...
  2. B

    Using a variable for worksheet name

    Hi all - first, let me say this is an enormously helpful forum! For weeks I've found every answer I needed without even registering. I will be sure to contribute back as/when I'm able! I have an issue using a variable as a worksheet name. I have code finding the first name of a user from...
  3. R

    Username Access to Different Sheets

    I have been reading the post of "Rights Management" and I could not figure out why my code doesn't work. For the 15 worksheets in the workbook, the management can read all while others can access only a number of them. There is a password to open the file. However, since the management do not...

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