LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Incremental Cell Movement

I am using this to move the value in cell E33 to Sheet3 cell E28 but what I'd
like to be able to do is move cell E33 to sheet3 E28 the first run through
and then next run
E33 should go to sheet3 E29 and so on. Is this possible.


Worksheets("sheet1").Range("e33").Copy
Worksheets("sheet3").Range("e28").PasteSpecial _
xlPasteValues
Application.CutCopyMode = False
 
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
Active cell movement cmcgath Setting up and Configuration of Excel 1 March 31st 10 07:08 PM
Format a cell based on incremental numbers MurrayBarn Excel Worksheet Functions 3 June 23rd 09 02:22 PM
assign an incremental number to a cell, for each new spreadsheet MarkWatson Excel Worksheet Functions 0 June 21st 07 02:09 AM
Cell incremental increase stuck in van nuys Excel Worksheet Functions 2 April 14th 07 02:45 AM
Cell to cell movement with arrow keys moves entire sheet ken heinemann Excel Worksheet Functions 1 December 29th 06 12:30 AM


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

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

About Us

"It's about Microsoft Excel"