Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I need some lines of code to count the number of rows in column A which includes blank cells. If number of rows is greater than, less than 10 a MsgBox with instructions should appear. I'm importing a .txt file, deleting any blank rows and adding/changing text and some formatting. When finished the text should finish on row 10, ranging from cell A1 to N10 no-more no-less. The purpose is to indicate to the user, the original .txt file did not contain 10 rows of text. These lines of code will run at the end of macro. I'm not sure how the Count, If true, if false, then, else syntax should be laid out, and call up the MsgBox. TIA Bob C. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MsgBox when an Error occurs | Excel Discussion (Misc queries) | |||
MsgBox compile error in Excell | Excel Discussion (Misc queries) | |||
Compile error for MsgBox copied from Microsoft training example? | Excel Discussion (Misc queries) | |||
msgbox on error | Excel Discussion (Misc queries) | |||
Count Records & Display MsgBox | Excel Programming |