IAintaBlonde.com

Sub Fill_Blanks()
Dim col As Long
Set wks = ActiveSheet
With wks
col = ActiveCell.Column
‘or
‘col = .range(”b1″).column
Set rng = .UsedRange ‘try to reset the lastcell
LastRow = .Cells.SpecialCells(xlCellTypeLastCell).Row
Set rng = Nothing
On Error Resume Next
Set rng = .Range(.Cells(2, col), .Cells(LastRow, col)) _
.Cells.SpecialCells(xlCellTypeBlanks)
On Error GoTo 0
If rng Is Nothing Then
MsgBox “No blanks found”
Exit Sub
Else
rng.FormulaR1C1 = “=R[-1]C”
End If
‘replace formulas with values
With .Cells(1, […]

Cat Lover! Its my Life!Share This

All you have to do is end the MySQL service, say using XAMPP or a MYSQL administrator.
The reason why the service wont get created is because probably an older version of MySQl is already running. Now that was the easiest so far to solve!
There is an excellent article with detailed images on installation […]

I am taking the course “Advanced Databases and Datawarehousing” this semester. As a part of the course, i am supposed to work with either oracle or MYSQL or any other equivalent db.
Instead of working in the labs at the campus ( well, i need to apply and get a valid login from the IT guy […]