How to use "if" logic in a macro

[tdf2437]

I would like to include some language in a macro that is similar to an "if" statement

I'm using two sheets in the workbook. I already have the macro accomplishing some functions, but I also want the macro to do:

at this point in the macro, the active cell is in Sheet2, cell B4
if Sheet1, cell A50, is not blank; then =Sheet1!A50. So if cell B4 does get this formula, move on to the next command within the macro.
however if Sheet1, cell A50, is blank; do not enter a formula into B4 and move on to the next command within the macro.

thank you

[mehmetcik]

Please Login or Register  to view this content.

[mjr veverka]

or more "complicated":

Please Login or Register  to view this content.

[Winon]

Hello tdf2437,

You could consider this approach as well;

Please Login or Register  to view this content.

Here we are using the Sheet index Number instead of the Sheet Name, because if the Sheet Name is Changed the Code will fail.

Regards.

[tdf2437]

thank you to all who responded, I appreciate the help very much

[Winon]

You are welcome tdf2437,

Glad we could help!

Regards.

[Winon]

Hello tdf2437,

Thank for adding to my Reputation, I really appreciate it.

Regards.

[tdf2437]

I would like to add a second question that ties directly with mehmetcik's response to my question:

The macro is using all of the same logic as originally written, but instead of using =sheets("Sheet1").range("A58").value
how would I would go about in having this actual formula post in B4 =a1+a2+a3

Thank you

[mehmetcik]

Select the developer tab

Select Record Macro, remember the macro name.

Type =a1+a2+a3 into cell B4

Select Stop Recorder


Select macros, select your macro and then click on edit.

You should see something like:

Please Login or Register  to view this content.

This can be edited to:

Please Login or Register  to view this content.

[Winon]

Hello tdf2437,

Is this what you want?

Please Login or Register  to view this content.

Please see attached sample Workbook.

Regards.