View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trip[_3_] Trip[_3_] is offline
external usenet poster
 
Posts: 44
Default Nested Withs of Multiple Objects (Parent-Child)

Hello all,

As usual, looking for a little direction here... All feedback is
greatly appreciated!

I would like to know what would be the most effecient way to write the
following:

Market.rstConfigurationData!MarketName = Market.MarketName

This does not work...
With Market
With .rstConfigurationData
!MarketName = .MarketName
.....
End With
End With

I'm currently using:
With Market.rstConfigurationData
!MarketName = Market.MarketName
.....
End With

Is there another way to write this which would imrpove effeciency? I
would love to get rid of the "Market." in front of the second half of
the equation.

Thanks!!

Trip