so i have assigned a row number to a variable 'rownum' . i have selected column B and gave it the named range of col_b_rng. in my code i have this: 


dim col_b_rng as range

col_b_rng = Range("B:B")   

.range("A1").offset(rownum, col_b_rng).Value = Workbooks("test.xlsm").Sheets("Main").Range("test").value
on the col_b_rng = Range("B:B") line i am receiving a Method 'Range' of object '_Global' failed error

can anyone help me rearrange this so it works? i was simply typing the column number in instead of a name but i am trying to simplify things. is this possible?? thanks!!