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