Re: $$Excel-Macros$$ Conditional Formatting Excel 2007

Hi , See Below Links... http://www.contextures.com/xlcondformat03.html\ http://www.dummies.com/how-to/content/applying-conditional-formatting-in-excel-2007.html *Best Regards,* *Venkat * *Chennai* *My Linked in profile * * * On Wed, Sep 7, 2011

Re: $$Excel-Macros$$ How to recast a variant as an array in VBA

Hi, See below links.. http://www.mrexcel.com/forum/showthread.php?t=32187 http://www.ozgrid.com/forum/showthread.php?t=69235&page=1 http://www.cpearson.com/excel/vbaarrays.htm *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Wed,

Re: $$Excel-Macros$$ Re: blink the Label caption

It won't work... Just want to confirm whether do you want to blink your text in a label or in cells...?? Regards Deepak On Wed, Sep 7, 2011 at 7:30 PM, Bheema Shankar wrote: > Deepak ji > > I made little changes to your code to blink my label caption on the > form: > > > Dim MyArray() As Variant

Re: $$Excel-Macros$$ Add the multiple row values & delete the duplicate row

Hi Noorain, Opportunity column contains the duplicate. I need to convert the rows in to unique by adding the values. Regards Anu On Thu, Sep 8, 2011 at 10:37 AM, NOORAIN ANSARI wrote: > Hi anu, > > Please explain the criteria of duplicacy. > Like another row should be same campare to first

Re: $$Excel-Macros$$ Add the multiple row values & delete the duplicate row

Hi anu, Please explain the criteria of duplicacy. Like another row should be same campare to first row. On Thu, Sep 8, 2011 at 10:21 AM, anu gomathi wrote: > Hi Experts, > > Need your help in this. > > Regards > > Anu > > On Wed, Sep 7, 2011 at 11:37 PM, anu gomathi > wrote: > >> Hi All,

Re: $$Excel-Macros$$ Add the multiple row values & delete the duplicate row

Hi Experts, Need your help in this. Regards Anu On Wed, Sep 7, 2011 at 11:37 PM, anu gomathi wrote: > Hi All, > > Attached the sample file with the duplicate opportunity details. I need to > add the values in the 1 row & delete the duplicate rows. > > Need u r help to create macros. > > Regard

$$Excel-Macros$$ Report Generation

What is the procedure to develop reports basing on the excel database through UserForm. Report generation in the sense, not in column and rows. It would be look like a form in word document. -- -- Some important lin

Re: $$Excel-Macros$$ problem with cell width in a workbook

good morning Noorain I tried with your example sheet. But it is fitting the cell width just like the Format-->Autofit option in the excel. But what I need is, the particular cells containing the red font has to be fit to their text width and the following column width may left as they are. sup

Re: $$Excel-Macros$$ PDF to Excel

On Thu, Sep 8, 2011 at 9:17 AM, Prabhu wrote: > Hi Ahsish, > > > Now Debug highlighted the below line. > "Subscript out of range" > > Windows("pdf to excel.xlsm").Activate > > > *Adobe reader X shows "There was an error opening this documents.Access > denied.* > > > On Thu, Sep 8, 2011 at 8:09

Re: $$Excel-Macros$$ PDF to Excel

Hi Ahsish, Now Debug highlighted the below line. Windows("pdf to excel.xlsm").Activate *Adobe reader X shows "There was an error opening this documents.Access denied.* On Thu, Sep 8, 2011 at 8:09 AM, ashish koul wrote: > Also change path of winzip > > a = "C:\Program Files\Adobe\Acrobat 6.

Re: $$Excel-Macros$$ How to develop a query for excel table

@ Tariq & XLS S.. I will also required all details in next line for input given by me.. E.g If for supplier no. 'X' & Buiness Role 'Y'..if ther are 3-4 contacts details available then I should get all 3-4 contact details against input given by me..it should fetch all details related to input n no

Re: $$Excel-Macros$$ PDF to Excel

Also change path of winzip a = "C:\Program Files\Adobe\Acrobat 6.0\Reader\AcroRd32.exe" On Wed, Sep 7, 2011 at 9:20 PM, Prabhu wrote: > HI Ashish, > > I have changed the PDF file path address, apart from this change i have to > any changes? > > Because i am getting run time error. Debug hig

Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

Hi, Sub test() For i = 1 To 10 ThisWorkbook.Sheets(Array("Sheet1", "Sheet2")).Copy ActiveWorkbook.SaveAs "C:\Documents and Settings\ASHISH\Desktop\ABC\book" & i & ".xlsx" ActiveWorkbook.Close Next i End Sub On Wed, Sep 7, 2011 at 5:29 PM, SridharBL wrote: > Ashish, > > I need to save the shee

Re: $$Excel-Macros$$ rounding to next higher rupee

ya its working. amazing. thank you so much On Wed, Sep 7, 2011 at 9:48 PM, NOORAIN ANSARI wrote: > see if it help > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ VBA Doubt

Its ok saber On Wed, Sep 7, 2011 at 8:05 PM, mohd saber wrote: > Hi Shankar, > > Sorry to say that as far as i know there is no way > > regards, > saber > > On Wed, Sep 7, 2011 at 8:02 PM, Shankar Bheema wrote: > >> means sir, is there no way to do like Visual basic with VBA excel ? >> >> >> O

Re: $$Excel-Macros$$ code for search

how to place grid control in vba excel ? On Wed, Sep 7, 2011 at 8:04 PM, dguillett1 wrote: > I’m one of those people who doesn’t much care for pivot tables and > userforms. KISS (Keep it simple, stupid). Not meant personally. > > *From:* Shankar Bheema > *Sent:* Wednesday, September 07, 201

Re: $$Excel-Macros$$ problem with duplication of data

thank you so much saber On Wed, Sep 7, 2011 at 8:03 PM, mohd saber wrote: > Hi Shankar, > > Please find the below updated data for the command file > > Private Sub CommandButton1_Click() > ActiveWorkbook.Sheets("Employee Details").Activate > Range("A1").Select > Do > >If IsEmpty(ActiveCell)

Re: $$Excel-Macros$$ Reasons for increase in excel file size

Hey Amit, Try this *Method 1:* 1. Open the Excel file 2. Then save the Excel file in html format 3. Then save the html document into xls but as another name *For spreadsheets with only text:* *Method 2:* 1. Open the Excel file 2. Save the Excel file as xml format 3. Save the

Re: $$Excel-Macros$$ Conditional Formatting Excel 2007

Hey , Please send the attachment... try the below link http://www.contextures.com/xlcondformat02.html http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel On Wed, Sep 7, 2011 at 1:30 PM, zp18 wrote: > A1=the name of an employee, defined name is "Suspect" > A2= an amount of money, defi

$$Excel-Macros$$ Add the multiple row values & delete the duplicate row

Hi All, Attached the sample file with the duplicate opportunity details. I need to add the values in the 1 row & delete the duplicate rows. Need u r help to create macros. Regards Anu -- -- Some important links fo

Re: $$Excel-Macros$$ rounding to next higher rupee

see if it help -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed, Sep 7, 2011 at 7:22 PM, Shankar Bheema wrote: > I am attaching an excel file with i

Re: $$Excel-Macros$$ Need some help in transposing data

Dear Nishant, Please see attached sheet.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed, Sep 7, 2011 at 5:15 PM, Nishant Singla wr

RE: $$Excel-Macros$$ rounding to next higher rupee

Private Sub CommandButton1_Click() TextBox2.Text = Application.RoundUp(Val(TextBox1.Text), 0) End Sub 100.1 results to be 101. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Shankar Bheema Envoyé : mercredi 7 septembre 2011 15:52 À : exc

Re: $$Excel-Macros$$ PDF to Excel

HI Ashish, I have changed the PDF file path address, apart from this change i have to any changes? Because i am getting run time error. Debug highlighted the below line. c = Shell("" & a & " " & b & "", 1) -- -- S

Re: $$Excel-Macros$$ Decrease the gap between bars in Bar Chart

Change the AXES to category. You don’t say which version but in 2003 right click the chart and select From: Ramanjaneya Reddy Sent: Tuesday, September 06, 2011 10:45 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Decrease the gap between bars in Bar Chart Is there any way to

Re: $$Excel-Macros$$ VBA Doubt

Hi Shankar, Sorry to say that as far as i know there is no way regards, saber On Wed, Sep 7, 2011 at 8:02 PM, Shankar Bheema wrote: > means sir, is there no way to do like Visual basic with VBA excel ? > > > On Wed, Sep 7, 2011 at 7:46 PM, mohd saber wrote: > >> Hi Shankar, >> >> As far as i

Re: $$Excel-Macros$$ code for search

I’m one of those people who doesn’t much care for pivot tables and userforms. KISS (Keep it simple, stupid). Not meant personally. From: Shankar Bheema Sent: Wednesday, September 07, 2011 9:04 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ code for search not working. and

Re: $$Excel-Macros$$ problem with duplication of data

Hi Shankar, Please find the below updated data for the command file Private Sub CommandButton1_Click() ActiveWorkbook.Sheets("Employee Details").Activate Range("A1").Select Do If IsEmpty(ActiveCell) = False Then If activecell.value = txtfileno.value Then ActiveCell.Offset(0, 1) = txtname.Te

Re: $$Excel-Macros$$ Re: rounding to next higher rupee

thank you so much sam On Wed, Sep 7, 2011 at 7:47 PM, GoldenLance wrote: > TextBox2.Text = Application.RoundUp(Val(TextBox1.Text), 0) > > Regards, > > Sam Mathai Chacko (GL) > > On Sep 7, 6:52 pm, Shankar Bheema wrote: > > I am attaching an excel file with inserted userform. > > > > I have give

Re: $$Excel-Macros$$ VBA Doubt

means sir, is there no way to do like Visual basic with VBA excel ? On Wed, Sep 7, 2011 at 7:46 PM, mohd saber wrote: > Hi Shankar, > > As far as i understand is that you want only the userform not the excel > workbook. > If this is the case you need to use VISUAL BASIC for preparing the form

$$Excel-Macros$$ Re: How to recast a variant as an array in VBA

You cannot reference a variant array using a byte array even if the data contained within the variant array is all byte. Suggest using Sub ConsumesByteArray(ByRef ByteArray) On Sep 7, 3:26 pm, ShayneH wrote: > Is there a way to expose an array that is enclosed by a variant? > Basically I have on

Re: $$Excel-Macros$$ Re: VBA Doubt

I attached the workbook On Wed, Sep 7, 2011 at 7:41 PM, deepu wrote: > Can you please elaborate?? What exactly you want to do..?? It'll be > helpful if you can provide any demo workbook.. > > Regards > Deepak > > On Sep 7, 6:17 pm, Shankar Bheema wrote: > > Hai all > > > > What I have a problem

$$Excel-Macros$$ Re: rounding to next higher rupee

TextBox2.Text = Application.RoundUp(Val(TextBox1.Text), 0) Regards, Sam Mathai Chacko (GL) On Sep 7, 6:52 pm, Shankar Bheema wrote: > I am attaching an excel file with inserted userform. > > I have given command button to roundoff the figure in textbox1.text to the > next higher rupee.  I have

Re: $$Excel-Macros$$ VBA Doubt

Hi Shankar, As far as i understand is that you want only the userform not the excel workbook. If this is the case you need to use VISUAL BASIC for preparing the form not vba which is inbuilt in any application. Please let me know if you need any clarification. Regards, saber On Wed, Sep 7, 2011

$$Excel-Macros$$ Re: VBA Doubt

Can you please elaborate?? What exactly you want to do..?? It'll be helpful if you can provide any demo workbook.. Regards Deepak On Sep 7, 6:17 pm, Shankar Bheema wrote: > Hai all > > What I have a problem is,  I made an userform with all controls.  But it > wont be directly accessed without op

Re: $$Excel-Macros$$ code for search

not working. and where to put this code. I made it on userform not on sheet. So in your formula there is no representation of the objects na. how it works ? On Wed, Sep 7, 2011 at 7:20 PM, dguillett1 wrote: > How about a formula > > =INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0),MATCH(E

$$Excel-Macros$$ Re: blink the Label caption

Deepak ji I made little changes to your code to blink my label caption on the form: Dim MyArray() As Variant Dim i As Integer, R As Long, C As Integer Dim vText As String Dim DelayLoop1 As Long, DelayLoop2 As Long Sub StartBlinking() vText = Label1.Caption For i = 1 To Len(vText) ReDim Prese

$$Excel-Macros$$ Re: blink the Label caption

thank you deepu On Sep 7, 5:42 pm, deepu wrote: > Though MS-Excel is not an application where you can make high class > animation.. but it depends on your creativity.. how do you utilize > your knowledge to bring such an effects in Excel.. Below is the code > that I've create, you can modify it a

$$Excel-Macros$$ rounding to next higher rupee

I am attaching an excel file with inserted userform. I have given command button to roundoff the figure in textbox1.text to the next higher rupee. I have given the code as textbox2.text=Round(val(textbox1.text),0) but its returning wrong result. if i have given 100.1 in textbox1.text the resu

Re: $$Excel-Macros$$ code for search

How about a formula =INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0),MATCH(E4,B:B,0)),IF(NOT(ISNUMBER(E4)),1,2)) From: Shankar Bheema Sent: Wednesday, September 07, 2011 8:14 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ code for search Hai all good evening I am a

$$Excel-Macros$$ problem with duplication of data

I placed the following objects on my VBA excel TextBoxes a) file no b) Name Command buttons a) Save b) Update In save button I have given code as@@@ Private Sub CommandButton1_Click() ActiveWorkbook.Sheets("Employee Details").Activate Range("A1").Select Do If IsEmpty

$$Excel-Macros$$ Need some help in transposing data

Hello Friends ... I have attached the file above I have the data in this form given in the attached file ... I need to convert it into the format given in the attached file ... Kindly help me ASAP ... Regards Nishant Singla Mobile : 9910329711 , 9463087506 -- ---

$$Excel-Macros$$ How to recast a variant as an array in VBA

Is there a way to expose an array that is enclosed by a variant? Basically I have one function that returns a variant type which needs to be passed to another procedure that requires the parameter to be typed as a byte array. eg: Function UsuallyReturnsAnArray() As Variant the result, after testi

$$Excel-Macros$$ Re: blink the Label caption

Though MS-Excel is not an application where you can make high class animation.. but it depends on your creativity.. how do you utilize your knowledge to bring such an effects in Excel.. Below is the code that I've create, you can modify it according to your requirements, you might want to change fo

Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

Ashish, I need to save the sheets of One Workbook to 12 other workbooks. Say, I have One Master excel work book with sheets x and y. These x and y sheets should be moved to other 12 workbooks. So, now all the 12 Work books will have x & y sheets as of Master excel work book. Thanks, Sridhar

$$Excel-Macros$$ VBA Doubt

Hai all What I have a problem is, I made an userform with all controls. But it wont be directly accessed without opening the excel form.. Pls suggest me a way to access directly the userform without opening the Excel sheet. -- --

$$Excel-Macros$$ code for search

Hai all good evening I am attaching the excel sheet which contains file numbers and names in corresponding file number. I placed an userform with file no. and name with a command button for search. If we know the name and dont know the file no. by giving little part of the name and if pressed on

Re: $$Excel-Macros$$ problem with cell width in a workbook

I am not getting even after selection as you said. I noticed non of the control is allowing to work on the sheet what would be the prblem with my excel ? On Wed, Sep 7, 2011 at 6:31 PM, NOORAIN ANSARI wrote: > Dear Bheema, > > First of all you select a range when you want to apply it... > it wor

Re: $$Excel-Macros$$ problem with cell width in a workbook

Dear Bheema, First of all you select a range when you want to apply it... it work after selection... you select red font area then press it.. Hope it will work fine.. On Wed, Sep 7, 2011 at 6:24 PM, Shankar Bheema wrote: > I downloaded your file but unable to cli

Re: $$Excel-Macros$$ How to develop a query for excel table

Sub Unfilter() ActiveSheet.ShowAllData End Sub Sub Filter() With Range("a2:f" & Cells(Rows.Count, 1).End(xlUp).Row) .AutoFilter field:=1, Criteria1:=Range("b16") .AutoFilter field:=6, Criteria1:=Range("b17") End With End Sub -Original Message- From: Tariq Aziz Sent: Wednesday, Sep

Re: $$Excel-Macros$$ problem with cell width in a workbook

I downloaded your file but unable to click on the command button as I placed my cursor on the command button it is turning into 4 headed arrow and clicking is not possible. what to do ? On Tue, Sep 6, 2011 at 11:02 PM, NOORAIN ANSARI wrote: > Dear Bheema, > > Please try it and see attached sheet

Re: $$Excel-Macros$$ Reasons for increase in excel file size

Be sure to SAVE your file before rechecking. Older versions may require closing the file and reopening. From: RK Sent: Wednesday, September 07, 2011 4:12 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Reasons for increase in excel file size Try the following: Press CTRL+A

Re: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?

Here is an example of the code (PastePicture is a function to paste the graph from the clipboard into the image control; the code comes originally from the website of Stephen Bullen and is too long to include here). What may happen is that the Image2-control is not filled with the correct Chart, bu

Re: $$Excel-Macros$$ Reasons for increase in excel file size

Try the following: Press CTRL+A Press F5 Click on special at left bottom Choose blank Click ok Go to edit in the menu Choose clear Click all Press CTRL+END See if this is truly the end of your file, delete all unnecessary rows and column. Again press CTRL+END Delete all cols to the right of it an

$$Excel-Macros$$ Decrease the gap between bars in Bar Chart

Is there any way to decrease the gap between bars (NOT the width of the bars) of excel bar chart? I made a bar chart with 23 dates (weeks like 10/5/2007, 10/12/2007, 10/19/2007 etc.). The row were very thin and the gap between the rows is long. Can we decrease the gap between the bars to make it lo

RE: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

CONGRATULATIONS... Who help others God will help them ..! Gulam Hameed From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dilip Pandey Sent: Wednesday, September 07, 2011 9:21 AM To: excel-macros@googlegroups.com Cc: rajanverma1...@gmail

$$Excel-Macros$$ Conditional Formatting Excel 2007

A1=the name of an employee, defined name is "Suspect" A2= an amount of money, defined as "MaxLoss" B1:B8 is a column of money defined as "Shortages" C1:G8 is a range of employee names defined as "Associates" if the money contained in MaxLoss is less than the amount in column of Shortages and the

$$Excel-Macros$$ blink the Label caption

Pls provide code for BLINK affect for Label caption. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http:

RE: $$Excel-Macros$$ Reasons for increase in excel file size

Thanks I have removed all the conditional formatting, but file size is still not getting reduced! Best Regards, Amit Desai rom: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Divaker Pandey Sent: Wednesday, September 07, 2011 1:18 PM To: excel-macros@googlegro

Re: $$Excel-Macros$$ to get printing dialogue box on printing

thank you noorain for providing solution. I will try and let you know the result. On Tue, Sep 6, 2011 at 9:41 PM, NOORAIN ANSARI wrote: > Dear Bheema, > > Try it... > > Private Sub CommandButton1_Click() > Application.Dialogs(xlDialogPrint).Show > End Sub > > Thanks & regards, > Noorain Ansari >

Re: $$Excel-Macros$$ Reasons for increase in excel file size

you have just change cell formatting again and again. clear all formatting.and then apply on only used cell. Divaker On Wed, Sep 7, 2011 at 10:59 AM, bé trần văn wrote: > > > 2011/9/7 Amit Desai (MERU) > >> What could be the reason for increase in excel file? I have a file with >> size of 4.5