Sub removehyperlinks()
Selection.Hyperlinks.Delete
End Sub
or
type 0 in any blank cell
then copy the cell
select the data with hyperlinks
right click ->paste specia -> multiple and click on ok
On Fri, Nov 11, 2011 at 1:01 PM, Anil Saxena wrote:
> Hi All,
> How can we remove the hyperlink
Hi All,
How can we remove the hyperlink only short key not formula.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick atte
Thanks experts. It works
Regards
Smitha
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Friday, November 11, 2011 12:28 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ convert data in time to number without any
c
If you want a numeric result indicating the number of hours, use
=A1*24
(where A1 contains the "time")
And format as General or as a number / number with decimal places.
That will give you 5 instead of 5:00:00 AM, and it will, for example, give
you 5.75 instead of 5:45:00 AM.
If
=hour(a1)
On Fri, Nov 11, 2011 at 11:31 AM, smitha.kumari wrote:
> ** **
>
> Hours of an employee worked is shown as 5:00:00 AM.
>
> ** **
>
> I have to convert it into number 5. Please help.
>
> ** **
>
> Regards
>
> Smitha
>
> ** **
>
> --
> FORUM RULES (934+ members already
Hours of an employee worked is shown as 5:00:00 AM.
I have to convert it into number 5. Please help.
Regards
Smitha
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
I should have been clearer. I meant to suggest they each have their own FILE
and then you have a macro to combine. If all in the same folder its fairly
easy to combine the files, if desired.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Dave
Sent: Thur
That what they have now ...without the macro to combine them and they
have to roll it up by hand.
Can I use the Macro recorder in Excel to do this task?
On Nov 10, 2:15 pm, "dguillett1" wrote:
> Why not give each their own sheet and then you combine with a macro.
>
> Don Guillett
> SalesAid Softw
Why not give each their own sheet and then you combine with a macro.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Dave
Sent: Thursday, November 10, 2011 2:09 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Modify code to lock multiple sheets in
So 2159 should show in cell f2 (all in one cell)
What to do 1 What to do 2 What to do 3 What to do 4 What to do 5
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Urghhh
Sent: Thursday, November 10, 2011 2:07 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macr
I apologize for the lack of clarity. I blame it on being new to macros
still, lol.
The first routine is a:
Private Sub Worksheet_Calculate()
Dim oPic As Picture
Me.Pictures.Visible = False
With Range("B3")
For Each oPic In Me.Pictures
If oPic.Name = .Text Then
oPic.Visibl
“that I need to combine on the Output sheet.”
Samples of correct cells in col F of output sheet?
Don Guillett
SalesAid Software
dguille...@gmail.com
From: dguillett1
Sent: Thursday, November 10, 2011 1:53 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Combine d
Hi,
I have an Excel 2010 Workbook with 17 Worksheets, Sheet1... Sheet17. I
have this workbook shared on the network. Employees open this workbook
and they enter their daily work log into it individual work sheets.
The problem I am having is that "No one knows who did it" syndrome
where either acci
Sorry for the confusion.
The Delete part is solved.
The problem is the Combine part. When I use the Vlookup, it just return one
hit on the Output sheet, but if you look on the "Paste Sheet 2" the first
customer (with search criteria 2159) gives 5 hits (order lines in our
system). What I need i
Confusing to me. The easiest way to delete the rows with 1 is to filter and
delete.
Are you saying that for sheet 1 and sheet 2 you want to delete the rows with 1
in col c and then combine?
If so, why not combine and then run a filter delete on the combined sheet. Do
you need to keep the source
Please after copy, paste special it in un filtered data...(Use shortcut alt d f
s and then alt e s v tick @ skip blank)
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: vijayajith VA
Sender: excel-macros@googlegroups.com
Date: Thu, 10 Nov 2011 19:41:37
T
1.Try to search all the temp files.
2.Close and reopen the mail, when the mail pop-up says Yes or No to Save, say
Yes.
3.Search for recent files.
Sent on my BlackBerryŽ from Vodafone
Thanks & Regards.
Kiran
-Original Message-
From: "Amit Desai (MERU)"
Sender: excel-macros@googlegroups
Dear All,
Although this is not related to excel.. I am asking this to you all.. Since
this is very important for me..
I was working on the file (which was an attachment to the email). I hat ve
opened mail & have started working on ppt file. Please help me in case if you
know how to recover tha
The Worksheet change routine is automatically triggered when there is a
change (change in value/modification of value etc) in 1 or more cells
within THAT sheet. So you don't really CALL it, it GETS called, in other
words, TRIGGERED.
For the first routine, the context is not clear enough to judge w
By the way, the code to Zoom the window is
ActiveWindow.Zoom= 120
which means 120%
Regards,
Sam
On Thu, Nov 10, 2011 at 10:54 PM, Sam Mathai Chacko wrote:
> You CAN increase the font size if it is an Activex Control. Form Controls
> like mentioned earlier, don't allow font size increase or decr
You CAN increase the font size if it is an Activex Control. Form Controls
like mentioned earlier, don't allow font size increase or decrease.
Regards,
Sam
On Thu, Nov 10, 2011 at 9:50 PM, Mahreen Ellahi wrote:
> Nop didnt get the desired result, anyways m making a new sheet with 100%
> zoom and
Two options try
If Not IsEmpty(Range("A1")) Then
Range("B5").Value = 8
Else
Exit Sub
End If
*OR*
If Len(Trim(Range("A1"))) Then
Range("B5").Value = 8
Else
Exit Sub
End If
Regards
Sam Mathai Chacko
On Thu, Nov 10, 2011 at 10:13 PM, dg
Hi Seba, You are missing a small thing.. I have made the required correction in
your code. Sub testPogoja()
If IsEmpty(Range("A1")) Then
Exit Sub
Else
Range("B5").Value = 8
End If
End Sub
Best Regards,Kaushal Kumar
> Date: Thu, 10 Nov 2011 07:48:10 -0800
> Subject: $$Excel-Macros$$ excel vba If
Not sure why you don't want a vlookup. Suggest using that, or using a
macro, given that all cells are the same order.
Sub GetMissingData()
Dim lngLoop As Long
For lngLoop = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If IsEmpty(Cells(lngLoop, 2)) Then
Cells(lngLoo
You might want to give an example by attaching a file. How does one know
what is a designated cell?
Sam
On Thu, Nov 10, 2011 at 11:41 AM, smitha.kumari wrote:
> ** **
>
> If name in a cell is Simon in a work sheet 2 then the designation already
> allotted for Simon in worksheet 1 should appear
Copy values to an UN filtered destination.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Thursday, November 10, 2011 8:11 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help me
hi
I have tried using pastespecial but its working
its copy
you forgot RANGE but to make sure try
If len(application.trim(range("A1")))<1 Then
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Seba
Sent: Thursday, November 10, 2011 9:48 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ excel vba If IsEmpty(Ran
Nop didnt get the desired result, anyways m making a new sheet with 100%
zoom and its working thanks
Mahreen
On Thu, Nov 10, 2011 at 7:49 PM, wrote:
> For example, with Data Validation cells in column D:
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Target.Count > 1 Then E
I am new to macros. I tried searching the internet for the answer but
the limited experience didn't quite help me find my answer. I hope you
guys can figure it out.
I have 2 sub routines. 1 that pulls a photo and another that hides
rows based on a value from cell B3. I tried to the Call option but
Dear Kiran,
Use "=upper(cell reference)"
Sent from my iPhone
On 10-Nov-2011, at 9:00 PM, ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥
wrote:
> Hi
>
> Anybody can help me out
> how to make small letter to capital letter in Ms excel
>
> V.Kiran
>
>
> --
> FORUM RULES (934+ members already
try this...
If range("A1").value = " " Then
Exit Sub
Else
Range("B5").Value = 8
End If
End Sub
regards,
Mrinal
On Thu, Nov 10, 2011 at 9:18 PM, Seba wrote:
> Hi,
>
> I am testing this fairly simple code for some other purposes but I
> always get the value 8 regardless of value in A1:
>
> -
Hi,
I am testing this fairly simple code for some other purposes but I
always get the value 8 regardless of value in A1:
Sub testPogoja()
If IsEmpty("A1") Then
Exit Sub
Else
Range("B5").Value = 8
End If
End Sub
-
Sorry Kiran it sud be upper(text)
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: .•:*¨¨*:•. .•:V.Kiran Kumar :•. .•:*
¨¨*:•. vadnalaki...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 10 Nov 2011 17:30:20
To:
Reply-To: excel-macr
Use funtion Lower(text)
Or
Proper (text)
Sandeep Chhajer
Sent on my BlackBerry® from Vodafone
-Original Message-
From: .•:*¨¨*:•. .•:V.Kiran Kumar :•. .•:*
¨¨*:•. vadnalaki...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 10 Nov 2011 17:30:20
To:
Reply-To: exc
Hi
Anybody can help me out
how to make small letter to capital letter in Ms excel
V.Kiran
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
Hi Smitha,
Try below formula
=RIGHT(A1,LEN(A1)-FIND(":",A1))
Thanks
Mukesh
- Original Message -
From: smitha.kumari
To: excel-macros@googlegroups.com
Sent: Thursday, November 10, 2011 11:32 AM
Subject: RE: $$Excel-Macros$$ remove a certain text from every sentence
The re
For example, with Data Validation cells in column D:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column = 4 Then
Target.Columns.ColumnWidth = 20
Else
Columns(4).ColumnWidth = 5
End If
End Sub
To add this code to the worksheet:
Right-cli
hi
I have tried using pastespecial its NOT WORKING
its copying only two cells
can you help me please ?
Pleas find the attachment
Thank you
On Thu, Nov 10, 2011 at 7:41 PM, vijayajith VA wrote:
>
> hi
>
> I have tried using pastespecial but its not working
>
> its copying only two cells
>
>
Any code?
On Thu, Nov 10, 2011 at 3:55 PM, wrote:
> Well u can use the code mentioned in the link to make it zoom a bit
>
> On , Mahreen Ellahi wrote:
> > Thanks :-(
> >
> >
> >
> > On Thu, Nov 10, 2011 at 3:43 PM, waheedb...@gmail.com> wrote:
> >
> >
> > Hi,
> > Its fixed size you cant cha
hi
I have tried using pastespecial but its working
its copying only two cells
can you help me ?
Pleas find the attachment
Thank you
On Thu, Nov 10, 2011 at 7:01 PM, wrote:
> Copy in a filter mode the desired data then use paste special (alt e s v )
> and select skip blank option.
> Hope ful
Please Copy in a filter mode the desired data. Then select all (alt d f s) and
in desired column use paste special (alt e s v ) and select skip blank option
there.
Hope fully it will solve ur queries.
Sandeep Chhajer.
Sent on my BlackBerryŽ from Vodafone
-Original Message-
From: vijayaj
Copy in a filter mode the desired data then use paste special (alt e s v ) and
select skip blank option.
Hope fully it will solve ur queries.
Sandeep Chhajer.
Sent on my BlackBerryŽ from Vodafone
-Original Message-
From: "dguillett1"
Sender: excel-macros@googlegroups.com
Date: Thu, 10 N
Post your file
Don Guillett
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Thursday, November 10, 2011 6:11 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ help me
HI
I have some datas in tab with coloumns(code and name)
in one more tab with same datas but
Use edit>replace as suggested by Sandeep Chhajer.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: smitha.kumari
Sent: Wednesday, November 09, 2011 11:09 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ remove a certain text from every sentence
Hi,
I want to remove
3) Don't post questions regarding breaking or bypassing any security measure.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: jocky Beta
Sent: Thursday, November 10, 2011 1:15 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Unable to open the password Protected PPT Help
If you are saying that you do NOT have the names in the summary sheet or a list
of all possibilities somewhere then you will need a macro to go thru each
sheet> get the names> make a unique list> then get the hours for each name.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: smitha.
HI
I have some datas in tab with coloumns(code and name)
in one more tab with same datas but some names are missing ..
so i need to filter the and paste the data.
but if i paste the datas it will not paste completely .why
i dont want to use vlookup is thr any shortcuts
Thanks
--
FORUM R
Thanx to all experts to answer me about my solution.
Date: Wed, 9 Nov 2011 21:41:55 +0530
Subject: Re: $$Excel-Macros$$ Rounding Method
From: ms.exl.lear...@gmail.com
To: excel-macros@googlegroups.com
Hi Mothilal,
Yours is the exact and simplified solution.
In fact, I forgot that functio
Well u can use the code mentioned in the link to make it zoom a bit
On , Mahreen Ellahi wrote:
Thanks :-(
On Thu, Nov 10, 2011 at 3:43 PM, waheedb...@gmail.com> wrote:
Hi,
Its fixed size you cant change it.
Plz refer the below link
http://www.contextures.com/xldataval08.html
O
Thanks :-(
On Thu, Nov 10, 2011 at 3:43 PM, wrote:
> Hi,
> Its fixed size you cant change it.
> Plz refer the below link
> http://www.contextures.com/xldataval08.html
>
> On , Mahreen Ellahi wrote:
> > I ve already gone through this link, thanks. But i dont ve a combo box,
> i ve used data vali
Hi,
Its fixed size you cant change it.
Plz refer the below link
http://www.contextures.com/xldataval08.html
On , Mahreen Ellahi wrote:
I ve already gone through this link, thanks. But i dont ve a combo box, i
ve used data validation.
On Thu, Nov 10, 2011 at 3:27 PM, waheedb...@gmail.com>
I ve already gone through this link, thanks. But i dont ve a combo box, i
ve used data validation.
On Thu, Nov 10, 2011 at 3:27 PM, wrote:
> Hi,
> Please refer the link
> http://www.contextures.com/xlDataVal10.html
>
> Regards,
> waheed
> On , Mahreen Ellahi wrote:
> > Can anybody tell me how
Hi,
Please refer the link
http://www.contextures.com/xlDataVal10.html
Regards,
waheed
On , Mahreen Ellahi wrote:
Can anybody tell me how to increase font size in drop down menu like when
a user selects the menu, the options are too small and not visible.
regards
Mahreen
Can anybody tell me how to increase font size in drop down menu like when a
user selects the menu, the options are too small and not visible.
regards
Mahreen
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Here
=VLOOKUP(A1,Sheet3!A:B,*2,0) , 2 is 2nd column, 0 is exact match
*
*
*
*Mothilal.J
*
*
*
*
*
On Thu, Nov 10, 2011 at 1:14 PM, smitha.kumari
wrote:
> Thanks Ashish.
>
> ** **
>
> Please specify why 2 ,0 is used
>
> ** **
>
> =VLOOKUP(A1,Sheet3!A:B,*2,0)*
>
> ** **
>
>
u want to remove entire row i.e a=0 like
On Wed, Nov 9, 2011 at 8:08 PM, Abhijit Mitra wrote:
> Dear all
> Can you help me out how to remove zero from a sheet:
> Example:
>
> A=0
> B=0
> C=0
> D=2
> E=3
> F=56
> G=0
> H=67
> I=9
> J=0
> K=0
>
> I just want to remove zero from start and end (A,B,
[image: image.png]
use the above command
Mothilal.J
On Thu, Nov 10, 2011 at 11:32 AM, smitha.kumari wrote:
> The result should be david and not Technology company
>
> ** **
>
> Regards
>
> Smitha/ Senior Finance Executive
>
> [image: Speridian%20Logo]
>
> World Class Solution
57 matches
Mail list logo
