| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with SpecialCells method
Hi,
I don't know why the below code is not working -- when I run the same code without the ".SpecialCells(x1celltypeconstants)" at the end of ".Range("D2", ..Range("D2").End(xlDown))", it works. I looked at Help and according to help, I believe I have incoroporated SpecialCells correctly. With Sheets("Member ID Report Master") .Cells.Sort Key1:=.Range("D2"), Order1:=xlAscending, Header:=xlYes, MatchCase:= _ False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal Set salesrange = .Range("D2", ..Range("D2").End(xlDown)).SpecialCells(x1celltype constants) End With -- Robert |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Issue with SpecialCells method
change
x1celltypeconstants to xlCellTypeConstants (i.e., the second character is an "ell" not a "one") In article , robs3131 wrote: Hi, I don't know why the below code is not working -- when I run the same code without the ".SpecialCells(x1celltypeconstants)" at the end of ".Range("D2", .Range("D2").End(xlDown))", it works. I looked at Help and according to help, I believe I have incoroporated SpecialCells correctly. With Sheets("Member ID Report Master") .Cells.Sort Key1:=.Range("D2"), Order1:=xlAscending, Header:=xlYes, MatchCase:= _ False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal Set salesrange = .Range("D2", .Range("D2").End(xlDown)).SpecialCells(x1celltypec onstants) End With |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Issue with SpecialCells method
Haha - can't believe I missed that. Thanks so much!
-- Robert "JE McGimpsey" wrote: change x1celltypeconstants to xlCellTypeConstants (i.e., the second character is an "ell" not a "one") In article , robs3131 wrote: Hi, I don't know why the below code is not working -- when I run the same code without the ".SpecialCells(x1celltypeconstants)" at the end of ".Range("D2", .Range("D2").End(xlDown))", it works. I looked at Help and according to help, I believe I have incoroporated SpecialCells correctly. With Sheets("Member ID Report Master") .Cells.Sort Key1:=.Range("D2"), Order1:=xlAscending, Header:=xlYes, MatchCase:= _ False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal Set salesrange = .Range("D2", .Range("D2").End(xlDown)).SpecialCells(x1celltypec onstants) End With |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| specialcells(xlLastCell) and method global range error | Excel Programming | |||
| SpecialCells Method Question | Excel Programming | |||
| How select/define cells with FIND method (maybe together with SpecialCells) | Excel Programming | |||
| SpecialCells Method selects valid records | Excel Programming | |||
| specialcells method errors when criteria not found | Excel Programming | |||
Hybrid Mode
