Setting a Range with only 1 row of data?

[gnome_core]

Hello,

I have a vba process which searches for ranges of data within an excel sheet. The following action works very well when more than 1 row of data exists in the range.

Please Login or Register  to view this content.

However, if only 1 row of data exists and I use this action, it will select all of the rows below the first row. Most of the times--it will go to the last row (1048576). Do you have any suggestions for resolving this?

intRow is a variable which identifies the row where my range of data begins. The rang of data always starts within the first column.

Many thanks,
J

[shg]

If you have at least one row of data, then

Please Login or Register  to view this content.

[Leith Ross]

Hello gnome_core,

If you still want to use the Resize method, you can by changing your code to what is below..

Please Login or Register  to view this content.

The Resize method takes 2 arguments: Rowsize and Columnsize. If the argument is left out then the default is the current number of rows or columns in the range. In your original post, the Rowsize is absent. In the code above it is set to 1. Your range will be 1 row by 3 columns wide.