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

hi Andre, i have made it by selecting complete sheet/ all cells just try if it works for you Cells.Select Selection.Replace What:="#", Replacement:="=", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Range("A1")

Re: $$Excel-Macros$$ Sorting by levels

hi Sergiovery, i tried is for you.see the solution sheet.. hope this will help On Fri, Mar 15, 2013 at 7:04 PM, Sergiovery wrote: > Here it is! > Thanks for your time :-) > Sergiovery > > > Il giorno venerdì 15 marzo 2013 13:16:27 UTC+1, viney mehta ha scritto: > >> Please send the excel f

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

The problem is that you are replacing a string with another string when you want to replace it with a formula So Try ActiveCell.formula =Replace(ActiveCell.Value,"#","=",1,,vbTextCompare) Regards David Grugeon On 16 March 2013 04:10, André D'Avila wrote: > Hey Prince, thanks for the answer

Re: $$Excel-Macros$$ Unlock Cells on Condations

It works perfectly on my spreadsheet. I think you filled the dates using a formula. Change xlFormulas to xlValues. It would also be good to put Dim r as Range at the head of the macro. Regards David Grugeon On 15 March 2013 23:47, Prashant Pednekar wrote: > Dear Dave, and other friends. >

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

Hey Prince, thanks for the answer. I tryed here, but have no sucess... The problem is pasting the information inside a cell. I Have a string like -> *#Sum(a1:a2)* but then i take of the "#" (via macro) and put a "=" sign then it doesnt recognize. Replacing the "=" sign to "#" character is ok. R

Re: $$Excel-Macros$$ Unlock Cells on Condations

Dear Dave, and other friends. I am using belwo code for locking rows. It is not working. Can you let me know where i am going wrong. my date value is in first column. Private Sub Worksheet_Activate() ActiveSheet.Unprotect Rows("5:1200").Locked = True With Range("A5:A1500") Set

Re: $$Excel-Macros$$ Sorting by levels

Here it is! Thanks for your time :-) Sergiovery Il giorno venerdì 15 marzo 2013 13:16:27 UTC+1, viney mehta ha scritto: > Please send the excel file to analyse and understand > > > On Fri, Mar 15, 2013 at 5:31 PM, gurur...@gmail.com < > gurur...@gmail.com > wrote: > >> >> >> >> >> Sent from my

Re: $$Excel-Macros$$ Sorting by levels

Please send the excel file to analyse and understand On Fri, Mar 15, 2013 at 5:31 PM, gururam...@gmail.com wrote: > > > > > Sent from my HTC > > > - Reply message - > From: "Sergiovery" > To: > Subject: $$Excel-Macros$$ Sorting by levels > Date: Fri, Mar 15, 2013 16:36 > > > Hello! > I

Re: $$Excel-Macros$$ Sorting by levels

Sent from my HTC - Reply message - From: "Sergiovery" To: Subject: $$Excel-Macros$$ Sorting by levels Date: Fri, Mar 15, 2013 16:36 Hello!I've tried to look for solution to my problem waving the site...but till now, no success :-( My issue: I've a table with these 7 columns A. Colum

$$Excel-Macros$$ Sorting by levels

Hello! I've tried to look for solution to my problem waving the site...but till now, no success :-( My issue: I've a table with these 7 columns A. Column1 "L": Belonging level (1, 2, 3...) where the records ar grouped by "family" and "sub-family" *EXAMPLE**

Re: $$Excel-Macros$$ Re: Data Validation to force users to enter aparticular date format *

thanks prince much apprciated. On Thu, Mar 14, 2013 at 5:48 AM, Prince wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (prince141...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ vlookup cell comments along with data

Yes... it is possible but using VBA coding Please check below link for http://www.pcmag.com/article2/0,2817,2130132,00.asp . Enjoy Team XLS On Fri, Mar 15, 2013 at 12:52 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hello Group, > > Is it possible

Re: $$Excel-Macros$$ Getting an error when inserting a new row is inserted

Error due to blank row in range .. please delete and try again . Enjoy Team XLS On Fri, Mar 15, 2013 at 1:07 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hello Group, > > I have a attendance tracker which works fine but when I try to increase > the

$$Excel-Macros$$ Getting an error when inserting a new row is inserted

Hello Group, I have a attendance tracker which works fine but when I try to increase the data range or insert a new row it gives me a error. Attached is the excel file the top part works fine,however when I tried to insert a new row/increase the range it gives me error.I have shown the error par

$$Excel-Macros$$ vlookup cell comments along with data

Hello Group, Is it possible to look up the value in the cell along with the cell comments or cell colour. As far I know we can pick the cell colour using "Get.cell" but not aware how to us it and I cannot use macros in the file -- Regards Santosh santoshkumar.subu...@gmail.com -- Are you =EXP(