Hi Tanzeem,
What u have given the site name, in that we are getting network error. When we
have checked through Google engine we got it, it has downloaded as torrent file.
Now could u tell me, how to install this, i mean how to open torent file.
FYI i have searched in web, we got some bittorre
If any one could sugested me thanks a lots
(bcoz of if tanzeem had left this group)
Regards
Naveen Kumar M N
Transport Supervisor(HP)
91-08-99728 10886
Email :naveenkumarmn...@yahoo.com
Best Wishes-Karunaada Kuvara
--- On Wed, 1/14/09, Naveen wrote:
From: Naveen
You have not mentioned any bracket, coma etc anywhere in the code...
Like
if(sheet1.cells(3,39))="4" then
you need to write the code in correct format first.
To lock the cell you can have the following code
Cells.Select
Selection.Locked = True
Regards,
Tariq Kamal
www.gate2quality.com
On
Hi Ken,
I can't find the Paste line in your code, but I'm sure it's there somewhere.
Instead of paste, use Paste Special, then values. Then the formatting of the
destination cells will survive.
You can get the syntax by using the macro recorder.
Regards - Dave.
__
Not sure how much help you're looking for.
You said that you "don't know the VB language".
Does that mean that you don't know how to use the VB editor?
do you know how to write a macro?
Can you create your command button and assign a macro?
What version of Excel are you using? It won't matter for
the Paste function copies the entire cell (or cells)
including all formatting.
try recording a macro to PasteSpecial Values:
Selection.PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, _
SkipBlanks:=False, _
Transpose:=False
You can change it to
Hi again group,
I can't find a way to preserve the condtional formatting on a
worksheet when rows are pasted from another sheet. The condtional
formatting from the sheet that is being searched transfers to the
destination sheet and overwrites or completely removes the condtional
formatting rule
Tom
I dont see an 'attach file' option when I reply..???
On Jan 8, 1:48 pm, "Tom Jeffries" wrote:
> When you reply to a message you will see an "Attach File" link beneath the To:
> box.. Click it. You will then see a Choose File button. Click it. Select
> file to be attached. Click Open. T
Hi all,
I have a worksheet that contains a column of 8 dropdown lists (combo-
boxes) from a range in a different sheet. I have the (numerical)
results of each selection set up to display in a hidden column. In
another cell, I used the COUNTIF function to count the results of all
selections >0 (0=
Hi again group,
I can't find a way to preserve the condtional formatting on a
worksheet when rows are pasted from another sheet. The condtional
formatting from the sheet that is being searched transfers to the
destination sheet and overwrites or completely removes the condtional
formatting rule
10 matches
Mail list logo
