RE: Vb to Excel range issues

Giganews Newsgroups
Subject: RE: Vb to Excel range issues
Posted by:  Wigi
Date: Thu, 24 Jul 2008

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

Wigi = Excel/VBA, soccer and music

"cmdolcet69" wrote:

> Im havening an issue with my range function in
> 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


In response to

Vb to Excel range issues posted by cmdolcet69 on Thu, 24 Jul 2008