View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Discontinuous Range via VBA using R1C1?


Looked for something like .Tag, but didn't find it.


There's no tag or Alternative text property. Some text box perhaps, made
not
visible.


I suggested this (and provided a code sample) in Pete's more recent thread
which asked about .Tag.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______