Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Dec 10, 1:13 pm, wrote:
Hello I am new to VBA and have inherited a spreadsheet with to folloing code lines: Can someone give a good idea what the mean? Where is the best place to look this kind of stuff up -explinations of code etc.? Thanks in advance. LandedCost = ThisWorkbook.Names("LandedCost").RefersToRange.Val ue landed cost is a named range but what is this code telling the worksheet? Dim LandedCost As Double Dim and Double are in blue as compared to the normal black. What does Dim do? Not sure on the first one, but Dim is used to declare a variable, in this case as a Double. You can find them described at http://www.ozgrid.com/VBA/variables.htm Hope this helps in your world. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming |