Variable naming accross a row
Posted on 2016-08-09
In vba I would like to start on Sheet1, give some columns a variable name based on whatever the active row is. So if I click on a cell, it grabs that row as the active row. Then name whatever is in column B, give it a variable name of ColB and whatever is in column H, the variable name of ColH, Once cells are named, goto Sheet2 and put ColH value in column A1 and whatever the value is of ColB in Sheet2 A3
They are random, so I cannot just use a transpose, Hope this makes sense. Please advise and thanks.