Thread
:
method range failed
View Single Post
#
5
Posted to microsoft.public.excel.programming
CBrine[_4_]
external usenet poster
Posts: 11
method range failed
Try changing it to this.
Set rCtySts = wkshtSource.Range(wkshtsource.Cells(lStartRow, lColTop), wkshtSource.Cells(lRow,
lColTop + 1))
You don't have a fully qualified reference with without ID'ing the Worksheet.
HTH
Cal
Reply With Quote
CBrine[_4_]
View Public Profile
Find all posts by CBrine[_4_]