How to count number of cells/rows until first blank in Excel? For instance, you have a list of data including some blanks in a sheet, and what you want to do is to count the number of cells until blank cell, and the recount the below cells as following screenshot shown. Sub DoFrEm () Dim x As String Dim v As String v = "vvv" Range("A3").Select Do Until x = v Rows(ActiveCell.Row).Offset(1, 0).Select x = ActiveCell.Text Loop End Sub Thanks in advance 6 comments

Excel VBA – Do Until Blank Cell Estoy grabando una macro y necesito ayuda. Me gustaría copyr y pegar los valores de la columna G de la hoja de trabajo "SalesData" en las celdas A2, A12, A22, etc. de la hoja de trabajo "Resultados" hasta que no haya más valores en la columna G.