$$Excel-Macros$$ Re: Replace a character to equal sign - VBA

Just Create a macro and passed your range, each cells with loop where i have used ActiveCell.value Replace(ActiveCell.Value,"#","=",1,,vbTextCompare) Regards Prince On Friday, March 15, 2013 12:49:03 AM UTC+5:30, André D'Avila wrote: > > Guys, please help me. > > Inside VBA, i want to replace

Re: $$Excel-Macros$$ Required Macro for unique no

Dear Viney, GoodReally appreciate your first post . that good.Keep it up... Pls do helping to our forums Warm Regards. Gawli Anil On Thu, Mar 14, 2013 at 4:54 PM, Viney wrote: > Hi Shiva, > > this is my first post to the group... > > > try this macro > > > Sub RemoveDuplicates()

Re: $$Excel-Macros$$ Excel 13 macros

What happens if you go Alt-F11 to open the VBE? Are macros enabled? Have a look at file/options/security (or could be .../advanced/security and look at macro security. Might alsoneed to look in Trust Centre Settings. All based on Office 2010 - but it is similar. My guess is that along with tr

$$Excel-Macros$$ Excel 13 macros

I moved up to Excel 13 less than a month ago with functioning spreadsheets. Last night Microsoft wiped out the sort macros on my most used spreadsheet. No problem; I'll just re-enter them. Oops, clicking MACTOS I find RECORD MACRO is greyed out. This sort macro sorts twice each of four differe

$$Excel-Macros$$ Replace a character to equal sign - VBA

Guys, please help me. Inside VBA, i want to replace the character "#" below, to the equal sign... #Tech!$AB3 To =Tech!$AB3 Teoricaly is easy but the code doesnt work!!! Cells.select Selection.Replace What:="#", replacement:="=" -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you w

$$Excel-Macros$$ My Excel is Crashing!!

New thread i know , every user face it lets post here the possible reasons of crashing excel and find out the way to get rid of it. -- Regards Rajan verma +91 9158998701 -- 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

$$Excel-Macros$$ Re: Find Distance and Time between two cities using Google Map In excel

Alt+F11 regards PRINCE On Thursday, March 14, 2013 4:18:32 PM UTC+5:30, sagaraher wrote: > > Can you pl tel me how to run it, as I cant see option available in view-> > Macro > > On Saturday, February 25, 2012 6:31:12 PM UTC+5:30, ashish wrote: >> >> Hi Group >> >> Try this udf it will help you

$$Excel-Macros$$ Re: Required Macro for unique no

Hi Shiva Why dont you use remove Duplicate option of excel itself. regards prince On Thursday, March 14, 2013 4:47:13 PM UTC+5:30, shivapr...@gmail.com wrote: > > > Dear champs, > > please find the attchement of test sheet any one provide macro for unique > no. > > plase help me. > -- > > > >

Re: $$Excel-Macros$$ Required Macro for unique no

Hi Shiva, this is my first post to the group... try this macro Sub RemoveDuplicates() ' ' Macro2 Macro ' ' Sheets("Sheet1").Select Columns("B:B").Select Selection.Copy Columns("H:H").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

Re: $$Excel-Macros$$ Macro for filter data & send it to respective user through mail

Outlook On Mar 14, 2013 3:37 PM, "अनिल नारायण गवली" wrote: > Dear Sagar, > > From which mail u want to send the file ? from gmail,yahoo, or from > outlook??? > > > Warm Regards, > Gawli Anil > > > > On Thu, Mar 14, 2013 at 3:29 PM, sagaraher wrote: > >> Hello, >> >> I am looking for Macro for fi

$$Excel-Macros$$ Re: Find Distance and Time between two cities using Google Map In excel

Can you pl tel me how to run it, as I cant see option available in view-> Macro On Saturday, February 25, 2012 6:31:12 PM UTC+5:30, ashish wrote: > > Hi Group > > Try this udf it will help you in finding the time and distance between two > cities using Google Map > > > > -- > *Regards* > * * >

Re: $$Excel-Macros$$ FW: Amount clean after closed file

In the This Workbook module put the following Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Sheet1.TextBox1.Text = "" ThisWorkbook.Save End Sub Regards David Grugeon On 14 March 2013 19:37, Umesh Gupta wrote: > > > -- > From: umeshj...@live.com > To: da

Re: $$Excel-Macros$$ Macro for filter data & send it to respective user through mail

Dear Sagar, >From which mail u want to send the file ? from gmail,yahoo, or from outlook??? Warm Regards, Gawli Anil On Thu, Mar 14, 2013 at 3:29 PM, sagaraher wrote: > Hello, > > I am looking for Macro for filter data & send it to respective user > through mail, pl find details below > 1)

$$Excel-Macros$$ Macro for filter data & send it to respective user through mail

Hello, I am looking for Macro for filter data & send it to respective user through mail, pl find details below 1) I have various dept like SCM / Mktg / Engg / HR etc & data attached to each dept, when we apply filter we can see data related to particular dept. 2) I want to create separate excel

$$Excel-Macros$$ FW: Amount clean after closed file

From: umeshj...@live.com To: davebonall...@hotmail.com Subject: Amount clean after closed file Date: Thu, 14 Mar 2013 15:00:46 +0530 Hello Dave I need soluation when closed excel file amount will be clean Thanks -- Are you =EXP(E:RT)