Range problem in all macro's

  • Thread starter Thread starter kimt
  • Start date Start date
K

kimt

OK, it gets better and better, I'm about ready to start throwin stuff.
Here's the deal, regular macro, regular workbook...code reads

sheets("sheet1").select
range("a1").select

when you run it, you get "runtime error 1004" cant change part of
merged cell.

No cells are merged on the sheet. If you start a new macro and selec
cell A1, it generates the same code "range("A1").select" but still wil
not run...you get the same error. This is in excel 97

any ideas

:confused
 
Have you tried leaving excel and returning or even a re-boot?
BTW you can also use

Application.Goto [sheet1!a1]
 
Thats what I thought Don, so I rebooted...to no avail. Then I though
maybe I had some registry problems and ran MaCaffe cleaner, no help.
was working in the same book with vb 6 earlier and wonder if there i
some sort of conflict hanging around. If any one has any ideas let m
know... thanks Do
 
It's pretty big...when I get into the office, I'll try to cut as muc
fluff, if it's still a prob I'll forward it to you. Thanks Do
 
Back
Top