Typing vs Pasting Code

**GaPhilthy** · 05-22-2013, 07:58 PM

Hi All,

I am new to the VBA world, so bare with me and my extremely simple question...
Why is it that when I physically type:

Range("A1").End(xlDown).Select

I get error 1004 (application defined or object defined error)
Yet, when I type it out in notepad, and paste it into the window, it works perfectly fine...

Thanks in advance for your help

**patel45** · 05-23-2013, 02:01 AM

your vba editor has problems, does autocomplete run while you are typing ?

**HaHoBe** · 05-23-2013, 02:13 AM

Hi, patel45,

could you please elaborate how pasting in code into the VBE overcomes the "vba editor has problems"? Thanks

Holger

**dilipandey** · 05-23-2013, 09:48 AM

Hi GaPhilthy,

Is that line is the only code line between Sub.... End Sub ?

Regards,
DILIPandey
<click on below * if this helps>

**GaPhilthy** · 05-29-2013, 04:06 PM

Most of the time, my AutoComplete, Does not autocomplete.... Othertimes it will... it is almost like its just slow and most of the time im finished typing the word out before it tries to offer suggestions.

dilipandey - yes that is the only line of code I had beween sub... endsub... (with Rows 1-30 having entries in column A)

Thanks guys... I think there just might be something wrong with my vba editor on this computer

**dilipandey** · 05-30-2013, 03:57 AM

Okay.... did you tried any other computer ? Are you facing same issue on other computer as well ?

Regards,
DILIPandey
<click on below * if this helps>