ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Nested Withs of Multiple Objects (Parent-Child) (https://www.excelbanter.com/excel-programming/344685-nested-withs-multiple-objects-parent-child.html)

Trip[_3_]

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



All times are GMT +1. The time now is 12:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com