VBA to update only selected and visible cells

[sriley5]

Hi,

I have a workbook where I have to update a list of dates, and was wondering if there was a way where I could have my filter set, select a group of dates and update the visible cells with a date from a prompt where I would enter in a date? Any Help would be greatly appreciated.

[Richard Buttrey]

Hi,

One way would be to filter the list of dates you want to change and then use code like

Please Login or Register  to view this content.

Personally I'd use something a bit more robust than an Input Box to capture a date and use either a DATESERIAL number to populate the dt variable, or simply record the date you want to change to in a cell and read that into the dt variable.

You could also get the macro to filter your data first.

[sriley5]

Works well, but if I have a couple workbooks open, this is a little slow. What was your other suggestion?

[Richard Buttrey]

Not sure why it should be slow or why having other workbooks open would slow it down.
Is it still slow if you close the other workbooks? Are the other workbooks linked by any chance?

How many rows are you dealing with?

Upload the actual workbook for a more considered response.

[sriley5]

Thanks Richard, The other workbooks are around 40 mb, closing them made a huge difference. This will work, thank you!