WigiCode:Sub selecting() Dim rng As Range Set rng = Range(Range("A1").Value, Range("A2").Value) rng.Select End Sub
Right, I need to select an area of cells on a sheet, but I need the values to be based on the values of two cells.
Cell A1 contains "C8"
Cell A2 contains "C12"
I need a piece of code that will select the area "C8:C12" using the ranges of the cells.
If you can help thats fantastic. Thanks in advance!
Sorry! It's okay. I've actually found out how to do it, but for those of you who might need it some time...
I used a concatenate function, to join them,
Using the example from before,
Text1 = A1
Text2 = :
Text3 = A2
I placed this function in cell A3.
Then in the code:
This will select the range between two points based on two values!!
Sorry for answering my own question!! but thanks for reading anyway.
There are currently 1 users browsing this thread. (0 members and 1 guests)