View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
davegb[_2_] davegb[_2_] is offline
external usenet poster
 
Posts: 72
Default New to VBA - What does this code mean?

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.