Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 115
Default Code to pull the value of a Cell of the next Worksheet to the left

How would I code to pull the value of a Cell of the next Worksheet to the left?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Code to pull the value of a Cell of the next Worksheet to the left

I'm not sure I understand your question, but maybe something like

If Not ActiveSheet.Previous Is Nothing Then
Range("A1").Value = ActiveSheet.Previous.Range("A1").Value
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"CRayF" wrote in message
...
How would I code to pull the value of a Cell of the next
Worksheet to the left?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 115
Default Code to pull the value of a Cell of the next Worksheet to the

thanks
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
Can the dwnarrow box for a pull-down list be on the left? Bwarner Excel Discussion (Misc queries) 1 July 29th 09 08:20 AM
How can I pull Cell value from Detail worksheet into Summary sheet? John Kotuby[_2_] Excel Worksheet Functions 2 June 16th 09 08:50 PM
How can I get each worksheet tab name to pull from cell C3? BZ Excel Discussion (Misc queries) 1 June 2nd 08 04:15 PM
how to display zero at the left hand of a code in a cell say 045 Marie Excel Discussion (Misc queries) 3 June 12th 06 10:41 AM
Can a worksheet pull from a specific cell value in a separate wrks reloanpro Excel Worksheet Functions 4 June 27th 05 10:03 PM


All times are GMT +1. The time now is 11:10 AM.

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"