LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default Copping cells EXACTLY from one Worksheet to a new Worksheet?

There a a lot of good books on Excel VBA - look on amazon for the author
John Walkenbach or see www.j-walk.com.

Also have a browse through the Excel Visual Basic help in the VBE. It is
actually quite extensive and has the Excel Object Model in a visual
format which includes all the excel objects eg worksheets, ranges etc.
The section titled Visual Basic conceptual topics has details of loops,
using variables, if..then statements ans so on.

Good luck
Rowan

CRayF wrote:
Terrific, I see where you modified the starting row of from 23to 11. That
help me understand how you coded the loop as well. Now Im into tweak mode. I
actually used this for the first time tonight on the Phoenix Greyhound races.
I would say this has been a fun €śfirst€ť VBA/Excel project for me but as a
true programmer at heart, Ive got idea/enhancements already€¦ ;-) thanks
again. (And thanks for the €śloop€ť code reference below. Ive save that off.
Is there a good course for some books (URL Links) that show these €ścommand€ť
references? Parms associated with it and examples of it being put to use. Key
variables like Application, Worksheet, Value, Cell, Range, etc€¦ Id like to
learn this stuff more.

 
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
copping data from two cells into one confused deejay Excel Discussion (Misc queries) 3 October 15th 08 05:32 AM
Copying worksheet cells into another worksheet using autofill SunnySD Excel Discussion (Misc queries) 3 September 10th 08 10:32 PM
adding several worksheet cells onto a main worksheet oxicottin Excel Worksheet Functions 2 September 20th 06 08:07 PM
Copying a worksheet witrh protected cells to a new worksheet John Excel Worksheet Functions 2 February 1st 06 02:19 PM
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. [email protected] Excel Discussion (Misc queries) 0 September 22nd 05 04:39 PM


All times are GMT +1. The time now is 12:01 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"