Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting on next empty cell
How do I tell my macro to look for the next empty cell before pasting
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting on next empty cell
Byron,
Use the End Property. Here's the description from HELP: Returns a Range object that represents the cell at the end of the region that contains the source range. Equivalent to pressing END+UP ARROW, END+DOWN ARROW, END+LEFT ARROW, or END+RIGHT ARROW. Read-only. Syntax expression.End(Direction) expression Required. An expression that returns a Range object. Direction Required Long. The direction in which to move. Can be one of the following XlDirection constants: xlToLeft, xlToRight, xlUp, or xlDown. ------------- So, you can get to the last EMPTY cell in the current column by doing: Cells(ActiveCell.End(xlDown).Row + 1, ActiveCell.Column).Paste ------------- On 4/15/04 17:21, in article , "Byron" wrote: How do I tell my macro to look for the next empty cell before pasting. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding rows, pasting values then empty sheet | Excel Worksheet Functions | |||
Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
Pasting data top 1st empty cell in range | Excel Discussion (Misc queries) | |||
Selecting and pasting to an empty cell | Excel Programming |