Issue with Selection.End(xlDown)
Last answer on Jun 9, 2009 5:46:18 pm BST linda, on Jun 9, 2009 4:52:47 pm BSTHello,
I am working on a few macros and came across this problem. If I use the code below to select a range of cells and if my working rows only have one row, the command selects, in this example, C2 all the way down to the maximum ie. C9999999999. The code halts with an error when it is looping through an infinite (or very large) number of cells. I do not have problems when the data consists of more than one row. I only want to select everything in column C, starting in C2 that has data, not the blank cells below
Range("C2").Select
Range(Selection, Selection.End(xlDown)).Select
For Each Cell In Selection
command
command
command
Next Cell
Configuration: Windows XP Internet Explorer 7.0
Hye there, i've searched something.. it can help you:
|
Cant select folder options on vista- High end alarm clock radio
- Logging on xp without selecting user account
- Microsoft excel vba select filename
- Pc specs requirement for high end game 2009
- Range.select blank cell stop macro
- Sata hdd selector
- Sed remove line end
- Select operating system screen windows me
- Selecting any file in a folder in batch file
- Selection.end(xldown).offset(0, 1).select
- Selection.end(xltoright).column
- Sum range("a1").end(xltoright).select
- This modification is not allowed because the selection is locked microsoft word 2007
- Vba macro select to end
- Vba word select to end and delete
- Wifi channel selection
- Windows 98 and cable select mode
