Please Check my VBA code

[Meko1]

Hello
I would like a advanced VBA user to see my code pls.

I am just making simple if functions in VBA, but since I am new it is not that easy to me.

So the code is following:


If Sheet10.Range("N2").Value > 0 Then ActiveSheet.Range("B22").Value = 0.5
Else: Range("B22").Value = 0

If Sheet10.Range("M2").Value > 0 Then ActiveSheet.Range("B23").Value = 0.1
Else: Range("B23").Value = 0

If Sheet10.Range("L2").Value > 0 Then ActiveSheet.Range("B25").Value = 0.1
Else: Range("B25").Value = 0

If Sheet10.Range("J2").Value > 0 Then ActiveSheet.Range("B24").Value = 0.1
Else: Range("B24").Value = 0

If Sheet10.Range("K2").Value > 0 Then ActiveSheet.Range("B24").Value = 0.1
Else: Range("B24").Value = 0


So, am I correct, and while using else I want it to leave that cell with value 0.

And I have another issue, in other problem, while moving data from one sheet cells to another sheet cells, and those cells already have data inside, how to ask VBA if there is data go 1cell down and fill from there.

Tanks in advance.
Hope for your quick response.

 

[My Aswer Is This]

In my script you should see:
For i = 2 To Sheets.Count

This means it looks in all sheets except for sheet1 which should be named "Master"
The script does not care about sheet names

 

[Meko1]

Can you explain to me what i stands for in the script I do not understand it, and so if it is looking for all the sheets in the workbook can we ask it to start looking from Sheet10.
Thanks, I know I am asking a lot, and if I maid you uncomfortable and bored I am sorry for that

 

[Meko1]

funny you answered before I could even ask question

 

[Meko1]

and is there a way to change the sheet order, for example can I somehow modify for Sheet10 to be Sheet3 for example...

 

[My Aswer Is This]

Can you explain to me what i stands for in the script I do not understand it, and so if it is looking for all the sheets in the workbook can we ask it to start looking from Sheet10.
Thanks, I know I am asking a lot, and if I maid you uncomfortable and bored I am sorry for that

Yes we can start looking in sheet 10
change
For i = 2 To Sheets.Count
To:
For i = 10 To Sheets.Count

 

[My Aswer Is This]

I believe you still keep thinking I'm looking at sheet names.
The script is not looking at sheet names Like Sheet3

The only name it cares about is the sheet named "Master"

 

[Meko1]

Yes I understand, since I had not master I deleted ward master from the code and just typed Sheet1. and I did it on all the lines, never even thought just to change the name, give me few moments, I think I am close to it

 

[Meko1]

and when I type Sheet3 or Sheet1, I am referring to the sheets they have count in the VBA on the left side, names are in parenthesis

 

[Meko1]

Ok now weird thing is happening, macro is running but it does not transfer any data to Master sheet

 

[My Aswer Is This]

I'm not sure what your question is:
Your modifying the script and then saying it does not work.
Is there a problem with naming the first sheet in your workbook to Master

Why not try it and if it works and you just don't like the name Master Modify the script later.