Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Function stopped working...
Hello everyone, I have a very strange problem
I've written quite a few macros to help me in my job, and a lot of them include the Format command, for things like myPriceCol = InputBox("Please Enter the Price Column Letter", "B" For each c in ActiveSheet.Range("C2:C"+Format(ActiveSheet.UsedRa nge.Rows.Count) c.Value = "Stuff ActiveSheet.Range(myPriceCol + Format(c.Row)).Value = "More Stuff Nex Suddenly today, all the Format functions in all my macros stopped working and give me a "wrong number of arguments or invalid property assignment error". If tried doing simple ones like myTest = Format(27 and even those give me the error If anybody could shed some light on this, how to fix it, why it happened, and how to stop it from happening again, that would be great I'll check for replies here later today, or you could e-mail me at , either would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Histogram function suddenly stopped working | Excel Discussion (Misc queries) | |||
F4 Function Key stopped working | Excel Worksheet Functions | |||
networkdays function stopped working | Excel Worksheet Functions | |||
Round Function has stopped working - Urgent | Excel Programming | |||
HELP! Button/Macro or Function has stopped working! | Excel Programming |