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

To Whom It May Concern, In VBA please. thanks. On Saturday, April 5, 2014 1:38:03 PM UTC+8, Falina Gan wrote: > > To Whom It May Concern, > > We would like to know if we are creating a column for uppercase, lowercase > and initial case like the image as below: > > >

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

To Whom It May Concern, We would like to know if we are creating a column for uppercase, lowercase and initial case like the image as below: Hope to hear from you soon. Thanks. -- Are you =E

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

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) Then the pattern column is in "A" column. ( refer to your right side ) Hope to hear from you. Thanks

$$Excel-Macros$$ Re: How to identify which is text, integers, date, time in a table?

Thanks Basole, The codes are running well but can I ask from your codes for my understanding as a learner. Could you explain as below:- 1) z = sheet1.Range("a1").Offset(sheet1.Rows.Count - 1, 0).End(xlUp).Row 2) Set cl = .Cells(i, 1) 3) Case IsEmpty(cl) Case InStr(cl.NumberForm

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

Hi Basole, It's working fine now following are the only problems remaining. 1. While creating macro, I have assigned "ctrl+q" shortcut which is not working now 2. How can we save the code as "Add In" or can we add any buttom in existing toolbar ? so I that I can share the same with my co-workers

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

Dear Excel gurus, Every day I have to compare two identical formatted worksheet trial balance. I want macro to compare both the trial balance. Macro should work as below: It will give me an option to choose which two workbook contains (workbook only contains one worksheet containing trial balanc

Re: $$Excel-Macros$$

Below attached my suggestions: 1 - A small application (A-PDF Text Extractor) to convert pdf to txt. 2 - Macro that imports the file (M & M Price list.txt) to excel. https://www.dropbox.com/s/y0xtlhgjbjgy0qb/Files.rar Regards, Basole. 2014-04-04 6:37 GMT-03:00 Neeraj Chauhan : > Dear ,

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

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 data in different column other then this then change offset value as per your requirement inside the loop.

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

Hi, try this: x = Cells(Rows.Count, "A").End(xlUp).Row y = Cells(x, Columns.Count).End(xlToLeft).Column Range("A1:" & Cells(x, y).Address).Select Regards, Basole. 2014-04-04 11:17 GMT-03:00 Suyog Kulkarni : > Hello All, > > I made my first macro code. Kindly review. Now only problem rema

$$Excel-Macros$$ How to identify which is text, integers, date, time in a table?

To Whom It May Concern, May I ask, how to you create a vba to identify whether the text or integer or date or time in a table such as:- Thanks. -- 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 @ htt

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

Hello All, I made my first macro code. Kindly review. Now only problem remain is instead of *Range("A1:I100"), I want excel to choose "last row & last column" which contain text/value.* PL help. Regards, Suyog " Below is my code" *Sub Format()* ' Format Macro ' Keyboard Shortcut: Ctrl+q ' T

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

Hello All, I made my first macro code. Kindly review. Now only problem remain is instead of *Range("A1:I100"), I want excel to choose "last row & last column" which contain text/value.* PL help. Regards, Suyog " Below is my code" *Sub Format()* ' Format Macro ' Keyboard Shortcut: Ctrl+q ' T

$$Excel-Macros$$ Coordinating questions for today's Q&A with the Excel Developers. Let's ask for VBA!

Hello! Today there's a Q&A with the Excel developers in Reddit (Friday, April 4 at 1:00pm PDT/4:00pm EDT on reddit). We don't usually have a chance to give feedback since the Microsoft Connect initiative doesn't contemplate Office, and they won't even take bug reports from users; their attention

Re: $$Excel-Macros$$ Arrow solution

Dear friends any solution? On Thu, Apr 3, 2014 at 12:46 PM, amar takale wrote: > Dear Ganesh > I want Thick arrow like H column in excel. > Regards > > On Thu, Apr 3, 2014 at 12:40 PM, Ganesh N wrote: >> Hi Amar, >> >> Please find the attachment. Let me know it helps you. >> >> Regards, >> Ganes

RE: $$Excel-Macros$$

Dear , Given information sites are not working. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kuldeep Singh Sent: Friday, April 04, 2014 2:31 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ http://www.doc2pdf.net/Excel2PDF/

$$Excel-Macros$$ Re: Question on My Menu !!

Ashish Sir, In My menu -> Select Range Can you please add "Select non-blank" option. Actually I've posted a question on "repetitive formatting" & I'm not getting any reply. If I've that option in My Menu probably I could have asked the same. Attached is the excel which I've shared with group me

Re: $$Excel-Macros$$

http://www.doc2pdf.net/Excel2PDF/ http://www.pdftoexcel.org/ http://www.pdfconverter.com/pdf-to-excel-online-free/ https://www.pdftoexcelonline.com/ On Fri, Apr 4, 2014 at 2:27 PM, Neeraj Chauhan wrote: > > > Dear expert, > > > > I want to convert from PDF to Excel we have some more attachment >