Re: $$Excel-Macros$$ How to link a cell between two worksheets keeping the Hyperlink?

Test mail Please ignore Thanks & regards, www.MrExcel4U.com On Thu, Mar 6, 2014 at 5:20 PM, Caroline Campos wrote: > I have two worksheets and I linked the cells to change automatically, but > when I insert a hyperlink in the cell of the original worksheet, it

$$Excel-Macros$$ Save an Excel file as XML

How to save an excel table data in XML format. TIA. Eugene -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles.

$$Excel-Macros$$ formatar colunas com especificidade melhor

Olá. Na planilha que estou melhorando há os seguintes campos: cpf, nome, email E nomebreve. Necessito o seguinte; 1 - cpf : somente seus números e quantidade de 11, nem mais nem menos, 11 dígitos numéricos; 2 - nome : somente letras; 3 - email : máscara para E-mail, algo como (*@*provedor.

$$Excel-Macros$$ Re: additional row creation

Thanks, Ravinder! I really appreciate it! On Thursday, March 13, 2014 3:33:25 PM UTC-7, E J wrote: > > Hi Everyone, > > I was wondering if I could get help with a macro. I'm trying to write a > macro (with no luck) that walks down a column based on the initial > placement of the active cell. E

Re: $$Excel-Macros$$ additional row creation

Thanks, Vikas. Wow. This is great! I sincerely appreciate it. On Thursday, March 13, 2014 10:18:44 PM UTC-7, Vikas Verma wrote: > > Hi E J try this... > > > Sub testing() > > Dim rng As Range > Dim rcount As Long > Dim cel As Range > > rcount = Sheets(1).Cells(Rows.Count, "c").End(xlUp).Row > Se

Re: $$Excel-Macros$$ Dynamic Attachment with Email Send

Dear Mr. Richard, Thanks for the reply. im really happy for received E Mail from you for what i'm expected and i have few more requirement to fulfill the process what i exactly need as mentioned below. 1. I want to send it through MS Outlook instead of Gmail. 2. Not Require a Command Button in Ex

Re: FW: $$Excel-Macros$$ Conditional Formating

Dear Sir, Once i select that cell then i will apply condition formatting selected cell. that's why i want to know the selection of that cells which having % formatting. Initially, I was doing same by using F5-Selection-Formula and then applied condition formatting. but this times other formulas a

RE: FW: $$Excel-Macros$$ Conditional Formating

What you want to do with that selection...color them or else Below is code to color % format cell Sub Button1_Click() Dim ws As Worksheet Dim cell As Range Set ws = ThisWorkbook.ActiveSheet For Each cell In ws.UsedRange If cell.NumberFormat = "0.00%" Then cell.Interior.Color = vbGr

Re: FW: $$Excel-Macros$$ Conditional Formating

Dear Sir, I want a VBA code ;which will select the all cell in sheet where cell format is "0.00%" Regards, Prafull Jadhav 9920553518 On 14 March 2014 15:31, Ravinder wrote: > You just select the whole range of tables and put condition formatting as > already applied on $A$1:$L$21, you can in

RE: FW: $$Excel-Macros$$ Conditional Formating

You just select the whole range of tables and put condition formatting as already applied on $A$1:$L$21, you can increase as per your requirement. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prafull Jadhav Sent: Friday, March 14, 2014 3:29 PM To: exce

Re: FW: $$Excel-Macros$$ Conditional Formating

Dear Sir, It is not working.. Please let me know how I can select the all cell in sheet where cell format is "%" Regards, Prafull Jadhav 9920553518 On 14 March 2014 15:12, Ravinder wrote: > Pfa. if not receive... > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googleg

$$Excel-Macros$$ Differenent text returns using Cell("format" address) formula in excel.

Screen Clipping -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgen

$$Excel-Macros$$ Re: commandbar dropdown menu to count worksheets

That's really not an easy problem. I didn't figure out where did you do wrong in your codes. Don't know if some thing like the UI commandbar controland UI dropdown list controlbe