Re: $$Excel-Macros$$ Excel 2007 If-Then-Else VBA Code

Ah..thank you so much :) Now I can quit pulling my hair out :) Terese On Monday, December 8, 2014 9:16:04 AM UTC-5, Vabz wrote: > > You can do with simple formula... > > Check this... > > + > *I did not do this for you. God is here working through me for you.* > > On Mon, Dec 8, 2014 at 6:59

Re: $$Excel-Macros$$ Excel 2007 If-Then-Else VBA Code

You can do with simple formula... Check this... + *I did not do this for you. God is here working through me for you.* On Mon, Dec 8, 2014 at 6:59 PM, tlkng1 wrote: > Good morning... > > I am trying to create a custom function but can't seem to get the statment > to work. > > I am working

$$Excel-Macros$$ Excel 2007 If-Then-Else VBA Code

Good morning... I am trying to create a custom function but can't seem to get the statment to work. I am working with four columns: Status; Estimated; Current; Completed. Status is a list box with three possible selections: Completed; In-Progress; Pending. Estimated, Current and Completed are

$$Excel-Macros$$ Excel 2007 & Excel 2010

hi expert , below code take different execution time on Excel 2007 and Excel 2010 Excel2007 =20 Sec Excel2010 =1 sec can any one suggest what may be reason Thanks Regards, Sub ImportXMLtoList(shtTemp As Worksheet, strTargetFile As String) Dim wb As Workbook shtTemp.UsedRange.Clear Debug.Prin

Re: $$Excel-Macros$$ Excel 2007 Protect and unprotect

Dear Norman, Then share that sheet with us, Warm Regards, Gawli Anil On Tue, Apr 9, 2013 at 5:50 PM, Norman West wrote: > Hi Gawli, > > I protected the worksheets prior to looking at unprotecting certain user > cells > > Norman West > > > On Tuesday, April 9, 2013 11:12:18 AM UTC+1, अनिल नारा

Re: $$Excel-Macros$$ Excel 2007 Protect and unprotect

Hi Gawli, I protected the worksheets prior to looking at unprotecting certain user cells Norman West On Tuesday, April 9, 2013 11:12:18 AM UTC+1, अनिल नारायण गवली wrote: > > Dear Norman, > > > Before Protecting the entire sheet first goto review and click on allow > users to edit the range

Re: $$Excel-Macros$$ Excel 2007 Protect and unprotect

Dear Norman, Before Protecting the entire sheet first goto review and click on allow users to edit the ranges and then protext the sheet. Warm Regards, Gawli Anil On Tue, Apr 9, 2013 at 3:32 PM, Norman West wrote: > I am reading "Excel 2007 for Dummies" in an endeavor to understand protect >

$$Excel-Macros$$ Excel 2007 Protect and unprotect

I am reading "Excel 2007 for Dummies" in an endeavor to understand protect and unprotect worksheets, and am more confused than ever over what one would have thought an easy operation. I have written a 4 page worksheet program and wish to protect all sheets with the exception of some data entry

RE: $$Excel-Macros$$ Excel 2007 - VBA - Chart format

Thanks a lot. It works. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Rajan_Verma Envoyé : samedi 20 octobre 2012 06:31 À : excel-macros@googlegroups.com Objet : RE: $$Excel-Macros$$ Excel 2007 - VBA - Chart format Try this

RE: $$Excel-Macros$$ Excel 2007 - VBA - Chart format

: $$Excel-Macros$$ Excel 2007 - VBA - Chart format Hello, all, Someone asks me if it were possible to format a chart area with a gradient fill of more than two colors. I can't find no clue to this one. Can anyone help ? TIA Daniel -- Join official facebook page of this forum @

$$Excel-Macros$$ Excel 2007 - VBA - Chart format

Hello, all, Someone asks me if it were possible to format a chart area with a gradient fill of more than two colors. I can't find no clue to this one. Can anyone help ? TIA Daniel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ m

Re: $$Excel-Macros$$ Excel 2007...Experiment more than 1,048,576 values in a 1 dimension array

Oops I sent the code from the wrong module. I coded this just to fill one column accross two worksheets within the same workbook. Actually, the following line fill in column B. 'Set ra = wsa.Range(wsa.Cells(1, 2), wsa.Cells(Rows.Count, 2)) Set rb = wsb.Range(wsb.Cells(1, 2), wsb.Cells(1000, 2))

Re: $$Excel-Macros$$ Excel 2007...Experiment more than 1,048,576 values in a 1 dimension array

ns you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley --------- ____ From: bpascal123 To: excel-macros@googlegroups.com Sent: Mon, July 30, 2012 1:29:03 PM Subject: $$Excel-Macros$$ Excel 2007

$$Excel-Macros$$ Excel 2007...Experiment more than 1,048,576 values in a 1 dimension array

Hi, Following a query, I'm trying the code below and I find out that the "aaa" array is dimensionned with 1,049,574 as worksheet wsb column 1 hold 1,000 values, but it doesn't hold values from wsb worksheet. Is there any other way to get all the 2 columns from 2 different worksheet into a script

$$Excel-Macros$$ Excel 2007... experiment more than 1,048,576 value in a vector/array

Hi, Following a query, I'm trying the code below and I find out that the "aaa" array is dimensionned with 1,049,574 as worksheet wsb column 1 hold 1,000 values, but it doesn't hold values from wsb worksheet. Is there any other way to get all the 2 columns from 2 different worksheet into a script

Re: $$Excel-Macros$$ Excel 2007 not opening the sheet

Dear Idhrees, Please check below link.. http://www.mrexcel.com/forum/showthread.php?t=289850 On Mon, Feb 6, 2012 at 4:15 PM, Idhrees Mohamed wrote: > Dear Friends, > > I am using excel 2007 and my files are not opening in the first attempt if > i minimize the window and maximize or right click i

Re: $$Excel-Macros$$ Excel 2007 not opening the sheet

HEre's a discussion on this topic. Scroll down to a little over the half way mark, and you should find a few probable solutions. One was about deleting the pdfmaker file (do you have that?). Second was about changing some setting in Excel. Either way, I haven't faced this myself, so no solutions fr

$$Excel-Macros$$ Excel 2007 not opening the sheet

Dear Friends, I am using excel 2007 and my files are not opening in the first attempt if i minimize the window and maximize or right click inside open or new then once the contents will show. Please let me know how can i rectify the error. -- Thanks & Regards, Mohamed Idhrees. S. -- FORUM RUL

Re: $$Excel-Macros$$ Excel 2007 Quick Access Toolbar- Take it with me...

So either this didn't post, or there is no way on earth for this to happen. John On Fri, Jul 15, 2011 at 2:39 PM, John A. Smith wrote: > Is there a way to have my Quick Access Toolbar portable (like on a jump > drive) so any computer with Excel 2007 can have my customized Quick Access > Toolbar

$$Excel-Macros$$ Excel 2007 Quick Access Toolbar- Take it with me...

Is there a way to have my Quick Access Toolbar portable (like on a jump drive) so any computer with Excel 2007 can have my customized Quick Access Toolbar when I use it? Thank you. John -- -- Some important links fo

$$Excel-Macros$$ Excel 2007 "Custom Toolbars Button"

There is a "Custom Toolbars Button" available for the "Quick Access Toolbar". This button has "drop-down" capability, so I assume commands can be added to this button. Can anyone point me to an example of how this button can be used - my web searches have pinpointed no results. -- -

RE: $$Excel-Macros$$ Excel 2007 dashboards tutorials

Thanks Noorain Ansari. From: NOORAIN ANSARI [mailto:noorain.ans...@gmail.com] Sent: Wednesday, June 15, 2011 4:44 PM To: excel-macros@googlegroups.com Cc: John Mutesi Subject: Re: $$Excel-Macros$$ Excel 2007 dashboards tutorials Hi John, Please try it... http://chandoo.org/wp/excel

Re: $$Excel-Macros$$ Excel 2007 dashboards tutorials

Hi John, Please try it... http://chandoo.org/wp/excel-dashboards/ http://top-pdf.com/download/excel-dashboard-tutorial-3.html Thanks & regards, Noorain Ansari On Wed, Jun 15, 2011 at 6:09 PM, John Mutesi wrote: > Friends, > > > > Is there a website or an e-book or a book you would want to acc

$$Excel-Macros$$ Excel 2007 dashboards tutorials

Friends, Is there a website or an e-book or a book you would want to access or have in order to master excel dashboards? Yesterday, I bought an e-book which requires an adobe digital edition to read it but since I changed to a work PC and that book cannot be accessed anymore. Please help Joh

Re: $$Excel-Macros$$ Excel 2007 to 2003

Can´t you install the compatibility pack? 2010/11/2 sachin83_1...@yahoo.com > hey friends, i need to knw is there any shortcut or key to convert > Excel 2007 to 2003 n vise versa, pls help me out > > -- > > -- >

$$Excel-Macros$$ Excel 2007 to 2003

hey friends, i need to knw is there any shortcut or key to convert Excel 2007 to 2003 n vise versa, pls help me out -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ Excel 2007 Information Rights Management + macro

Hello I have a xlsm (macro-enabled spreadsheet) file with IRM using free Microsoft's authentication services (windows live based) to protect the file from being redistributed without my knowledge and consent. The IRM itself has been working flawlessly so far. However, I have not managed to successf

$$Excel-Macros$$ Excel 2007

Where I work they will be upgrading our Office 2003 to Office 2007. I describe myself as an Excel power user. I have customized my toolbars with drop downs, buttons and macros. This creativity of mine has spanned over the past 8 years or so as I make additions and improvements. With Office 2007

Re: $$Excel-Macros$$ Excel 2007 open password break

send your file. On Sat, May 22, 2010 at 7:19 PM, Alpesh Gajjar wrote: > Dear All, > > I have sheet which is password protected. I forget the password. > > Please suggest me how i open this file and remove the password. > Its urgent, please help. > -- > Alpesh Gajjar > ===

$$Excel-Macros$$ Excel 2007 open password break

Dear All, I have sheet which is password protected. I forget the password. Please suggest me how i open this file and remove the password. Its urgent, please help. -- Alpesh Gajjar Email: gajjars...@yahoo.com or gajjars...@gmail.com Mobile No:

Re: $$Excel-Macros$$ Excel 2007 - Crashing when shared with more than 10 users

Hi Dear, Already 2003-2007 compatibility pack is installed... but still the problem is exists.. However, i will contact Microsoft Specialist as advised... Thanks a tonn for your advise.. Thanks VinodN On Fri, Apr 9, 2010 at 10:48 AM, rf1234 rf1234 wrote: > Hello Dear > This is excel 2007 Compa

Re: $$Excel-Macros$$ Excel 2007 - Crashing when shared with more than 10 users

Hello Dear This is excel 2007 Compatibility issue, Please contact or chat with Microsoft Specialist https://support.microsoft.com/oas/default.aspx?gprid=11346&st=1&wfxredirect=1 Hope it Will Help Happy To Help :) Prashant Tripathi On Fri, Apr 9, 2010 at 5:21 AM, Vinod N wrote: > Hi Gur

$$Excel-Macros$$ Excel 2007 - Crashing when shared with more than 10 users

Hi Gurus, At my workplace, we use Excel 2007(Licensed). We maintain daily volume tracker(shared) and the same will be updated by my team members (8~10). They save the file systematically, one after another. As you are aware, if one user saves the shared file and at the same time another used saves

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

Use the DLookup function to get the value of a particular field from a specified set of records. pls attach ur file if u r not able to From: Vikas Chouhan To: excel-macros@googlegroups.com Sent: Sat, 27 March, 2010 7:00:34 PM Subject: Re: $$Excel-Macros

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

*how to put formula,lookup in access* On Sat, Mar 27, 2010 at 4:29 PM, Deepak Rai wrote: > Hi Vikash, > > Want help you want on Access ? > > Regards, > > Deepak > > On Sat, Mar 27, 2010 at 10:38 AM, Vikas Chouhan wrote: > >> hi >> >> Dear all please help in access urgent plsss >> >> >> >> >>

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

Hi Vikash, Want help you want on Access ? Regards, Deepak On Sat, Mar 27, 2010 at 10:38 AM, Vikas Chouhan wrote: > hi > > Dear all please help in access urgent plsss > > > > > > > > -- > One Team One Dream One Goal > > Warm Regards, > Vikas Chauhan > E-Mail :- vikask...@gmail.com,vikask..

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

hi Dear all please help in access urgent plsss -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_ccess without U" Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

dr > Date: Thu, 25 Mar 2010 21:19:13 > To: MS EXCEL AND VBA MACROS > Subject: Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John > >         Walkenbach. > > I've got a few ebooks on VBA with MS Excel though not the specific > book you mention

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

find the cd. >> >> I will try and send it this weekend >> >> Thanks >> >> Amitabh >> -- >> >> -Original Message- >> From: anandydr >> Date: Thu, 25 Mar 2010 21:19:13 >> To: MS EXCEL AND VBA MACROS &g

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

21:19:13 > To: MS EXCEL AND VBA MACROS > Subject: Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by > John >Walkenbach. > > I've got a few ebooks on VBA with MS Excel though not the specific > book you mention. If you can use ebooks I can mail the

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

Hi I have this book but will have to find the cd. I will try and send it this weekend Thanks Amitabh -- -Original Message- From: anandydr Date: Thu, 25 Mar 2010 21:19:13 To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ "Excel 2007 Power Programming wit

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

I've got a few ebooks on VBA with MS Excel though not the specific book you mention. If you can use ebooks I can mail them to you. Anand On Mar 24, 12:59 pm, rf1234 rf1234 wrote: > Dear Nani > Check This Link > Outhttp://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm > > this link pr

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

Nani Please search www.Edcomp.com for various computer books or www.ebookee.com so that you can get your book VIJAY KUMAR -- -- Some important links for excel users: 1. Follow us on TWITTER

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

Dear Nani Check This Link Out http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm this link provide the basic vba concept with code. For the book you mension,i have to look it out. Hope it Will Help Happy To Help :) Shyam On Wed, Mar 24, 2010 at 7:12 PM, Nani Ram <06n...@gmai

$$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

Hi Excel Lovers. Could any one have this book "Excel 2007 Power Programming with VBA" by *John Walkenbach*. If not this book, can any one provide me material to learn basic VBA on Excel. Thanks, Naniram -- -- Some

$$Excel-Macros$$ Excel 2007 Change Default Table Styles

Excel 2007 applies a table style to a new table, for example when data is pasted from an Access Database or a summary cell in a pivot table is double clicked. I don't want to use extra toner to print the applied shading, and I don't want to change the style every time I create a new table. Can th

$$Excel-Macros$$ Excel 2007 Run-time error '6': Overflow on Selection.Columns.Count

The following code shown below is straight from the Excel 2007 msdn web page on the Range.Count Property. When I select a range on Sheet1 and run the macro a Run-time error '6': Overflow error is generated on the following line of code: MsgBox "The selection contains " & Selection.Columns.Count &

$$Excel-Macros$$ excel 2007 test score

hello, hope you can help,have a worksheet with 2 sheets,class,table.in m1:r1 subject headings and m2:m8 will be pupils names and test scores for that class subject, same for rest with different names for different subjects.anyhow i will have a2:f2 poulated randomly from the lists in m2:r8 ei(a2 wi

$$Excel-Macros$$ Excel 2007: How can I use VBA to set series border line width?

After making a chart in Excel 2007, you can right click on a Data Series. then select Format Data point. The on the right, select Border Styles. Within this, there's a way to set the width: say to 0.25 pt. That's the GUI way of doing it, how can I change this width using VBA? --~--~-~--

$$Excel-Macros$$ Excel 2007

Hi: I am new to this group and please excuse me if I ask what has been asked before. Where I work I am considered a power user in Excel 2003. I have many customized toolbars and special pull down menus and lots of macro buttons. It took me years to do all this, but it really makes my job go fa

$$Excel-Macros$$ Excel 2007

Hi All, do we have any file or link where in we get info on Short cut keys and also want to know which are options which are in 2003 but not 2007 and what's new in 2007. Thank you!! --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.ex