| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find next open row in a column
Hello all,
I am trying to paste information into the last open rown of a column. I am stuck. Can anyone please help.... THankyou. Eric |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find next open row in a column
Dim r as Range
set r = cells(rows.count,"F").End(xlup)(2) r.PasteSpecial xlPasteAll -- Regards, Tom Ogilvy "Eric" wrote: Hello all, I am trying to paste information into the last open rown of a column. I am stuck. Can anyone please help.... THankyou. Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find something in column a then find if column B matches criteria | Excel Discussion (Misc queries) | |||
| Open Workbook, Go To Worksheet ABC, Find XYZ In Column B | Excel Programming | |||
| Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it. | Excel Programming | |||
| Open workbook macro- find correct month to open? | Excel Programming | |||
| How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
Linear Mode
