Hi! Im having trouble with spme VBA coding:
The idea is to create a code that allows me to assign a cell range through the values inside another cell.
I have written inside the cell B3 this string: "F45". Then, I start my macro, which should read the value inside B3 cell, and make F45 the activecell...
I tried making this with this code, but doesnt works:
Dim strcell As String
strcell = Sheets(1).Range("B3").Value
Is it possible to make something like that? I know that in this situation it would be easier to just write Sheets(1).Range("F45").Activate , but the desired cell needs to be stored somewhere (thought the easier way was to store it inside a cell) and is not a constant, forcing me to do something like this. Any help is truly appreciated
Thanks a lot.