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.

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.

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.