ExcelBanter - View Single Post - Append info in all worksheets in workbook in one sheet

Barb Reinhardt

I got it figured out. Thanks

"Ron de Bruin" wrote:

Hi Barb

Show me the complete macro that you use

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Barb Reinhardt" wrote in message
...
Ron,

I've got this snippet of code

DestSh.Cells(Last + 1, "A").Value = sh.Name
DestSh.Range("A" & Last).Copy

Last1 = lastrow(DestSh)
- Range("A" & Last & ":" & "A" & Last1).Select

Selection.PasteSpecial Paste:=xlPasteValues,
Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

I get Runtime error 1004
Method "Range" of object "_worksheet" failed

at the line with the arrow. What am I missing?

Thanks,
Barb

"Ron de Bruin" wrote:

Hi Barb

Try
http://www.rondebruin.nl/copy2.htm

Or with formulas
http://www.rondebruin.nl/summary2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Barb Reinhardt" wrote in message
...
I have a workbook that has about 20 worksheets within it. I'd like to
append the information from each worksheet into one worksheet and in column
A, I'd like the name of the source worksheet to be displayed. I'm not sure
where to start.

Thanks in advance,
Barb Reinhardt