Calculate total space usage from spreadsheet

Good Morning All,

I wrote the below code to try calculate the total amount of space used on an FTP site.
I have a list of all the different folders and the space they take up is in column 'B'. However the amount of space is followed by a 'KB' or 'MB' or 'GB'. So What I'd like to do is calculate the total amount of space in Gigabytes. I'm not sure what data types to set everything as for this in order to get this to work.
The Macro runs without any errors, but only returns a 0.

Any help would be greatly appreciated.

Cheers

R

Please Login or Register  to view this content.

Updated but still not working

Please Login or Register  to view this content.

Can you attach a sample file for us to 'play' with..

I am thinking you could incorporate autofilter then change each value to a common denominator (GB).. you could change the actual value or use a helper column..

Here ya go

Cheers Dude!

Is there anyway I can shorten the total to .00 decimal places, Then stick a Gb on the end?

It's cool, I got it. Cheers for all your help!