LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 573
Default Which is unsupported?

Simple code:
Sub CRSPPPMod()
Dim Wksht As Worksheet
Call Clean
Set Wksht = ActiveSheet
Wksht("Sheet1").Range("A8:AE1000").Select<----ERROR
Selection.UnMerge

End Sub

Getting an "object does not support this property or method" error at
marked line. I checked the Object Browser. I think it says that a
worksheet can have a range, and a range can be selected. So how am I
misinterpreting the OB?
Thanks in advance.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unsupported methods for XL macro in IE Jean-Yves[_2_] Excel Programming 0 August 20th 04 03:34 PM
Unsupported object or method... mjack003[_12_] Excel Programming 2 February 10th 04 06:57 PM


All times are GMT +1. The time now is 09:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"