If so, it shouldn't be too difficult, but it would be far easier just to set up a few cells in the spreadsheet manually to do the conversion.
Current conversion rate is 0.9826. 1 CAD = $0.9826 but that will change daily, so the first variable will be the current exchange rate.
Set up B1 with 0.9826
Then if cell A10 has CAD, then cell B10 has the formula, =A10*$B$1
The $B$1 tells Excel that, when you drag B10 down to cells below it, A10 will change to A11, A12, etc, but B1 remains the same.
Does that help?
Mark
I'm trying to create a macro that will convert selected cells from CAD to USD with the click of a button. Is this possible? I have no experience with VBA, but I think this is what I need to get this done... Any ideas?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic