Excel Macros with VBA
this code giving some problem can u correct this.Actually i am trying to insert valuls from form into excel sheet
Do While (Worksheets(2).Cells(row, col1) = "")
If Worksheets(2).Cells(row, col1) = "" And Worksheets(2).Cells(row, col2) = "" And Worksheets(2).Cells(row, col3) = "" And Worksheets(2).Cells(row, col4) = "" Then
Worksheets(2).Cells(row, col1) = name
Worksheets(2).Cells(row, col2) = datefrom
Worksheets(2).Cells(row, col3) = dateto
Worksheets(2).Cells(row, col4) = reason
Exit Sub
ElseIf Worksheets(2).Cells(row, col1) <> "" And Worksheets(2).Cells(row, col2) <> "" Then
row = row + 1
End If
Loop
|
