Correct syntax in If Then statement to make 2 things happen if condition met

[coasterman]

This will doubtless turn out to be a typical Noob question but here goes.

I have some code which will tidy up a user input form based on the number of periods selected in F4 but I also want to place the value in G22 into a specified row (obviously not one of those already cleared by the first Then action) without having to duplicate the If statement as a separate line of code.

I've included the code. Ive included the bit that doesnt work in the first If statement just to give an alternative description of what I am trying to achieve. Hope this makes sense

Option Explicit

Please Login or Register  to view this content.

Thanks

[Kyle123]

Please put your code in tags - it makes it easier to read


I'm not really sure what you want to do, but try the following:

Please Login or Register  to view this content.

[coasterman]

That's very cool, and humbling!

If I could beg a second question. I'm trying to do much the same thing with the G22 value into the D column but I get "expected list or separartor or) Bad syntax?

Please Login or Register  to view this content.