define a cell range from variable values?

**pingwin77** · 07-21-2009, 02:44 PM

I have a range staring with cell "A5" and going to Column "K8+" that I need to copy. My issue is that the number of rows to copy will change. I have the number stored a variable "a" in my coding. how do I code this to work?

Thanks in advance!

**shg** · 07-21-2009, 02:46 PM

Please Login or Register  to view this content.

**royUK** · 07-21-2009, 02:47 PM

You could use

Please Login or Register  to view this content.

The current region is a range bounded by any combination of blank rows and blank columns.

**pingwin77** · 07-21-2009, 02:48 PM

so then do I define "numRows" like the following:

Please Login or Register  to view this content.

**shg** · 07-21-2009, 02:51 PM

You could. I just don't use a as a name for an integer (Byte, Integer, Long) variable.

**pingwin77** · 07-22-2009, 10:34 AM

Thanks! That was exactly what I needed!

define a cell range from variable values?

LinkBack

Thread Tools

Rate This Thread

Display

define a cell range from variable values?

Re: define a cell range from variable values?

Re: define a cell range from variable values?

Re: define a cell range from variable values?

Re: define a cell range from variable values?

SOLVED: define a cell range from variable values?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions