Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defining a variable Range for cells with values in them!
Hi:
I appear to be asking a number of questions about definitions of variable ranges. I have a range which at its maximum goes from a1:q500 I want to select ALL rows that have a value (non blank) in column A. They will be sequential so that Selection.End(xlDown).Select and then adding to the column to get to Q would work. The trouble I am having is with the Range(x:y).Select, where i cant get the variables set up right! Having tried various ways, I find I am stuck. Incidentally, this group is amazing! 99.999% of the stupid questions I have asked have been answered. I am eternally grateful! Best John Baker |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
defining unique range of cells for different sheets as the same n. | Excel Discussion (Misc queries) | |||
Drop down defining content of a range of cells | Links and Linking in Excel | |||
Defining a Variable Range | Excel Programming | |||
Defining a variable within a sub... | Excel Programming | |||
Error 1004 when defining range by cells(r,c) format | Excel Programming |