| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
name selection
Hi All,
I have a table which has one blank row between row 1 and row 3 and then there are several rows of data. How Can I name this range in vba I cannot delete the blank row Any suggestions? thanks vishnu |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
name selection
assumes excel 2003<
Set myrange1 = Rows(1) Set myrange2 = Range(Cells(3, 1), Cells(7, 256)) Set myrange = Union(myrange1, myrange2) Mike " wrote: Hi All, I have a table which has one blank row between row 1 and row 3 and then there are several rows of data. How Can I name this range in vba I cannot delete the blank row Any suggestions? thanks vishnu |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
| Copy Selection - Paste Selection - Delete Selection | Excel Programming | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| Combo Box selection only shows bound column info after selection made. | Excel Programming | |||
| Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
Linear Mode
