Why the error 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

 

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

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:<!--coloro:blue--><span style="color:blue <!--/coloro-->
> "flatstan" <gu...@unknown-email.com> wrote in message
>
> news:71b8cf00bf1caa4c2fb0a8767ee66af8@nntp-gateway.com...
>
>
><!--coloro:green--><span style="color:green <!--/coloro-->
> > 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).<!--colorc--><!--/colorc-->
><!--coloro:green--><span style="color:green <!--/coloro-->
> > --
> > flatstan<!--colorc--><!--/colorc-->
>
> 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.<!--colorc--><!--/colorc-->

 

As ALWAYS, post YOUR code for comments

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"PvdG42" <pvdg@toadstool.edu> wrote in message
news:%23TxnSvCUKHA.1236@TK2MSFTNGP05.phx.gbl...<!--coloro:blue--><span style="color:blue <!--/coloro-->
>
>
> "flatstan" <guest@unknown-email.com> wrote in message
> news:71b8cf00bf1caa4c2fb0a8767ee66af8@nntp-gateway.com...<!--coloro:green--><span style="color:green <!--/coloro-->
>>
>> 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<!--colorc--><!--/colorc-->
>
> 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.
>
> <!--colorc--><!--/colorc-->