Find the value of a cell

  • Thread starter Thread starter afmullane
  • Start date Start date
A

afmullane

Hi guys,

I want to be able to implement an auto number function. So i'm trying
to read in the value of the previous row of the column. I'm using:

Cells(target.row, 2)

to find to find the row but i want to be able to read the value of the
number in the cell so that i can add 1 to the number.

Any help would be greatly appreciated,

Aidan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Comparing values in a cell and looping 1
Column number of last column that returns value ignore formulas 8
Lock a Cell or Row 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Change_Event not responding to change made by formula. 11
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Multiple Fxns in single sheet module 0

Back
Top