Thread: A tricky one
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ADRIAN ADRIAN is offline
external usenet poster
 
Posts: 5
Default A tricky one

Right, you ready?

I have used:
Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Select

Is it possible to now continue the pattern that goes down
column A in this blank cell? To give you a better idea the
macro is to create a new part. so when it is run i would
like it to automatically enter the next part number and
move across to column B where the user can enter the
description.

I will be really impressed if anyone can sort this out.