What am I doing wrong here
 

oWB is a workbook and ows is a worksheet

Debug.print Workbooks(oWB).Sheets(oWS).Range("CurrentMonth").C olumn

Thanks,
Barb Reinhardt

What am I doing wrong here
 

if you have
Dim oWS as Worksheet
and you have set it to someting then it would be:

debug.print oWS.Range("CurrentMonth").Column


--
Regards,
Tom Ogilvy

"Barb Reinhardt" wrote:

oWB is a workbook and ows is a worksheet

Debug.print Workbooks(oWB).Sheets(oWS).Range("CurrentMonth").C olumn

Thanks,
Barb Reinhardt

What am I doing wrong here
 

Just as a heads up for your other question, when you don't put anything in
the body of the message, it can't be replied to from some sites.

--
Regards,
Tom Ogilvy


"Barb Reinhardt" wrote:

oWB is a workbook and ows is a worksheet

Debug.print Workbooks(oWB).Sheets(oWS).Range("CurrentMonth").C olumn

Thanks,
Barb Reinhardt