Actually i manage to do it however what i did is that i had selected other columns with cell totally empty and no value and do pings pings methods.
Which can be one of the methods that i can use ( THANKS pingping ) . However, just to play safe i would like to use column F as the focus as that cells ( that containt some value : "" null or something ) might pop out in another cell if that happens pingping's method wont work accordingly