Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
code help please
i am trying to create a simple macro whereby i add in a new person to a
holiday chart which involves adding in some formula lines and so on, but how do i make sure my macros start copy pasting at the next available line ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
code help please
The following returns the first row that is completely empty. May not be at
the end of your data: Sub FirstEmptyRow() Dim j As Long Dim i As Long Dim rr As Range Set rr = ActiveSheet.UsedRange j = rr.Rows.Count + rr.Row If j 65536 Then Exit Sub End If For i = 1 To j If Application.CountA(Rows(i)) = 0 Then Cells(i, 1).Select Exit Sub End If Next i End Sub -- Gary''s Student "sevelingard" wrote: i am trying to create a simple macro whereby i add in a new person to a holiday chart which involves adding in some formula lines and so on, but how do i make sure my macros start copy pasting at the next available line ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
code help please
Thanks for that.
"sevelingard" wrote: i am trying to create a simple macro whereby i add in a new person to a holiday chart which involves adding in some formula lines and so on, but how do i make sure my macros start copy pasting at the next available line ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Questions | New Users to Excel | |||
code not unique find latest date | Excel Discussion (Misc queries) | |||
VLOOKUP for Zip Code Ranges | Excel Worksheet Functions | |||
Conform a total to a list of results? | Excel Discussion (Misc queries) | |||
Macro for changing text to Proper Case | Excel Worksheet Functions |