Why can't I use the following formula in VB? How can this be solved?
It seems to me that we can't use R1C1 expression in range. Anyway to go around it?![]()
dim range1 as range set range1=worksheets("Sheet1").range(cells(1,1),cells(6,5))
Why can't I use the following formula in VB? How can this be solved?
It seems to me that we can't use R1C1 expression in range. Anyway to go around it?![]()
dim range1 as range set range1=worksheets("Sheet1").range(cells(1,1),cells(6,5))
Last edited by one8421; 01-23-2009 at 03:17 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks