Thread: Copying a variable size table from Excel via VBA
View Single Post
 
Old 06-05-2013, 08:45 AM
-=bb=- -=bb=- is offline Windows 7 64bit Office 2010 32bit
Novice
  
Join Date: May 2013
Posts: 8
-=bb=- is on a distinguished road
Default
Hi John,

I already have Excel 14.0 Object Library, Office 14.0 Object Library, OLE Automation, PowerPoint 14.0 Object Library and Visual Basic for Applications checked in References. I cannot locate one for Excel Code.

Unfortunately code still causes and overflow at the line

r = Range("D14").End(-4121).Row

and C is still being set to 16384.

Kindest regards
bb
Reply With Quote