string to range

  1. M

    Convert string to range

    I have a string variable called Bob that contains the value D2 and need it to convert it to a range called BobR. How do I do this? I tried Dim bob As String Dim bobr As Range bob = "D2" bobr = bob this is not an actual piece of my code exactly but I need to know how to do this in order to...
  2. I

    Convert a string to cell reference in VBA

    I have a piece of VBA code like this 'Cell A1's value is G4 varName = Range("A1").Value Range("C2").Formula = "='Sheet2'!" & varName What I'm trying to do is write this formula Sheet2!G4 within cell C2. Essentially, I guess I'm trying to achieve an indirect. But when i run it, C2's formula...
  3. W

    Dynamic Range in Xcelsius

    I am working in Xcelsius 2008 and I have created about 100 defined names. These refer to cells on Sheet2 that create ranges. I am having an issue calling the range as it gets returned as text. E.G.: I am using the following to build a range based on where the column header is found...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

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
Top