Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a filtered list and want to enter "SOLD" in column A for only the rows
that meet the filter criteria. I am having difficulty acting only on the visible cells. (I am creating the macros by recording my keystrokes, not writing VB code). Whether I enter the value in the first row and copy it down or enter the value in each cell, and press <down arrow to move to the next cell, the macro records specific cell addresses. If I try relative addresses, it records that specific number of rows to move down. Can someone provide some suggestions, or perhaps a bit of code that sets the range to the visible cells in Col. A that I can paste over the code that indicates specific cells? Thanks in advance for your assistance. Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A list of what is being filtered on? | Excel Discussion (Misc queries) | |||
ACTING OUT DROPDOWN LIST ( OR DROPUP) | Excel Worksheet Functions | |||
Macros the same but not acting the same | Excel Programming | |||
Top 25 in a filtered list | Excel Programming | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming |