Loop untill Empty

S

sharafoly

New Member
Joined
Oct 2, 2010
Messages
7
Hi...

All I need is a simple code to write at the end of my current code.
>>>><<<<

Check if cell B2 is empty then stop all macros and codes, if not:-
Application.Run "'European Ceramics 2.xlsm'!Macro3"
Thank you..
 
Sort by date Sort by votes
Something like this?
Code: 
If IsEmpty(Range("B2")) Then
    Exit Sub
Else
    'Other code here
End If
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Solved
Assistance with Sending an Email on a Loop
Replies
4
Views
195
Tommy1115
T
MikeMcCollister
  • Solved
How do I sum rows until first blank row?
Replies
5
Views
89
Fluff
Fluff
I
  • Solved
If a cell has specific text & another cell is empty then add value to that empty cell
Replies
6
Views
281
ipbr21054
I
K
  • Solved
combobox values with validation from adjacent cell
Replies
4
Views
237
kampog
K
A
  • Question Question
VBA to repeat recording data
Replies
1
Views
132
Joe4
Joe4

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top