PDA

View Full Version : ERROr while running a macro



naikadit
07-16-2008, 04:28 PM
Hi I am running a VBA macro and I am getting the error "RUN TIME ERROr 6 OVERFLOW". Attached is the file. Please need help ASAP the subroutine I am running is update sheets();

naikadit
07-16-2008, 04:41 PM
hi,

The exact process is I run the format sheet() subroutine and then update sheets. Format sheets is ok but when I run Update sheets I get error.

Bob Phillips
07-17-2008, 01:47 AM
I cannot find a macro called Format, Update or anything similar, they are all Macro1, 2 etc., and I see no button to fire it.

Which is which, and which sheet does it work on?

tpoynton
07-17-2008, 06:48 AM
I ran them last night; they are in thisworkbook. I ran the update one first, then let format run for 5 minutes or so before I cancelled it. perhaps it wouldnt take so long on a faster computer!

Simon Lloyd
07-19-2008, 11:02 AM
This thread doesn't make sense without the following attachment!

Norie
07-19-2008, 11:28 AM
I eventually managed to recreate the error, after about 2-3 minutes.

One of the reasons for the error is the use of Integer instead of Long.

But the real problem is that you aren't using worksheet references with things like Cells.

If you don't VBA will refer to the active sheet.

I've not checked out all the code but I think it needs a bit of a revamp.:)