Re: $$Excel-Macros$$ VBA Comment Box - Copy of

Hi Ashish Thanks for tht. However it is not what I need. It is great for the photo selection and I will use it for that. What I want here is to copy the Comments Box thru to another sheet. Daniels code appears to be exactly what I want but a small error at the moment. If I can get Daniels

Re: $$Excel-Macros$$ VBA Comment Box - Copy of

try this Sub CopyComments() ' code by daniel Dim Rg As Range, C As Comment Dim Sh As Worksheet, x As Range Set Sh = Workbooks(Database.xls).Sheets(Sheet1) With ThisWorkbook.Sheets(Sheet1) For Each Rg In .Range(j12 :j .Range(j65356).End(xlUp).Row) Set x = Sh.Range(J:J).Find(Rg.Value,

Re: $$Excel-Macros$$ Strange Issue with Macro

Good to know. . Thanks, DILIPandey On 7/12/11, hanumant shinde arsfan2...@yahoo.co.in wrote: Hi All, i could resolve the issue. the answer is as below (if anybody wants to know) initially the scope for all the nameranges was WORKBOOK but wen i was increasing the range of namerange scope

$$Excel-Macros$$ Need a book

Hi Group Users, I need your help, I need a book of excel *101 secrets of a microsoft excel addict.* I you have full version of this book please send me. Thnx Karan -- -- Some important links for excel users: 1.

$$Excel-Macros$$ Need a book

Hi Group Users, I need your help, I need a book of excel *101 secrets of a microsoft excel addict.* If you have full version of this book please send me. Thnx Karan -- -- Some important links for excel users: 1.

RE: $$Excel-Macros$$ Need a book

http://www.exceltip.com/download/F1eBookSample.pdf From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of karan 1237 Sent: Tuesday, July 12, 2011 2:32 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need a book Hi Group Users, I need your

Re: $$Excel-Macros$$ Need a book

Thnx for replying yar but it's not full version. Please send another link *--- кαяαηη* On Tue, Jul 12, 2011 at 4:53 PM, Rajan_Verma rajanverma1...@gmail.comwrote: http://www.exceltip.com/download/F1eBookSample.pdf** * * *From:* excel-macros@googlegroups.com [mailto:

$$Excel-Macros$$

Hi Perfects I need help from you, I have one excel sheet with more Data when I want to search data I am using CONTROL+F typing in the control box particular number then selecting same. I need to hide other data except searching shout b on screen. Hope you will give me better tips

Re: $$Excel-Macros$$

Try this Sub Macro5() ' ' Macro5 Macro ' Application.ScreenUpdating = False On Error GoTo Err: Dim cell As Range ss = InputBox(Enter the Value) If ss = Then Exit Sub ActiveSheet.Cells.NumberFormat = ;;; Range(A1).Activate Do Cells.Find(What:=ss, After:=ActiveCell, LookIn:=xlFormulas,

Re: $$Excel-Macros$$

HI AZEEM plz find the attached file, i had used conditional formatting explanation is one the sheet tell me if it helps you. On 12/07/2011, Azeem Quraishi (HAB5) aqurai...@ccc.ae wrote: Hi Perfects I need help from you, I have one excel sheet with more Data when I want to search data I

RE: $$Excel-Macros$$ Convert Txt file into Excel into proper Columns

I did that. See the excel spreadsheet I attached. My question was how can I move over the imported txt file format and into the excel spreadsheet format under the appropriate column headings… I was thinking I did the Text Import Wizard incorrectly… and thought someone here had another way of

RE: $$Excel-Macros$$

Nice -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ankur Sent: Tuesday, July 12, 2011 6:54 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ HI AZEEM plz find the attached file, i had used conditional

Re: $$Excel-Macros$$

*thnks sir *Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Tue, Jul 12, 2011 at 6:59 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Nice -Original Message- From: excel-macros@googlegroups.com

FW: $$Excel-Macros$$

I attached sample file which I am using daily basis to update Mr. Rajan Varma Bellow mentioned Macro I am not able to run properly please can u help me in this Macro how to put the proper condition. Best Regards Syed Azeem Quraishi Engineering Dept. H5-Project P

Re: $$Excel-Macros$$ Need help on String Matching

Thanks Ankur, Rajan, Haseeb and Ashish for helping me.. :) On Tue, Jul 12, 2011 at 5:37 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *=VLOOKUP(*A1*,Sheet1!A:A,1,0)* *Use this* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Anish

$$Excel-Macros$$ Acitive Workbook Name

Dear Friends, Please advise the coding for save as Acitive workbook has worksheet name. E.g. If worksheet name is Holding_002 then the file should be save as Holding_002. Regds Shree -- -- Some important links for

Re: $$Excel-Macros$$ Acitive Workbook Name

Goto the sheet Holding_002 and use the following Code. it will save the ActiveWorkbook with activeSheet name at Defaut save location.. activeworkbook.saveas activeSheet.name On Tue, Jul 12, 2011 at 8:18 PM, SHREE chidurala.sh...@gmail.com wrote: Dear Friends, Please advise the coding for save

Re: $$Excel-Macros$$ Acitive Workbook Name

Thanks Rajan Sir for quick reply in just 3 mins. Regds Shree On Jul 12, 7:51 pm, rajan verma rajanverma1...@gmail.com wrote: Goto the sheet Holding_002 and use the following Code. it will save the ActiveWorkbook with activeSheet name at Defaut save location.. activeworkbook.saveas

$$Excel-Macros$$ Re: months and fraction of a month between two days

Hi Richard, If the dates are present in B10 and C10, use following formula:- =(DAY(EOMONTH(B10,0))-DAY(B10)+1)/DAY(EOMONTH(B10,0))

$$Excel-Macros$$ how to use spellnumber fuction in excel.2010

Hi Groups member, I want if i enter any numaric value in a cell, now i have to convert it into spelling in english. Please suggest i have to make manual work for it every time. -- Regards, Ram Naresh -- -- Some

Re: $$Excel-Macros$$ Convert Txt file into Excel into proper Columns

Just follow few steps below data=import External Data = select the ftxt file option then select the txt file and press alt +d + e (text to colums)delimited and click on other and next other option one box is given just press shift + \ it will show you this | and then next and finish txt file

Re: $$Excel-Macros$$ how to use spellnumber fuction in excel.2010

thanks ranjan it's work fine... On Tue, Jul 12, 2011 at 9:21 PM, rajan verma rajanverma1...@gmail.comwrote: Use =Inword(YourDigit) after installing attached add ins On Tue, Jul 12, 2011 at 9:10 PM, Ram Naresh Verma rnverma2...@gmail.comwrote: Hi Groups member, I want if i enter any

Re: $$Excel-Macros$$ months and fraction of a month between two days

Function MonthFrac(StartDate As Date, EndDate As Date) As Single *'= siti Vi / Jakarta 12 July 2011* Dim YY1 As Integer, MM1 As Integer, DD1 As Integer Dim YY2 As Integer, MM2 As Integer, DD2 As Integer Dim MM As Integer, DD As Integer, EndMonthDays As Integer YY1 =

Re: $$Excel-Macros$$ months and fraction of a month between two days

Try this Function to get Desire OutPut Function GetDiff(Startdate As Range, EndDate As Range) As Single GetDiff = DateDiff(m, CDate(Startdate), CDate(EndDate)) + (Day(CDate(EndDate)) / Day(DateSerial(Year(CDate(EndDate)), Month(CDate(EndDate)) + 1, 0))) End Function On Tue, Jul 12, 2011 at

Re: $$Excel-Macros$$ Binary Combinations Using VBA

Hi, This works really well, except it shows an error at: Range(A Range(A65536).End(xlUp).Row + 1).Resize(ActiveSheet.UsedRange.Rows.Count, ActiveSheet.Columns.Count).ClearContents C = ActiveSheet.UsedRange.Columns.Count R = ActiveSheet.UsedRange.Rows.Count

RE: $$Excel-Macros$$ Convert Txt file into Excel into proper Columns

Thanks it helped From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Tuesday, July 12, 2011 7:56 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Convert Txt file into Excel into proper Columns check the attachment

Re: $$Excel-Macros$$ months and fraction of a month between two days

Hi, Fractions of a month are a bit subjective. Fractions of WHICH month, needs to be decided. Fractions of a 28-day month? 29- 30- or 31- day month? Or maybe a standardized 30.4375-day month? Regards - Dave On 12/07/2011, at 8:55 PM, Richard richard.m...@gmail.com wrote: Hi All, I would

Re: $$Excel-Macros$$ ***Macros Code for rename active sheet***

Dear friends, you can use this code as well ActiveSheet.Name = Application.WorksheetFunction.Text(Now, dd-) regards Sudheer (sudheer...@gmail.com On Mon, Jul 11, 2011 at 7:21 PM, Prabhu prabhugate...@gmail.com wrote: Thanks Ashish, Regards, Prabhu --

$$Excel-Macros$$ Using VBA Macros to control GPIB equipment

National Instruments website has an example spreadsheet that can accomplish this: http://zone.ni.com/devzone/cda/epd/p/id/798 I've expanded the ni-488.2_in_excel.xls spreadsheet from this website to do just about anything you want to with test equipment over GPIB. -Brian --

Re: $$Excel-Macros$$ Copy and paste between sheets problem?

Thank you for the hint. I got it figured out now. Andrew On Jul 10, 9:19 pm, Rajan_Verma rajanverma1...@gmail.com wrote: Use Application.CutCopyMode=False after Copy the Range Please attach your file. -Original Message- From: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ months and fraction of a month between two days

how about: fraction to the LASTMONT ( days in EndDate Month) On Wed, Jul 13, 2011 at 9:28 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, Fractions of a month are a bit subjective. Fractions of WHICH month, needs to be decided. Fractions of a 28-day month? 29- 30- or 31- day month?