Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copping data from two cells into one | Excel Discussion (Misc queries) | |||
Copying worksheet cells into another worksheet using autofill | Excel Discussion (Misc queries) | |||
adding several worksheet cells onto a main worksheet | Excel Worksheet Functions | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) |