GoatieEddie
Technical User
Hi Guys,
Two questions if I may:
Firstly, I have a file that has a sheet containing 31780 lines of data and 15 columns. On a separate sheet I have a Pivot Table that accesses that data. There are also a couple of VB routines. However, the file saves slowly to 9.8MB which I find kind of excessive! Can someone give me a clue as to why?
Secondly, one of the VBA codes runs through each line and does a worksheet.vlookup function but this takes ages! Given the speed of computers nowadays surely most macros should run like lightning! Again, any clues warmly received.
Cheers,
GE
Two questions if I may:
Firstly, I have a file that has a sheet containing 31780 lines of data and 15 columns. On a separate sheet I have a Pivot Table that accesses that data. There are also a couple of VB routines. However, the file saves slowly to 9.8MB which I find kind of excessive! Can someone give me a clue as to why?
Secondly, one of the VBA codes runs through each line and does a worksheet.vlookup function but this takes ages! Given the speed of computers nowadays surely most macros should run like lightning! Again, any clues warmly received.
Cheers,
GE