I am rather new to VB and I am trying unsuccessfully to combine two formulas into one.
Rows(5).Select ------ This formula lets me select row 5 of the current worksheet
‘data’!G11 ------ Cell G11 in the data worksheet is the one I want to substitute for row 5
Rows(‘data’!G11). ------ Select this is sort of what I am after but I cant seem to find the correct syntax to incorporate the cell into the formula. I am using it in a useform.
Any help would be appreciated.