Thread: range.activate
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rune_Daub[_16_] Rune_Daub[_16_] is offline
external usenet poster
 
Posts: 1
Default range.activate

A simple question.
When i press s userform commandbutton, I want it to activate the firs
empty cell in the A collumn..
But how??

I can figure out as much as range(xxxxx).activate... But how do I ge
it to recognise the first empty cell?

I have thought of a countv(A:A)+1

But I cant get it to work properly..

Rune Dau

--
Message posted from http://www.ExcelForum.com