View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Macro fails on 1 out of 4 computers

Try this instead

Set myCell = Application.InputBox( _
Prompt:="Please select a Vendor by" & _
Chr(10) & Chr(13) & Chr(13) & _
" clicking on their NAME cell", _
Type:=8)

Set myCell = myCell.Resize(1)

"CLR" wrote:

Hi All.........
I have a little Excel program that works fine on three different computers,
and mostly works on a fourth, but one of the macros fails on this line on
the fourth computer...

Set myCell = Application.InputBox(Prompt:="Please select a Vendor by" &
Chr(10) & Chr(13) & Chr(13) & " clicking on their NAME cell",
Type:=8).Cells(1)

All three are Windows XP and Excel 2k

Anybody know why, please?

TIA
Vaya con Dios,
Chuck, CABGx3