I have some data that I want to copy from one worksheet to another. All of the cells have calculations in them. I select them, hit "copy" and then in the destination, hit "paste special" (values). I want to run some code to delete the data in rows where cells B:F are empty. However, when I test the CountA function in the worksheet level, I get an unexpected value... Even though there is nothing visible in the cells, it gives me a return of 5, so it seems that it is considering the formulas as values, even if they are not visibile in the cells. I'm curious where I'm going wrong...
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
CountA in pasted data gives not expected result
- Thread starter wpryan
- Start date
Excel Facts
Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Great suggestion, thanks!
Upvote
0
Similar threads
- Question
