VBA IF statement

[itwas45and51]

Hello, I am attempting to insert an IF statement into an existing macro, such that if the last column in a specific worksheet is column G, then stop the routine. If not, then continue. I'm still a novice with VBA code and am missing something simple. Here is the code I am attempting to insert. Thank you for any help!

Please Login or Register  to view this content.

[mikerickson]

Try

Please Login or Register  to view this content.

[Trebor76]

Hi there,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

[itwas45and51]

Hi Robert, I need the routine to be specific to column G, so I modified the code to =7. However, that did not work. I used <=7, and it worked the first time, but subsequent runs did not work. Here's some additional backgound ... the first part of the code copies values to "DATA COPY" worksheet. That data is summarized in another worksheet "Scorecard", and uses formulas to look up the data. The first time that data is copied to "DATA COPY", it will always copy to column G. Subsequent data will be copied to column H and so on. The first summary in "Scorecard" is also in column G, but the formulas already exist. The last section of the code copies the formulas to the next column (e.g., from column G to column H). What I am trying to avoid is copying the formulas the first time. Using =7 copies all the time, using <=7 never copies. Here's the full code. Any suggestions?

Please Login or Register  to view this content.

[Trebor76]

If the following doesn't work please attach a workbook (devoid of sensitive data) with notes of what you're trying to achieve:

Please Login or Register  to view this content.

Robert

[Trebor76]

If the following doesn't work please attach a workbook (devoid of sensitive data) with notes of what you're trying to achieve:

Please Login or Register  to view this content.

Robert

[itwas45and51]

Added Exit Sub prior to End If and it worked wonderfully! Thank you for your help and patience!

[Trebor76]

You're welcome

Thanks also for marking the thread as solved and for adding to my rep