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 cod
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").Fi
Good to know. .
Thanks,
DILIPandey
On 7/12/11, hanumant shinde 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 for few namerange
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. Fo
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. F
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
=VLOOKUP("*"&A1&"*",Sheet1!A:A,1,0)
Use this
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anish Shrivastava
Sent: Monday, July 11, 2011 3:43 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help on String Matching
Hello Experts,
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 wrote:
> http://www.exceltip.com/download/F1eBookSample.pdf**
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Beha
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
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
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) wrote:
> Hi Perfects
>
>
>
> I need help from you, I have one excel sheet with more Data when I want
> to search data I am using "C
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 doin
Hi All,
I would appreciate a vba function that will calculation the number of months
and fraction of a month between 2 dates.
i.e.
January 1, 2011 to February 14, 2011 would be 1.5 months
January 1, 2011 to February 15, 2011 would be 1.5335714
January 1, 2011 to March 15, 2011 would be 2.483871
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 formatting
*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 wrote:
> Nice
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups
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 Befo
Thanks Ankur, Rajan, Haseeb and Ashish for helping me.. :)
On Tue, Jul 12, 2011 at 5:37 PM, Rajan_Verma wrote:
> *=VLOOKUP("*"&A1&"*",Sheet1!A:A,1,0)*
>
> *Use this*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Anish Shrivastava
> *Se
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
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 wrote:
> Dear Friends,
>
> Please advise the coding for save as Acitive workbook
Thanks Rajan Sir for quick reply in just 3 mins.
Regds
Shree
On Jul 12, 7:51 pm, rajan verma 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 activeSheet.name
>
>
>
>
>
>
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))
+IF(ISERROR(DATEDIF(DATE(YEAR(B10),MONTH(B10)+1,DAY(B10)),DATE(YEAR(C10),MONTH(C10)-1,DAY(C10)),"m")),-1,DATEDIF(DATE(YEAR(B10),MONTH(B10)+1,DAY(B10)),DATE(YEAR(C10),
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 imp
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 wil
thanks ranjan
it's work fine...
On Tue, Jul 12, 2011 at 9:21 PM, rajan verma wrote:
> Use =Inword(YourDigit) after installing attached add ins
>
>
> On Tue, Jul 12, 2011 at 9:10 PM, Ram Naresh Verma
> wrote:
>
>> Hi Groups member,
>>
>> I want if i enter any numaric value in a cell, now i have t
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 = Year(StartD
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 11:
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.C
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 see
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 wrote:
> Hi All,
> I would appreciate a vba function
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 wrote:
> Thanks Ashish,
>
> Regards,
>
> Prabhu
>
> --
>
> ---
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
--
--
Below mentioned is an opening of life time with one of the most esteemed
management consulting firm. If currently you are aiming for a job change
please do read the below e-mail very carefully.
*About The Client: -*
McKinsey is a preeminent management consulting firm that helps leading
compani
Please *send your resume* either to *ashishjain @openexcel.com* or *
h...@openexcel.com*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailyti
Thank you for the hint.
I got it figured out now.
Andrew
On Jul 10, 9:19 pm, "Rajan_Verma" wrote:
> Use Application.CutCopyMode=False after Copy the Range
> Please attach your file.
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups
how about:
fraction to the LASTMONT ( days in EndDate Month)
On Wed, Jul 13, 2011 at 9:28 AM, Dave Bonallack
wrote:
> 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 standardize
Dear Members
I want to know about the new advanced excel formulas and addins. Please send
me some useful links or files by which i can know about that by downloading
all that.Specially if those links also having finance related funcion or
addins that will great for me also.
Thanking you
Regard
Thank you all...
On Mon, Jul 11, 2011 at 1:37 PM, ankur wrote:
> *hi kalyan
> as per ur requirementfind the solution...tell me if it helps u ..
>
> *Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
>
Hi,
Can anyone suggest which book will be the best ot learn Charts (Like Bullet
Chart and Doughnut chart with Indication). If anyone have ebook please post
it. Thanks!.
Regards,
Chandra Shekar B
--
--
Some importan
38 matches
Mail list logo