Code questions

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

Can someone provide:

1. the syntax for copying a complete line from one spreadsheet to another?
Does the second one have to be open?

2. syntax for inserting a complete line in a different spreadsheet, on the
next blank line of a sheet, moving the rest on the lines down?

3. the syntax for copying a complete line at the end of a sheet on a
different spreadsheetspreadsheet.

I'm going to try to use that to put together a complicated macro.

Thanks,

Ron
 
Ron

Hope the below helps.......


Sub Macro()

Dim wbBook1 As Workbook
Dim wbBook2 As Workbook
Dim wsSheet1 As Worksheet
Dim wsSheet2 As Worksheet
Dim varRange As Variant
Dim lngLastRow As Long

'To reference a open workbook (unsaved)
'To reference a open workbook (already saved) add extension
Set wbBook1 = Workbooks("Book1")
Set wbBook2 = Workbooks("Book3")

'Refer the worksheets
Set wsSheet1 = wbBook1.Worksheets("Sheet2")
Set wsSheet2 = wbBook2.Worksheets("Sheet1")
varRange = wsSheet1.Rows(1)

'To copy to first row
wsSheet2.Rows(1) = varRange

'Next blank cell in Col A
lngLastRow = ActiveSheet.Range("A1").End(xlDown).Row + 1
wsSheet2.Rows(lngLastRow) = varRange

'Last available row in Column A
lngLastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row + 1
wsSheet2.Rows(lngLastRow) = varRange
End Sub

If this post helps click Yes
 
Nah...work work I do at home....and sometimes at work, if I have time...

Actually tried to explain what I needed before, but explanation was too
complicated...no one answered...LOL

My main problem is syntax....once I have that down, I can write the
cludgiest code around....but it (usually) works...LOL

Ron
 
Not exactly. The problem I'm having is I'm doing everything by person's
names. Taking a line of code under one person's name and copying it to
another workbook uner that same person's name. I can have the sheets named
after a person or just search down a sheet to find the name and then insert
it in the next blank space.

The biggest problem is storing the person's name, then referring to it in
the next workbook, either in a singal worksheet or a sheet by that name.

Not sure I'm going to be ab;e to make it work.

Thanks,

Ron
 
I'm kinda busy now with a project for a paying client but
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.
 
I appreciate the offer. I am now automating another process that is going
between spreadsheets and recording it is helping me with some ideas. If I get
really stuck, I may take you up on the offer.

Thanks,

Ron
 
Back
Top