Convert string to range

[mmetzinger]

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 do my bigger piece.

 

[DonkeyOte]

In general terms - in R1C1 context:

FillToR.Address(,,xlR1C1)

however, I think your code is likely to fail (R1 is 0 to start with) and I believe there are possible improvements to be made, however, we'd need to have a better feel for the layout of your data.

I *think* you're looking to populate Column D with "next C Total" / "current C Total" for all "Total" rows.

If you could provide a little screen shot of your layout that would help... I use Excel Jeanie myself.

 

[Richard Schollar]

If you could provide a little screen shot of your layout that would help... I use Excel Jeanie myself.

And I use my own add-in which you don't need to install and you can also review all the code and see how it works if desired. Not available on download though - please send me a PM if interested.

 

[GlennUK]

...