That's IT!!! Thank you SO much for your help!!! Jamie



On Dec 24, 6:29*am, joel wrote:
the address needs to be in R1C1 format change you r address properties
to look like this in all places

.Address(ReferenceStyle:=xlR1C1)

--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=164872

Microsoft Office Help