Good morning, Rob: Sorry for the delay in getting back here. It has been very busy at workee and just now got the opportunity to check back. Thanks for the abbreviation and suggestion for my code.
The brackets in the Range addy I think I picked up from vb code examples I found to use between Windows apps and Allen Bradley PLCs. We use a bit of DDE over a communications highway to peek and poke data between PLCs and MS Excel, MS Access, etc. It is possible to use an Excel cell or range of cells as an object and refer to the object in RSLogix formulas...thus the bracketed addy. This make sense?
I use MS Excel as a switchboard for operators to use to view (and in some cases makes program changes in) a large number of production area controllers.
I am not really proficient in VB and so I ask a lot of questions while I learn it. Andy Pope has been a huge help as I need to move along quickly on some of these projects. One of these days I hope to get a good grip on VBA and VB. This is a great forum for me.
Again, thanks for your help.
Bookmarks