Code questions
 

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

Code questions
 

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
---------------
Jacob Skaria


"Ron" wrote:

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

Code questions
 

Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ron" wrote in message
...
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

Code questions
 

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

"Don Guillett" wrote:

Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ron" wrote in message
...
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

Code questions
 

Did Jacob answer all your question

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ron" wrote in message
...
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

"Don Guillett" wrote:

Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ron" wrote in message
...
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

Code questions
 

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

"Don Guillett" wrote:

Did Jacob answer all your question

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ron" wrote in message
...
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

"Don Guillett" wrote:

Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ron" wrote in message
...
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

Code questions
 

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.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ron" wrote in message
...
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

"Don Guillett" wrote:

Did Jacob answer all your question

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ron" wrote in message
...
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

"Don Guillett" wrote:

Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ron" wrote in message
...
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

Code questions
 

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

"Don Guillett" wrote:

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.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ron" wrote in message
...
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

"Don Guillett" wrote:

Did Jacob answer all your question

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ron" wrote in message
...
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

"Don Guillett" wrote:

Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ron" wrote in message
...
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