Hey all,
How would I be able to get to a specific column number using vba script?
For instance, in cell B2 of sheet name "HSheet" is a numerical value of 8
And I could be on any other sheet other than HSheet of my active workbook. On triggering the code I should be now at my desired column H. (8)
Similarly if B2 of sheet "HSheet" value was 4. The code should now take me to column D of my active sheet.
Will appreciate..
How would I be able to get to a specific column number using vba script?
For instance, in cell B2 of sheet name "HSheet" is a numerical value of 8
And I could be on any other sheet other than HSheet of my active workbook. On triggering the code I should be now at my desired column H. (8)
Similarly if B2 of sheet "HSheet" value was 4. The code should now take me to column D of my active sheet.
Will appreciate..
Last edited:
