Select rows with visible data

M

manubd

Joined
Aug 17, 2013
Messages
2
Reaction score
0
Hello,

I have a range with formulas from C1:C100, I'd like to select just the rows that contain visible values, if the formula result is blank doesn't select it, I don't want to perform the autofilter manually so I'd prefer a VBA macro, my intention is to create a txt file to loads it to other program, if the txt file has blank rows the loading process fails.

Can someone help me?:confused:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

select all (including hidden) rows in autofilter region 2
after autofilter/delete rows left not visible 1
Iterate through the autofiltered rows 2
Select first 5 visible rows 2
Copying nothing/everything when an autofilter returns no results? XL2003 1
weird loop problem- extra rows dissapearing 1
Filter and select the upmost rows 2
rows for visible cells 2

Top