Dlete rows from my excel file which starts from alphabet or ---- this special character

[ROHAN999]

Sir

i am importing a text file into excel

but i want that after importing i can delete those rows which starts from alhabet or "-" special character from my excel file

i want to keep only those rows in my excel which starts from number-that why i am doing all this

kindly suggest me a vba or macro

[ROHAN999]

In a row the vba should search ,if the first hit is number then dont delete otherwise delete ENTIRE ROW

this should be the algorthm

kindly guide

[JOHN H. DAVIS]

Does this help? It assumes the words are in Column A.

Please Login or Register  to view this content.

[ROHAN999]

(BLANK rows also need to be deleted)


sir

plz modify a bit more

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[ROHAN999]

Please Login or Register  to view this content.

THIS IS THE CODE I AM USING RIGHT NOW

PLZ HELP ME IN MODIFYNG IT SO THAT FROM THE TEXT DATA ONLY THOSE ROWS NEED TO BE IMPORTED WHICH ARE STARTING WITH NUMBERS(BLANK ROWS ALSO NEED NOT BE THERE)

KINDLY HELP

OR AFTER IMPORT MY THIS VBA DELETE THE UNWANTED ROWS THAT COULD BE AN ALTERNATE SOLUTION

PLZ HELP IN EITHER WAYS

I WILL BE THANKFUL

[ROHAN999]

Any help will be appreciated...

[ROHAN999]

Plz help.....i will be thankful