如何循环Excel VBA宏，每次向下移动一列时都会调用另一个宏

Instead of having code that calls a macro for each line as it moves down A1:A100, I would like my macro to loop until it encounters a blank cell within column A.Instead of having code that calls a macro for e