Does anyone have experience with Excel macros in vb?

I need to test values in a loop. The Excel spreadsheet part is throwing me off. I also need to know how to add columns from the code. Is that even possible?Does anyone have experience with Excel macros in vb?
Looping through a range of cells...



For Each cell in Range(';A1:A100';)

'Your code here e.g.

'x = Cell.value * 100

Next cell





Insert a column...

Range(';B1';).EntireColumn.Insert

'or

ActiveCell.EntireColumn.Insert