Re: $$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

Hi Suyog Kulkarni, See how build an Excel Add -In http://www.fontstuff.com/vba/vbatut03.htm Regards, Basole 2014-04-05 1:22 GMT-03:00 Suyog Kulkarni : > Hi Basole, > > It's working fine now following are the only problems remaining. > 1. While creating macro, I have assigned "ctrl+q" shortcu

Re: $$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

you need to select the range and then run proper, upper , lower etc as per your requirement On Sat, Apr 5, 2014 at 9:54 PM, Falina Gan wrote: > Hi Ashish, > > Good day, > > I have tested your codes but the texts are not changes at all. The macro > have asked me which one to run and I have run

Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

Glad to Help you. Much Obliged, On Sat, Apr 5, 2014 at 12:42 PM, prkhan56 wrote: > Thanks Vicky. > Works like a charm > > > On Saturday, April 5, 2014 3:45:49 AM UTC+4, Vicky wrote: > >> Rashid Sir, >> >> I have made some changes. Now you can change your input column to any >> column in the s

$$Excel-Macros$$ Re: Delete button on Sequence Column

Hi Ashish, After the delete button it will show the pattern column. Thanks for asking. :) On Saturday, April 5, 2014 1:00:26 PM UTC+8, Falina Gan wrote: > > To Whom It May Concern, > > Could you guide me with VBA codes, on these steps:- > > 1) Create a sequence column as image below ( all in alp

$$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

Hi Ashish, Good day, I have tested your codes but the texts are not changes at all. The macro have asked me which one to run and I have run all the sub function but still can't see the results. Thanks

Re: $$Excel-Macros$$ Macro for copying from a notepad and creating a record in excel

can u share how your output look likes On Thu, Apr 3, 2014 at 10:25 PM, Subhra Sardar wrote: > > > I am new to VBA and I need a little help with VBA.The file is attached. > > As you can see below *column B *(EVENT TYPE) there is a field named *JOB* and > below the field *JOB* there is a field n

Re: $$Excel-Macros$$ Delete button on Sequence Column

who will be creating the pattern column ? On Sat, Apr 5, 2014 at 10:30 AM, Falina Gan wrote: > To Whom It May Concern, > > Could you guide me with VBA codes, on these steps:- > > 1) Create a sequence column as image below ( all in alphabets ) > 2) Delete button to delete the sequence column > 3)

Re: $$Excel-Macros$$ Compare two worksheet Trial Balance

please share a sample workbook with some dummy data On Sat, Apr 5, 2014 at 8:02 PM, Sandeep Kumar Chhajer < chhajersand...@gmail.com> wrote: > Dear Excel gurus, > > Kindly check the trailing mail. > Thanks & Regards, > Sandeep Kumar Chhajer > Mumbai > India > > Sent on my BlackBerry(R) from Voda

Re: $$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

Sub propercase() Dim cl As Range For Each cl In Selection.Cells If cl.HasFormula = False And Not IsEmpty(cl) And Not IsDate(cl) Then cl = StrConv(cl.Text, vbProperCase) End If Next End Sub Sub uppercase() Dim cl As Range For Each cl In Selection.Cel

Re: $$Excel-Macros$$ Help to merge text from difference cell

please share a sample workbook On Sat, Apr 5, 2014 at 1:18 PM, Ashish Bhalara wrote: > Dear experts, > > I want merge cell containing text value and want comma(,) between all cell > value in cocatenate function but my query is that when cell value is blank, > the comma should not be display. Is

Re: $$Excel-Macros$$ Compare two worksheet Trial Balance

Dear Excel gurus, Kindly check the trailing mail. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -Original Message- From: "Sandeep Kumar Chhajer" Sender: excel-macros@googlegroups.com Date: Sat, 5 Apr 2014 04:21:56 To: Excel Macros Reply-

$$Excel-Macros$$ Help to merge text from difference cell

Dear experts, I want merge cell containing text value and want comma(,) between all cell value in cocatenate function but my query is that when cell value is blank, the comma should not be display. Is it possible, kindly guide regarding this. Thanks & regards. Ashish Bhalara 9624111822 P*Please d

Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

Thanks Vicky. Works like a charm On Saturday, April 5, 2014 3:45:49 AM UTC+4, Vicky wrote: > > Rashid Sir, > > I have made some changes. Now you can change your input column to any > column in the sheet and output will be 3 column forward and 1 row down from > the input data.. If you require dat