Can you post an example showing how the format of the cell values (you
mention that the cell value can be a workbook and a cell: does it show
the path correctly for the workbook? Unless you know the correct path
for the workbook, or they're all in the same path/folder, then it
would be impossible t
easy piece...
Sub Kleur()
Dim oCel
For Each oCel In Selection
If oCel.Interior.ColorIndex = 36 Or oCel.Interior.ColorIndex = 38
Then
oCel.Value = "N"
End If
Next
End Sub
enjoy ...
Paul Willekens
--
--
So
Thanks for your suggestions/help. I checked to make sure that all of
the loops use "Exit For" when appropriate. I am using Excel 2007 which
*could* be causing some of the slowdown, but Excel only really comes
in at the end for result output, it could explain why my speed tests
are so slow (I've bee
Good Morning all,
I want to create a macro that can generate purchase order number
automatically after the last saving.
Thanks for your help
Colvert
Port-au-Prince,Haiti
--
--
Some important links for excel users:
1.
Hello,
I am able to use these functions in the worksheet itself, but not able
to use them in a VBA macro in the same. I get an error that Object
doesn't support this property or method. This method, however, seems
to work on Excel2007. Does Excel2003 not support using this from VBA ?
Is there any
A link to a collection of videos and tutorials on MS excel:Data mining
Add-in.
Tutorials:http://www.dataminingtools.net/browsetutorials.php?
tag=msexcel
Videos: http://www.dataminingtools.net/videos.php?id=11
Follow DataminingTools at:
Twitter:
http://twitter.com/DataMiningTools
Blog:
http://dat
sub a()
selection.hyperlinks.delete
end sub
On Mon, Mar 22, 2010 at 10:22 PM, Sandeep Kumar Maurya <
sandymau...@gmail.com> wrote:
> Hi,
>
> write 1 in a blank cell and then copy it and use multiply option in 'paste
> special'.
> It also put 0 in blank selected cells.
>
> Regards
> Sandeep
>
Hi,
write 1 in a blank cell and then copy it and use multiply option in 'paste
special'.
It also put 0 in blank selected cells.
Regards
Sandeep
On Mon, Mar 22, 2010 at 9:13 PM, Nani Ram <06n...@gmail.com> wrote:
> Hi Members,
>
> i have huge data with hyperlinks.
> Is there any shortcut key or
Hi Members,
i have huge data with hyperlinks.
Is there any shortcut key or formula to remove all hyperlinks at once.
Thanks,
Naniram
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tri
I am wondering if there is a way to use conditional formatting for
cells that have color. For example: I select a range of cells in a
row...I want to say, if there is a cell in this grouping that is red
or yellow, place a "N" in this cell. can this be done using 2003?
Thank you in advance.
--
That was GOLD, Chris! Thanks! The scripting object evaluates user code
input and avoids BOTH problems:
1. The really weird problem (all other user functions outputting
#NAME? after any code-writing function is entered) is gone - users can
specify code in some cell that is in turn specified as the
Dear All Experts Help Me,
Please Check the Attachment.
I have bigcardtext But he not Work Properley, When we convert the Number
For Example 600 he Convert the Amount the in Million
Please help me i want to convert the this amount in Rupees Sixty Lac.
--
Thanks For Mail.
--
--
Sorry, Plz read as
Is it possible to integrate MS Outlook 2007 and MS Excel 2007.
On Mon, Mar 22, 2010 at 12:39 PM, ~ Z A H E E R ~ wrote:
> Dear Members,
>
> Is it possible to integrate MS Office 2007 and MS Excel 2007.
>
> For Eg.
> I have 1 excel file contains Employee ID, Employee Name, CI
The problem is then I need a create hyperlink manually..
Then I need to create hundreds hyperlink..
Also, everytime I click the cell, it takes me to the reference cell, which I
don't want to. I want to go to the reference cell when I want to.
That's why I don't think Hyperlink is a solution.
Du
Heya,
Thanks for the reply!
At the moment the file is a bit too large to attach.
The dates I'm trying to match are in column C of the Access Data
sheet, which are checked with dates on the Front Page sheet (fortnight
range) and a number is looked up from these and placed into column H
of the Acc
Excel Gurus
I am in search of a Excel Template, which simulates and gives user a "To do"
List kind of feelings.
Main details I wish to have is,
1. Worksheet -which lists All tasks to do
2. By running a Macro - I can derive list of Task for certain period
(possible with 2 Input fields and filter d
-- Forwarded message --
From: anil panchal
Date: Mon, Mar 22, 2010 at 3:27 PM
Subject: Hi Please Help ME
To: excel-macros@googlegroups.com
Hi All
A NB MTRL NB Width Extra NB Height Extra A NB MTRL Extra CNB Width CNB
Height A CNB MTRL sum OF SB sum OF GB 0 0 0 0 0 0 48 72 24 S
Hi All
A NB MTRL NB Width Extra NB Height Extra A NB MTRL Extra CNB Width CNB
Height A CNB MTRL sum OF SB sum OF GB 0 0 0 0 0 0 48 72 24 SB
10.22 GB 0 0 0 0 72 20 10 SB
20.236111 GB 0 0 0 0 64 30 13.33 SB
23.291667 GB 0 0 0 0 130 35 31.597222 SB
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0
Dear Members,
Is it possible to integrate MS Office 2007 and MS Excel 2007.
For Eg.
I have 1 excel file contains Employee ID, Employee Name, CID #, CID Expiry
date, Passport #, Passport Expiry date, email
My requirement :
Whenever any employees CID or Passport is near to expiry date, outlook wi
Dear Mark
I think you can do it by just using a Hyperlink. No need for macros. Please
see the attached file
Yahya
On Mon, Mar 22, 2010 at 2:37 AM, Markkim wrote:
> Hi
>
> I am wondering if anyone can help me creating a macro for the
> following..
> Get a reference from the selected cell and
Thanks,
Its a best VBA Group.
i got the best thing here which i seach many times in net, like un-
protech sheet & un-protect VBA code.
this is best thing 4 me.
i am working as a MIS exective.
i need vba 4 my daily work. can any one give me vba tutorials of vba
which cover all the part like ho
21 matches
Mail list logo
