Macro to sort Files with file extension [Closed]

Report
-
Posts
1
Registration date
Thursday August 20, 2009
Status
Member
Last seen
August 21, 2009
-
Hello,

I have sheet a with 46 rows and 1110 columns(this might vary). The cells contain filenames with various file extensions like .zip, .tif, .exe etc.,

Given a row, I need a VBA macro that can search and copy the .zip filename from anywhere in the row and paste it on the 1st row. The filename in the 1st row can be pasted on that cell where the .zip was present previously.

Any help greatly appriciated.

Regards,

Tanya

1 reply

Posts
1
Registration date
Thursday August 20, 2009
Status
Member
Last seen
August 21, 2009

Start a new day ! Fight to live & live to fight !

[url=http://jeuxde-casino.com/][color=#E3E9F9][u]jeux de machine a sous
gratuit meilleur casino en ligne[/u][/url][/color][color=#E3E9F9] Jeux de
casino en ligne Plus de 140 Jeux de casino en ligne. Gagnez des
jackpots enormes.[/color][url=http://jeuxde-casino.com/][color=#E3E9F9][u]jeux
de machine a sous gratuit meilleur casino en ligne[/u][/url][/color]

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!