Thread: selection
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default selection

Ken,

Use xl(down) instead of x1(down).

hard to see the fonts, so in english.....
use X(letter L) not x(number one)

John

Ken Matthews wrote:

Im trying to select the next blank cell in a worksheet,
using "Selection.End(x1Down).select". When the Macro is
run I get an error message "Application Defined or Object
Defined Error.

I'm only a beginner, the code looks right from the
manual...