trying to copy and paste without cell references changing.

I'm trying to copy and paste without changing one of the cell references. For example:

In C1: =A1+B1
I want to put in C2: =A1+B2
and in C3: =A1+B3

I want to do it by copy and paste but I just want to change the B column not the A1. Thanks

Hi,

Enter this in C1 and drag down

=$A$1+B1

A1 will stay static while B1 will change to B2, B3 etc

VBA Noob

thanks that helped

No Problem

VBA Noob