Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.windows.vista.general,microsoft.public.excel.programming
|
|||
|
|||
Why the error message?
"flatstan" wrote in message ... Please could somebody help me with this, I am the worlds biggest novice at macros. I have recorded macros on XP before but not encountered this problem before when I delete columns in excel on vista. The message 'wrong number of arguments or invalid property assignment' comes up when I run the macro and it highlights the text 'columns' in the line 'columns("A:A").Select'. Why is it doing this to me and how can I stop it (in simple terms for a simple man please). -- flatstan As you have an Excel macro, you'll do much better if you ask about it in a discussion group for Excel. Try he microsoft.public.excel microsoft.public.excel.programming I crossposted to the second to get you going. |
#2
Posted to microsoft.public.windows.vista.general,microsoft.public.excel.programming
|
|||
|
|||
Why the error message?
Hi
That line is possibly not the problem. Can you show us the whole macro - impossible to say what the problem is otherwise. regards Paul On Oct 18, 8:47*pm, "PvdG42" wrote: "flatstan" wrote in message ... Please could somebody help me with this, I am the worlds biggest novice at macros. I have recorded macros on XP before but not encountered this problem before when I delete columns in excel on vista. The message 'wrong number of arguments or invalid property assignment' comes up when I run the macro and it highlights the text 'columns' in the line 'columns("A:A").Select'. Why is it doing this to me and how can I stop it (in simple terms for a simple man please). -- flatstan As you have an Excel macro, you'll do much better if you ask about it in a discussion group for Excel. Try he microsoft.public.excel microsoft.public.excel.programming I crossposted to the second to get you going. |
#3
Posted to microsoft.public.windows.vista.general,microsoft.public.excel.programming
|
|||
|
|||
Why the error message?
As ALWAYS, post YOUR code for comments
-- Don Guillett Microsoft MVP Excel SalesAid Software "PvdG42" wrote in message ... "flatstan" wrote in message ... Please could somebody help me with this, I am the worlds biggest novice at macros. I have recorded macros on XP before but not encountered this problem before when I delete columns in excel on vista. The message 'wrong number of arguments or invalid property assignment' comes up when I run the macro and it highlights the text 'columns' in the line 'columns("A:A").Select'. Why is it doing this to me and how can I stop it (in simple terms for a simple man please). -- flatstan As you have an Excel macro, you'll do much better if you ask about it in a discussion group for Excel. Try he microsoft.public.excel microsoft.public.excel.programming I crossposted to the second to get you going. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Handler displaying message when no error | Excel Programming | |||
replace VBA run-time error message with custom message | Excel Programming | |||
error message: compile error, argument not optional | Excel Programming | |||
changing the message in an error message | Excel Worksheet Functions | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |