filelocation

  1. B

    How to not require a sheet to be 'selected'

    Hi team, I've gotten into the habit of creating code like so, which requires the .select behaviour. Which is all well and good but I now want to not have to make tabs visible due to the limitations of my code. How would you suggest I get the same output, without the use of .select which...
    • Benlav
    • Thread
    • .select filelocation lastrow requires thisworkbook.sheetsfile
    • Replies: 5
    • Forum: Excel Questions
  2. S

    formulaR1C1 with a variable and cell's value

    I would like help if someone can be so kind... I've been testing different ways long enough... no hair left... literally. Trying to make a formula that when pasted in a cell range will use a file path as a variable and a cell's value that will change according to its location.... Dim...

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