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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Function stopped working...
Oh, and I just checked the function in other workbooks. It still works there. I have no idea what could have changed in... Wait! I got it! *slaps forehead and beats it on desk* Man that was dumb! I just made another macro to format a series of sheets the way I want them, and guess what I called it? You guessed it, "Format". :
Anyways, thanks for reading this anyways |
Reply |
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 |