View Single Post
 
Old 06-05-2013, 07:33 AM
JohnWilson JohnWilson is offline Windows 7 64bit Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

That creates an Excel object but doesn't necessarily set a reference to Excel Code. (You would do this in the VBE Tools > References)

If you didn't do this xlToRight and xlDown mean nothing to PowerPoint (they are Excel constants) try this instead.
c = Range("D14").End(-4161).Column
r = Range("D14").End(-4121).Row
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote