>
> Paul thank you!
>
Not only did the code do the trick but you were extremely helpful in
explaining the logic behind the code. I appreciate your help!
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this fo
OK, the syntax:
if Range("rangename2").Value = 16
fixed everything. Thank you very much Paul.
Dean
On Monday, June 16, 2014 11:43:06 AM UTC-7, dea...@aol.com wrote:
>
> I've been gone for a long while and forgot some of what little I knew
> about proper VBA syntax. This is an easy one, I'm s
I'm not sure what you are asking about the range names. I assigned each to
a group of cells in a row, cells that detect if the column is empty or not.
The macro, which hides columns that are empty, works fine as long as the
value is not 16. In that case, no columns are empty and the formula y
--
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: deanalt via MS EXCEL AND VBA MACROS
>To: exce
Thanks Paul, but I tried this, I think, before posting. Even though
rangename2 is 16, it is getting hung up on one of the steps that I expect
it to take only if it is less than 16. Perhaps I need to declare that the
rangenames are integers within the VBA macro, or something like that - do
you
implement what you just wrote".
>
> What I wrote was a stand-alone "sub".
> Normally, I would put it in a Module.
> Then, to run it from your button, change the click event to:
>
> Private Sub CommandButton1_Click()
> Btn_Copy
> End Sub
>
> What you
ent to:
Private Sub CommandButton1_Click()
Btn_Copy
End Sub
What you did by recording the macro and modifying it is a VERY good start.
But to speed things up and to keep the screen from jumping back and forth...
THAT's what makes the macros look GOOD
hope this helps.
Paul
- O
Hi Paul, Thanks so much! It's astonishing to me that this constitutes
a "quick" macro for you!
I guess to answer your questions... I'm using Excel 2007, and
shamefully, I really don't know how to write macros... I did come up
with the script below though it's in conflict with your warning
again
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
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
10 matches
Mail list logo
