append info in a master workshhet

P

phillypdh

Board Regular
Joined
Jun 23, 2011
Messages
66
Code: 
bNumOfEntries = Application.CountA(Sheet1.Range("a:a")) - 1
740       Application.StatusBar = "Archiving Short Sale Entries..."
750       rngDataSet.Copy
760       wkbkArchive.Sheets(1).Cells(bNumOfEntries + 1, 1).PasteSpecial xlPasteValues
770       rngDataSet.EntireRow.Delete xlShiftUp
780       wkbkArchive.Close True '--Close and save

it keeps pasting over itself?
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
You must log in or register to reply here.

Similar threads

M
  • Locked
  • Question Question
Compare Two Sheets (A and B) and copy & hilight differences to bottom of B
Replies
1
Views
1K
Fluff
Fluff
M
  • Question Question
Trying to open an excel sheet from within MS Project and copy data across...
Replies
2
Views
3K
miless2111s
M
C
  • Question Question
Illegal Character Replacement Script - Auto Archiving - Convert to PDF if only info is inputted into sheet.
Replies
0
Views
489
CYStudios
C
J
  • Question Question
Need some help with permutation code, convert from one cell to a range
Replies
3
Views
435
johnnyL
J
L
  • Question Question
VBA works on work PC but not home PC
Replies
3
Views
2K
rollis13
rollis13

Forum statistics

Threads
1,224,518
Messages
6,179,254
Members
452,900
Latest member
LisaGo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top