$$Excel-Macros$$ Query

2011-02-12 Thread Aamir Shahzad
Hi all experts, Please resolve my query by formula. sheet attached. Regards, Aamir Shahzad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/excelda

$$Excel-Macros$$ Right-Click Functionality disabled with Hidden Command Bars

2011-02-12 Thread Rruffpaw
I have hidden all command bars in my workbook with For Each bar In Application.CommandBars bar.Enabled = False Next bar and this properly hides all command bars giving me a lot more real estate in each worksheet However, the right-click functionality is completely disabled. Is there any wa

$$Excel-Macros$$ Solution required

2011-02-12 Thread Jitender kumar
Dear Excel Gurus, Urgent help required from your part, Plz help me on the file attached. Problem in file Thanks in advance Regards Jitender -- -- Some important links for excel users: 1. Follow us on TWITTER for t

RE: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-12 Thread Dave Bonallack
Hi Paul, Very helpful and clearly explained, thank-you. Can we use this, or something similar, to load a range (say A1:A20) into an array without using a loop? Sorry, but my knowledge of arrays in VBA is very limited. Regards - Dave. Date: Sat, 12 Feb 2011 09:20:50 -0800 From: schreiner_p...@

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-12 Thread Paul Schreiner
I'm not sure what you mean by "the last A goes to the first B". Can you give an example? Paul From: Jorge Marques To: excel-macros@googlegroups.com Sent: Sat, February 12, 2011 9:47:21 AM Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to c

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-12 Thread Paul Schreiner
It's like the text-to-columns in Excel 2007. If you have a string: "The Quick Brown Fox jumped over the lazy dog" and you wanted to store the words into an array, If you're using Option Explicit (recommended) you have to declare the variable: Dim StrArray (but don't define an array SIZE) Next,

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-12 Thread Jorge Marques
Oh ok Paul, i did it that way, because i recorded it first, then defined the Range("A" & i), but it´s good now, millions thanks, the activecell i did remember to leave just the range, still taking baby steps in this :) I forgot to mention, after this i have to switch the cells, the Last A goes to

Re: $$Excel-Macros$$ Inch into normal

2011-02-12 Thread Yahya
Dear Manhar Please see attached file with the solution. On Sat, Feb 12, 2011 at 11:26 AM, manhar prajapati < prajapati.man...@gmail.com> wrote: > Dear All > I require your urgent help for attach file. > > Please find attach file for calculation of Square meter form Inches to > Centimeter. > > I

$$Excel-Macros$$ Inch into normal

2011-02-12 Thread manhar prajapati
Dear All I require your urgent help for attach file. Please find attach file for calculation of Square meter form Inches to Centimeter. I want to a formula which convert inches in to Centimeter. Example 10' 3'' is equal to 10.25 for Calculation of Square Feet. Thanks and regards Manhar Prajapa

$$Excel-Macros$$ Use of Phonetic Property

2011-02-12 Thread rajan verma
Please Explain the Phonetic Property of Range Object -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldail

RE: $$Excel-Macros$$ Button programming

2011-02-12 Thread Anil Bhange
It wont be possible as enabling or disabling of macro is depend up on the each computer security policy You can't do that If is one time efforts which you have to do in all computers Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [m

RE: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-12 Thread Dave Bonallack
Hi Paul, I'm really interested in the part of the macro that I have highlighted below (in case the highlighting doesn't travel well, I've marked each line with a *) I've not seen the 'Split' function before. I looked it up in the Help, but still couldn't make sense of it. If you have time, could

Re: $$Excel-Macros$$ "ashish koul" ,

2011-02-12 Thread ashish koul
attachment missing On Fri, Feb 11, 2011 at 9:07 PM, Rajasekhar Praharaju < rajasekhar.prahar...@gmail.com> wrote: > Hi, > > > > I have an excel sheet and I want to filter for BLANKS in multiple columns > and provide comment of the other column. Can some one help me writing a > macro/add-on? expan