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]

I'm not sure what marked as solution means.
Does the script I provided work?
Most users here will make a written comment if the script worked.

 

[Meko1]

Hey,
First thank you both I am trying to figure out the code, a bit difficult, something is going wrong.

It is 1st sheet but it was giving me an error now. After I removed the master name and replaced it with just Sheet1, its working but placing random numbers. I mean it starts count not from my active sheet but 2 sheets before.

Regarding your offer @MY Answer Is This, I will pass on it atm, since I am a student as well and time is quite limited for me.

 

[Meko1]

I am trying to figure out how it works, but I am not very familiar with the most of it so let me try if I can improve it anyhow

 

[My Aswer Is This]

Hey,
First thank you both I am trying to figure out the code, a bit difficult, something is going wrong.

It is 1st sheet but it was giving me an error now. After I removed the master name and replaced it with just Sheet1, its working but placing random numbers. I mean it starts count not from my active sheet but 2 sheets before.

Regarding your offer @MY Answer Is This, I will pass on it atm, since I am a student as well and time is quite limited for me.

Ok Just trying to help. I assume you mean you do not want my suggestion.

 

[My Aswer Is This]

My script wants you to have a sheet named "Master" which should be the first sheet in your workbook
Put your button with the script on the sheet named Master and all results will be shown in sheet named Master.
It's always best to use names when referring to the master sheet.
All the other sheets do not need to have a special name the script just looks at the sheet no matter the name.

 

[Meko1]

Yes, I understand your suggestion, it looks very tempting, but since the method, they are using at this moment is not fully functional, and writing one whole script, even though it will make the job even either, I think the little mistakes can just cause the loos in all the hard work if we did it. So even in my script/code as I like to call it, I have them all divided into segments since, if school decides to add or delete anything new it will be easier to cerrect

 

[My Aswer Is This]

Yes, I understand your suggestion, it looks very tempting, but since the method, they are using at this moment is not fully functional, and writing one whole script, even though it will make the job even either, I think the little mistakes can just cause the loos in all the hard work if we did it. So even in my script/code as I like to call it, I have them all divided into segments since, if school decides to add or delete anything new it will be easier to cerrect

OK.
Do not understand:
and writing one whole script?
I just wrote you the script.
You should not need any other scripts

 

[Meko1]

Yes I understand how the Sheet name works, problem is, the file is not only master sheet and students sheets, it like this: Master sheet, Bank statement sheet, Contract, blank sheet... and afterwards student sheets start, since I am using my ActiveSheet command for several macros I want to stand on ActiveSheet and to transfer the data into Master/ Sheet1.

 

[Meko1]

At the same time sheet4,7 and 8 does not even exist since I had them deleted

 

[My Aswer Is This]

At the same time sheet4,7 and 8 does not even exist since I had them deleted

The script looks at all the sheets in your workbook at the time the script is run.
It's appears as if you never tried the script. But if your happy with the way your doing it that's great. I'm not sure what I can do to help you