Entering a formula after filtering

[cmb80]

Hi there, I need to enter a formula (as below) into all visible cells (not including header row 1) in Column Q after a filter has been applied. The filter shows results for "today" in the date column so the visible cell rows will vary - and the amount shown will change day to day.

Can anyone help get this code pasted into all visible rows in column q after my filter has been applied?

Please Login or Register  to view this content.

[Fotis1991]

What are you trying to do?

Can you upload a sample workbook?

[cmb80]

I want to add this formula to all cells in column Q after I have filtered data by column A - Date column (Today).

So today I get 23 rows shown from 8916 to 8938 - I want the code above pasted into cells Q8916 : Q8938 using VBA.

Tomorrow the range maybe 38 rows, and maybe 8972 - XXXX

My file is over 5mg so not possible to uplaod it.

[Fotis1991]

..I want the code above pasted into cells Q8916 : Q8938 using VBA.

You post in wrong section, if you need vba for this and in any case i am not able to help you using VBA.

Good luck.

[zbor]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-prog...filtering.html

Thread Closed.