Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there,
So I am receiving this error: '1004' A table cannot overlap a range that contains another table... I am creating a vb macro to obtain data and write this data to different specific sheets ( which may already contain data ) I am importing data from microsoft query. The table is then created from this data, and is dynamic in size, tho when data exists, it doesnt seem to work. Im assuming the best way to get around this error, is to delete the table that exists, if there is one. Is there some specific VB code that will allow me to do this? Any help is greatly appreciated! Thanks! - jacques |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Web Query and table? | Excel Programming | |||
Use a button to create a table in excel without overwriting cells | Excel Programming | |||
VB way to remove the query from a Query Table? | Excel Programming | |||
Overwriting/Overlapping web query problem | Excel Programming | |||
Linking a table in Access to a table in Excel using MS Query | Excel Programming |