Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

excel 2000 - EntireColumn

  Asked By: Hondo    Date: Jan 31    Category: MS Office    Views: 959
  

I'm trying to delete a number of columns of which I know the column
*numbers* and in testing with this code...

Dim rlR As Range

Set rlR = Range("g2:m2")
rlR.Select
rlR.EntireColumn.Select

... then columns A:M get selected.

Can anyone tell my why please?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Adalwine Fischer     Answered On: Jan 31

There was a set of merged cells in the
selected range. The columns had to span across it I guess. Deleting
the row with the merged cells in fixed it.

 
Didn't find what you were looking for? Find more on excel 2000 - EntireColumn Or get search suggestion and latest updates.




Tagged: