tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
not sure if this is simple or not,
what i want to do is Filter Sheet "Data" column H on the name "Sold"
then count the number of rows visible to be copied.
if number of rows is more than 20 then messagebox " there is not enought room,
if less than 20 Call "copy macro"
so i'm trying to check the number of rows,
after the filter has been done?
any idea how to do this?
not sure if this is simple or not,
what i want to do is Filter Sheet "Data" column H on the name "Sold"
then count the number of rows visible to be copied.
if number of rows is more than 20 then messagebox " there is not enought room,
if less than 20 Call "copy macro"
so i'm trying to check the number of rows,
after the filter has been done?
any idea how to do this?