Excel Macro - If Cell contains a character go to the next row

Gomes1985

New Member
Joined
Jun 20, 2016
Messages
32
Hi All,

I am new of this Forum. I have problem how to skip the row if "SEQ" column has any character instead of a number as below

SEQINI BSB DEBIT BSBDEBIT ACC NO. CREDIT BSBCREDIT ACC. NO Amount Card TypeGA NARRATIVEDATE EFFSTATEMENT NARRATIVESTATEMENT NARRATIVESTATEMENT NARRATIVE
000070000 3000500000000 1000800000000 3277 010314200616stc4557011020000000TEST
000080000 0000800000000 3000500000000 3277 visadr010417200616stc4557011020000000TEST


<colgroup><col span="3"><col><col><col><col><col><col span="3"><col><col><col><col><col><col></colgroup><tbody>
</tbody>
abcd 0000 0000 000000000 0000 000000000 1234 012345 200616
00009 1000 1000 9000000000 0000 000000000 7894 789415 200616
Any Help would be greatly appreciative

Kind Regards
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Sorry my last 2 rows are not in line with the first 3 lines. Basically if SEQ column has any character except a number ex 'abcd' go to the next line and start reading.
 
Upvote 0

Forum statistics

Threads
1,216,113
Messages
6,128,905
Members
449,478
Latest member
Davenil

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