On Tue, 4 Jul 2006 04:52:49 -0500, kirkm wrote:

Hi, Trying to apply this :-

Where column = "TheOneIWant"
if row 24 and row < 65
then increment the number in each cell by 1

I'm familiar with VB but not Excel and in a mad rush for this!

for column x, code looks like this:

dim cell as excel.range
for each cell in range("x25:x64").cells
cell.value = cell.value+1
next cell

--
PL