Macro not working in shared work book
Closed
arockiad
-
Jun 10, 2011 at 09:59 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 13, 2011 at 11:21 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 13, 2011 at 11:21 AM
Related:
- Macro not working in shared work book
- Google book downloader mac - Download - Other
- Spell number in excel without macro - Guide
- How to find shared contacts in whatsapp - Guide
- How to delete whatsapp contact not in address book - Guide
- Offline cash book software for pc - Download - Billing and accounting
5 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 12, 2011 at 07:34 AM
Jun 12, 2011 at 07:34 AM
What version of excel you are using
Hi Rizvisa,
Thanks alot for ur response,
I tested with Office 2010 and 2007, But saved as .XLS file only. Since it is a shared workbook, Few users may access with 2003. I tried saving as .XLSM file also and tried, even then i'm getting the same error. whever the "Range" method is called, it is giving that error.
Kindly help me out...
I'm not advanced user, Kindly reply conssidering me as Beginner,
Thanks alot for ur patience and time..
Thanks alot for ur response,
I tested with Office 2010 and 2007, But saved as .XLS file only. Since it is a shared workbook, Few users may access with 2003. I tried saving as .XLSM file also and tried, even then i'm getting the same error. whever the "Range" method is called, it is giving that error.
Kindly help me out...
I'm not advanced user, Kindly reply conssidering me as Beginner,
Thanks alot for ur patience and time..
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 13, 2011 at 10:49 AM
Jun 13, 2011 at 10:49 AM
I think you cannot do Advance filter when you share the book. Excel will not allow it
oooooooooh...!!! That's sad..:(
MY case is like Q column of "Sheet1" is having the value true or false.
All true value rows have to be copied from row 61 of "Sheet2" sheet..
If is any other alternative.... Pls do help me...
MY case is like Q column of "Sheet1" is having the value true or false.
All true value rows have to be copied from row 61 of "Sheet2" sheet..
If is any other alternative.... Pls do help me...
Didn't find the answer you are looking for?
Ask a question
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 13, 2011 at 11:21 AM
Jun 13, 2011 at 11:21 AM
Try simple filter and copy and paste values.
If this does not help then could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like http://wikisend.com/
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like
If this does not help then could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like http://wikisend.com/
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like