set function

  1. C

    With 'Set StrVal=ActiveCell.Address' and ‘Dim StrVal As String’ I get 'Object required' error With ‘Dim StrVal As Range’, a ‘Type Mismatch’ error

    I need to copy the ActiveCell.Address to a string variable to test if a cell is in a range for the Intersect function. I would be very grateful to anyone who could resolve this problem for me. I would also be grateful for any suggestions or comments on the other code in this macro. My thanks...
    • Cozkincaud
    • Thread
    • cell.address excel object required set function type mismatch vba
    • Replies: 7
    • Forum: Excel Questions
  2. O

    set function and variable file names

    Hi All Thanks for any help on this, I am fairly new and still learning. I am trying to develop a macro that will open, copy, (and if possible close) from about 50 closed workbooks. I am currently using this code: Dim wb As Workbook Set wb = Workbooks.Open("C:\Users\Me\Path\AA.csv", True...
    • Ox1138
    • Thread
    • file set set function variable variable names
    • Replies: 3
    • Forum: Excel Questions
  3. M

    Open a workbook with a string - failing with file not found

    I am creating a macro that will open a list of files - as held as strings in the main workbook - and then copy a named sheet from each into the active workbook. The problem I have is that the code keeps failing with file not found even though the string content is correct. Sub...
    • MariaO
    • Thread
    • copy dim open workbook with string set function workbook
    • Replies: 8
    • Forum: Excel Questions
  4. S

    Using an input box to select a cell and then using another input box to add a comment to that cell

    Hello, I have been working on a simple calendar tracking spreadsheet which has many formulas and and other macros. Therefore, I must protect the file from accidental user deletions. There are some cells that are protected such that you can't even select them while others you can select but 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