Eric_G wrote:
I am attempting to do the following to a filtered spreadsheet via a macro:

a) Filter a spreadsheet based on values in column A -- no problem
b) Paste a text value (i.e. the word "Cash") into the cells (subject to the
filter) which appear in column B all the way down to the last row as
determined by the filter on Column A.

In other words, paste this text value in every row of column B -- but the
rows are based on the filtered values of column A.

Any assistance? Many thanks.

Copy something to the clipboard (i.e, "Cash")

Select the last visible, pertinent cell in column B

Ctrl+Shift+Arrow Up (now many cells are selected)

Shift+Arrow Down enough times so your column header is not selected

Paste