Solved Select a Range based on the value of a Cell

January 3, 2017 at 13:08:50
Specs: Windows 64
Hi guys,
Struggling a bit with this one

Range 1 = (B1:AA66)
Range 2 = (AB1:BA66)
Range 3 = (BB1:CA66) etc (50 Ranges in total)

Each Range is denoted by a value C1 = 1, AC1 = 2, BC1 = 3, and so on

I have an active cell which would relate as to which range I require to print out, from another sheet within the workbook

Any ideas how I need to go about this, to select the right range . I am really not sure on this one

Regards
Tony


See More: Select a Range based on the value of a Cell

Report •

#1
January 4, 2017 at 06:03:12
✔ Best Answer
Hi Guys,
Have found the solution, as follows

colNum = Sheets("Sheet1").Range("A67")
    
    Range(Cells(1, colNum - 3), Cells(66, colNum + 22)).Select

Sorry to have bothered anyone, but would also like to wish everyone a Prosperous New Year

Tony


Report •
Related Solutions


Ask Question