Vb to Excel range issues

C

cmdolcet69

Im havening an issue with my range function in vb.net

I have the following: OResizeRange = ows.range ("C33", "IR46")

Where the problem lies is that its not always ending at IR46 it
sometimes can be ending larger or smaller how can i factor the range
based off the size of collected data in my vb program
 
C

cmdolcet69

You can use (String) variables and make up the ending range in a dynamic way.

In this notation, as long as it is the name of a column followed by a row
number.
Click to expand...

Can you give me an example...
 
D

Dave Peterson

How do you determine the topleft corner and the bottom right corner?

If it always starts in C33 and you can pick out a column and row to determine
where it should stop, then maybe...

Dim LastRow as long
dim LastCol as long
dim oResizeRange as range

with ows
lastrow = .cells(.rows.count,"A").end(xlup).row
lastcol = .cells(32,.columns.count).end(xltoleft).column
set oresizerange = .range("c33",.cells(lastrow,lastcol))
end with

In this case, I used column A to determine the last row and row 32 to determine
the last column.
 
W

Wigi

For instance

OResizeRange = ows.range ("C33", Range("IR" & rows.count).End(xlUp))

Here the range extends until the last cell used in column IR.

Many other variations are possible as well.
 
C

cmdolcet69

Can this work? OResizeRange = ows.range ("C33", "IR") but it may
sometimes be "IR" or even "C39" how can i see what the last row it
writes to and then calculate my range based off of that?
 
Top