Quick Excel Question

I have a spreadsheet

it has about 4000 rows, but for 8 of the 125 columns i need to add 1 to each cell....how do I do this?

do you mean add 1 & (data) or just make every thing 1?

PS: you should put this in the VBA or the VB Clasic section of VBforums.com

the data in all the cells are numeric, I want to mathamatically add 1 to every number

there are quicker ways, but this should work (untested):

VB Code:

'this assumes xlSheet is an active Sheet object
 
Dim lRow as long, lCol as long
 
With xlSheet
  '.Application.Visible = False     '(these will make it run faster)
  '.Application.ScreenUpdating = False
 
  For lRow = 1 to .UsedRange.Rows.Count
    For lCol = 1 to 8
      '(you should probably check there is a number)
      .Cells(lRow,lCol) = .Cells(lRow,lCol) + 1
    Next lCol
  Next lRow
 
  '.Application.Visible = True     '(restore)
  '.Application.ScreenUpdating = True
End With