Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Totally Stuck...Help Please!
Hi there,
I am pretty new to MS Excel, but this is what i want to do. I have asked for help on this already, but haven't had much luck. I apprevciate everyones patiences. I have a 'Site Master Log' sheet which contains site readings. There are many site readings. I want to be able to click a button on my user form and have the last row of 'Site Master Log' copied (including column headers) and pasted into new workbook. This new workbook will be used as an attachment for a subsequent email. The code i was given (see below) stated the 'subscript was out of range', but i don't know what that means. Thanks for your help Sub Button2_Click() With Sheets("Site Reading Log") 'source ..Rows(.Cells(Rows.Count, "a").End(xlUp).Row).Copy Sheets("sheet16").Rows(1) 'destination End With End Sub -- Carlee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Totally Stuck...Help Please! | Excel Programming | |||
Totally Stuck...Help Please! | Excel Programming | |||
Totally Stuck...Help Please! | Excel Programming | |||
Totally Stuck...Help Please! | Excel Programming | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) |