Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 989
Default Cut and Paste gives a #Ref error in Cell

I have three columns for each month, in first column I have the sales, in
second column I have adjustments, in third I have comments. At the end of
the role I have +A1+B1+D1+E1 and so on, skipping the column with the
comments. If I cut and paste a group of cells, for example A2, B2, and C2
and paste them in A3, B3, and C3 I end up with either in roll 2 +A3+B3+D2+E2,
when it should be +A2+B2+D2+E2, or a #Ref error. I have tried using the
absolute, +$A$2+$B$2.... and that doesn't work. Any ideas out there on this?

Thanks,
Mark
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste error Alan[_9_] Excel Discussion (Misc queries) 0 December 17th 07 04:43 PM
Paste error from Query GrahamV Excel Discussion (Misc queries) 0 February 2nd 07 11:47 AM
Paste value error PJG Excel Discussion (Misc queries) 1 November 24th 06 02:07 PM
ActiveSheet.Paste - Error help? dk_ Excel Discussion (Misc queries) 4 November 20th 06 12:27 AM
Paste Link enters a 0 into the cell where I paste. How do I elemin UNR Excel Discussion (Misc queries) 4 March 28th 05 01:54 AM


All times are GMT +1. The time now is 05:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"