"flatstan" <guest@unknown-email.com> wrote in message
news:71b8cf00bf1caa4c2fb0a8767ee66af8@nntp-gateway.com...[color=blue]
>
> 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[/color]

As you have an Excel macro, you'll do much better if you ask about it in a
discussion group for Excel.

Try here:

microsoft.public.excel

microsoft.public.excel.programming

I crossposted to the second to get you going.

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" <p...@toadstool.edu> wrote:[color=blue]
> "flatstan" <gu...@unknown-email.com> wrote in message
>
> news:71b8cf00bf1caa4c2fb0a8767ee66af8@nntp-gateway.com...
>
>
>[color=green]
> > 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).[/color]
>[color=green]
> > --
> > flatstan[/color]
>
> As you have an Excel macro, you'll do much better if you ask about it in a
> discussion group for Excel.
>
> Try here:
>
> microsoft.public.excel
>
> microsoft.public.excel.programming
>
> I crossposted to the second to get you going.[/color]

As ALWAYS, post YOUR code for comments

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
[email]dguillett1@austin.rr.com[/email]
"PvdG42" <pvdg@toadstool.edu> wrote in message
news:%23TxnSvCUKHA.1236@TK2MSFTNGP05.phx.gbl...[color=blue]
>
>
> "flatstan" <guest@unknown-email.com> wrote in message
> news:71b8cf00bf1caa4c2fb0a8767ee66af8@nntp-gateway.com...[color=green]
>>
>> 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[/color]
>
> As you have an Excel macro, you'll do much better if you ask about it in a
> discussion group for Excel.
>
> Try here:
>
> microsoft.public.excel
>
> microsoft.public.excel.programming
>
> I crossposted to the second to get you going.
>
>[/color]