ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   slecting all entries to appear once (https://www.excelbanter.com/excel-worksheet-functions/224377-re-slecting-all-entries-appear-once.html)

ron

slecting all entries to appear once
 
On 12 Mar, 20:53, Resi wrote:
sorry when i run the macro in excel the error says:
compile error:
invalid inside procedure.

of any help?
tahnks, Resi




Sorry, but I am out of town and won`t be able to respond for another
week or two.

Be sure, before you paste anything into the window that opened when
you right-clicked the appropriate sheet tab, that the window is empty.

Also, be sure that the worksheet references within the macro
correspond to your worksheet names. In your original posting, I
believe you called them sheet 1 and sheet 2. But subsequently you
referred to one of them as "B". This obviously makes a difference.

I won´t be able to do more until I´m back home.

Ron Rosenfeld

slecting all entries to appear once
 
On Sun, 15 Mar 2009 11:20:55 -0700 (PDT), ron
wrote:

On 12 Mar, 20:53, Resi wrote:
sorry when i run the macro in excel the error says:
compile error:
invalid inside procedure.

of any help?
tahnks, Resi




Sorry, but I am out of town and won`t be able to respond for another
week or two.

Be sure, before you paste anything into the window that opened when
you right-clicked the appropriate sheet tab, that the window is empty.

Also, be sure that the worksheet references within the macro
correspond to your worksheet names. In your original posting, I
believe you called them sheet 1 and sheet 2. But subsequently you
referred to one of them as "B". This obviously makes a difference.

I won´t be able to do more until I´m back home.


Let me know if the above suggestions were of any help.
--ron


All times are GMT +1. The time now is 09:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com