Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
OK I think that I've got the record for the WORST code EVER.
I wanted to build a spreadsheet that would automatically become a webpage. I built the macro and I was good. COOL BEANS But I wanted excel to do that every minute...because it referenced a external data that updated every minute. I got it to work the WORST possible way you could imagine for code and speed. I told it to calculate the difference between two cells--each of which were times/dates. Basically my Macro is continuously running the =now() on one cell until it's been a minute and then it runs the other code.... starts all over and does it again. I KNOW there are more efficient ways of doing this but google didn't point me to anything I could understand. Someone mind writing me and letting me know the BEST way to do this? I'm game for some reading. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
code not unique find latest date | Excel Discussion (Misc queries) | |||
VLOOKUP for Zip Code Ranges | Excel Worksheet Functions | |||
Conform a total to a list of results? | Excel Discussion (Misc queries) | |||
Macro for changing text to Proper Case | Excel Worksheet Functions | |||
close form code | Excel Discussion (Misc queries) |