tezza
Active Member
- Joined
- Sep 10, 2006
- Messages
- 375
- Office Version
- 2016
- 2010
- Platform
- Windows
- Web
Hi All,
I've done searches but can't quite find the right answer so I've come to you for help.
I'd like to vba code the following:
Count how many rows have data in it (B7:G7 Down with no empty rows but not all Columns filled hense the range)
Copy the data from M7:P7 down the number of rows counted above (This range has formulas in so using something like xldown doesn't appear to work).
Kind Regards
Terry
I've done searches but can't quite find the right answer so I've come to you for help.
I'd like to vba code the following:
Count how many rows have data in it (B7:G7 Down with no empty rows but not all Columns filled hense the range)
Copy the data from M7:P7 down the number of rows counted above (This range has formulas in so using something like xldown doesn't appear to work).
Kind Regards
Terry