Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel Macro
Name: AlwaysWillingToLearn Date: February 21, 2007 at 06:15:11 Pacific OS: winxp CPU/Ram: 512 Product: msi
Comment:
Hey,
im writting a macro in excel, i want it to display a number in range A1 in this format 0001 and then some condition will cause it to increment by one and therefore become 0002 and so one. but when i write this in the macro it only outputs 1 and omits the 000, how can i resolve this? i have tried to google number formatting and stuff likr that but cannot find a solution. any help would be much appreciated.
Name: Cosmo (by 0_Cosmo) Date: April 10, 2007 at 07:34:34 Pacific
Reply:
Always, could I please get your macro? It sounds like exactly what I'm trying to do, and I'm stuck. I know I'm missing something really simple, I'm just brain dead right now. I'd really appreciate the help.
Thanks.
"Just because your children are born in the South doesn't make them Southerners. If your cat had kittens in the oven, it wouldn't make them biscuits."
Summary: HI, Having this problem. Does anyone knows how to read latest updated file from excel macro. eg. File1 reads formula from FM03 and if I add FM04(which is the latest), I want File1 to read the latest ...
Summary: Hello all, long time since ive posted, need some help from you guys again please. i have made an excel macro, on the excel page you have a drop down menu which you can use to select an option from. Wh...