$$Excel-Macros$$ Re: You may not use references to other worksheets or workbooks for Conditional Formatting criteria.

Any help? Lynn wrote: > i am already using named ranges. > still does not work, something must have went wrong when i copy from 1 > workbook to this one?? > > On Jul 18, 11:32 pm, "Daniel" wrote: > > You can use named ranges to bypass the impossibility. However, keep in mind > > that, in order t

$$Excel-Macros$$ Re: Auto Run Macro - Copy data from multiple workbooks

thanks On Jul 18, 9:03 am, "Daniel" wrote: > A .bat file is a text file with the ".bat" extension instead of a standard > ".txt" file. That makes them executable. Iused "task manager" instead of > "task scheduler". Ther is a tutorial there > :http://www.iopus.com/guides/winscheduler.htm > Regar

$$Excel-Macros$$ delete entire row based on single cell value

This is my first experience with trying to write a macro instead of just record one and it's not going very well. I researched this group and found what looks to be a few similar macros but I don't know enough about VBA to get them to work for me. Any help you can give me would be greatly app

$$Excel-Macros$$ Export from Excel to access

I have an excel sheet with some data on sheet2 and I need to export this to an access database secured via workgroups security. The code I have works fine with database without security workgroup. Sub EXPORT() Dim cn As ADODB.Connect

$$Excel-Macros$$ Re: You may not use references to other worksheets or workbooks for Conditional Formatting criteria.

i am already using named ranges. still does not work, something must have went wrong when i copy from 1 workbook to this one?? On Jul 18, 11:32 pm, "Daniel" wrote: > You can use named ranges to bypass the impossibility. However, keep in mind > that, in order to use it, the "other" workbook has t

$$Excel-Macros$$ Export from Excel to access

I have an excel sheet with some data on sheet2 and I need to export this to an access database secured via workgroups security. The code I have works fine with database without security workgroup. Sub EXPORT() Dim cn As ADODB.Connec

$$Excel-Macros$$ Re: You may not use references to other worksheets or workbooks for Conditional Formatting criteria.

You can use named ranges to bypass the impossibility. However, keep in mind that, in order to use it, the "other" workbook has to be opened. HTH Daniel > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel- > mac...@googlegroups.com] On Behalf Of Lynn > Sent: samedi 18

$$Excel-Macros$$ You may not use references to other worksheets or workbooks for Conditional Formatting criteria.

i have copied my worksheet to another workbook. while trying to perform conditional formatting i got this error: You may not use references to other worksheets or workbooks for Conditional Formatting criteria. how to fix this? --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Calender Control

any idea why Calender Control cannot be clicked? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at ht

$$Excel-Macros$$ Re: Fwd: Please help me to solve the problm

Have a look at the attached file. Daniel From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of shijomon joseph Sent: samedi 18 juillet 2009 12:24 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Please help me to solve the problm Dear Frien

$$Excel-Macros$$ Re: Auto Run Macro - Copy data from multiple workbooks

A .bat file is a text file with the ".bat" extension instead of a standard ".txt" file. That makes them executable. Iused "task manager" instead of "task scheduler". Ther is a tutorial there : http://www.iopus.com/guides/winscheduler.htm Regards. Daniel > -Original Message- > From: excel-

$$Excel-Macros$$ Fwd: Please help me to solve the problm

Dear Friends, Please help me to solve the problm.., I am attaching the sample sheet also, Thanks in advance Best regards shijo -- Forwarded message -- From: shijomon joseph Date: Sat, Jul 11, 2009 at 11:35 AM Subject: Please help me to solve the problm To: excel-macros@goog

$$Excel-Macros$$ Re: plz help password protected worksheet

Hello Ankur, Take a look at the link I have enclosed below http://findsarfaraz.blogspot.com/2009/06/remove-password.html Regards, Sarfaraz Ahmed On Sat, Jul 18, 2009 at 12:49 PM, ankur wrote: > > hi excel gurus > plz help in openin

$$Excel-Macros$$ Re: Required help on subtotal function.

Exact solution for me. Thanks for your great effort. Have a good day On Fri, Jul 17, 2009 at 4:25 AM, Akhilesh Karna wrote: > I would be interested if there is simpler method to perform your task. > Meanwhile you can use the following function. > > '

$$Excel-Macros$$ Re: Value all the Selection

Thanx!! for your help Dave. Regards, Deepak Rawat On Fri, Jul 17, 2009 at 5:39 AM, Dave Bonallack wrote: > Hi, > Try putting the following code in a module, then Run: > > Sub ChangeToValue() > A = 2 > Do Until Cells(A, 1) = "" > Cells(A, 1) = Val(Cells(A, 1)) > A =

$$Excel-Macros$$ Re: How can a custom function know which cell its in?

It is simple. Add this function in your excel workbook.[tools->macro->vba editor: insert->module] Function rowNum(r As Range) As Integer rowNum = r.Row End Function in any cell if you type =rowNum(c5) the result will be 5. Akhilesh Kumar Karna On Sat, Jul 18, 2009 at 6:22 AM, Adrian wrote:

$$Excel-Macros$$ plz help password protected worksheet

hi excel gurus plz help in opening the attached file it does not show full sheet, it had hide all the formulas, i want to break this formula is measureitem i dont know how to unlock the structured window, plz tell me in brief Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someon

$$Excel-Macros$$ Re: How can a custom function know which cell its in?

Hi Adrian, Try this in C5: =ROW() Regards - Dave. > Date: Fri, 17 Jul 2009 14:22:38 -0700 > Subject: $$Excel-Macros$$ How can a custom function know which cell its in? > From: adrian.sitte...@gmail.com > To: excel-macros@googlegroups.com > > > Is there a way to create a custom function that wil