I've got a range of cells (A1:M1) that have been merged and centered. I need to use VBA to place some text into this range of merged cells, but I'm not sure how to refer to it.
Do I reference the whole range, or just one of the cells in the merged range to set the text into it?
-Randy Shea
I'm a programmer, but I'm also pro-grammar!
If your issue is resolved, please use Thread Tools to mark your thread as Solved!
PODA (Professional Office Developers Association) | Certifiable | MOS: Access 2003
Just refer to the first cell in the mergearea.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
That got it working perfectly- thanks.
-Randy Shea
I'm a programmer, but I'm also pro-grammar!
If your issue is resolved, please use Thread Tools to mark your thread as Solved!
PODA (Professional Office Developers Association) | Certifiable | MOS: Access 2003
Posting Permissions
Reply With Quote
