Find last cell in a spreadshhet using VBA

Hello everyone

Im currently working on a spreadsheet at work and im trying to automate it a bit using VBA.

The problem i have is that i am trying to find the last cell with data in column A, column a is full of formulas and when i use the End(xlDown) code it just keeps ending up with the last cell with a formula in but i want it to be the last cell with actual data in

Please help