View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dennis.mccarthy@us.atlascopco.com is offline
external usenet poster
 
Posts: 16
Default New to VBA - What does this code mean?

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?