Last updated cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a conditional lookup depending on what is put in a cell. I
have managed to solve this with an array, however this needs to happen for
more than one cell so is there anyway to know which the last updated cell in
a column is? As this will allow me to change the array.
 
I think you'll need to be looking at the Worksheet's Change event where
'Target' is the range just changed.
 
You must log in or register to reply here.

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

Help needed 0
VBA set thick borders around non empty cells in range 0
Modify Claus code "Sub Array_Var_Column_Sort()" 27
Excel Macro to automatically go to the right of the last colored cell 0
Excel VBA 1
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
Vlookup error 5
= cell above last entered data 8

Back
Top