Selecting visible cells in a filtered table column

I'm not quite sure why you need a macro for this. If you select the table with rows filtered out, then copy and paste, you will get only the filtered rows.

Ah, OK - your title is misleading, then. What you are asking about is setting the filters via a macro, NOT selecting the visible cells.

You do not have to be defensive: if someone comments on your thread, it is with a view to help. Nobody is asking you to justify why you have posted a thread, but sometimes we need to seek clarification.

EDIT: I see you have reported my post. You said:

I have been questioned why I needed to post a particular question. I do not feel anyone needs to justify why they are posting on the forum especially when they ask a simple specific question they wish to adapt to a greater problem. Not everyone is simple-minded requiring help for every single aspect of problems, some of us identify our weaknesses, highlight the most pertinent information to avoid confusing potential helpers, and omit unnecessary explanations irrelevant to the specific problem.

I did not ask why you posted the question. I asked why you wanted a macro to select and copy-paste visible cells (as per your title). It now seems that is not really what you want help with.

I do not understand why you consider this as an implication that I think you are simple-minded: I do not, nor did I think anything of the sort.

As you wish ...

I cannot remove anyone's ability to report posts. You have so far reported me twice (EDIT: three times now).

I will leave it up to other mods and admins to decide what to do about it, or indeed whether there is anything I need to answer to. For the record: I am not harassing you.

Good luck with your query.

Originally Posted by Crawfy

Not that I feel I need to justify why I have posted a question, but if you must know...I have several columns (3 in this case as written in the original post) I need to run this on each time, and I do it frequently with different data. I know how to add the ability to cut and paste to a macro and all I need help with is selecting filtered data. Hence asking for help on one specific task and using a larger macro to speed up the entire process and avoid manually doing it every time.

It's not justifying why you posted a question, its giving more detail to your question. Often, members think that need 1 thing (eg complex multiple IF's) when they actually need something different (eg a simple vlookup). Lack of knowledge on some excel formulas sometimes results in the OP not really knowing what is available to the. Asking questions gives answerers a better insight into what is really needed.

(and by the way, getting snippy with members is a sure fire way to stop getting answers at all...word quicky spreads in a comunity like this about who is or is not worth the effort of helping...just saying)

Originally Posted by Crawfy

My title is not misleading thank you. Selecting visible cells in a filtered table column suggests setting filters via a macro which is precisely what I asked in my post.....

1. Sorry, but there is nothing in your title that "suggests" you anything via a macro. We are not mind readers, and most of us do not have crystal balls to see what you want.

2. I see nothing rude about Ali's posts, I DO see someone who is trying to help by get more details on what you want, so that a better suggestion can be made.

3. Even I (as Admin) cannot remove your ability to report threads, however, I believe there may be a (programmed) limit to how many times you can report a thread.

4. I have viewed Ali's original version of post, compared to what now shows in post # 4 - the only thing different is the addition of the last 2 limes of text. Nothing else was removed or changed. No other posts were edited.

5. I see no harassment here, only a possible misunderstanding as to why additional information was requested.

I hope this clears this matter up now, if not, please feel free to PM me for further discussion. Open forum is not the place for this kind of discussion.

Crawfy, I told you to post any further discussion regarding this in PM to me. Further disregard to my instruction will lead to your privileges here being either temporarily or permanently revoked.