Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In an earlier post, I posted this code, which didnt' run.
Sub CtyMatch() Dim strOrig, strOutcomes As String Dim rCell, rTOCtyLst As Range Dim iOrigCityNo, iEndRow As Integer strOrig = ActiveSheet.Range("A2") iOrigCityNo = Left(strOrig, 2) iEndRow = ActiveSheet.Range.Cells(Rows.C*ount, "B").End(xlUp).Row Set rTOCtyLst = Range(.Cells(1, 1), .Cells(1, iEndRow)) I was getting an error on the Set line. I was also told not to use integer variable type anymore, so I changed it to long. Sub CtyMatch() Dim strOrig, strOutcomes As String Dim rCell, rTOCtyLst As Range Dim lOrigCityNo, lEndRow As Long strOrig = ActiveSheet.Range("A2") lOrigCityNo = Left(strOrig, 2) lEndRow = ActiveSheet.Range.Cells(Rows.Count, "B").End(xlUp).Row Now I'm getting a "wrong number of assignments or invalid property assignment" error on the lEndRow= line! The only thing thats changed is the variable type, and I was told that I didn't need to use integer any more, just to use long. I tried changing them back to integer, but it still gives me the error! Can anyone explain to me why code that ran fine a week ago doesn't run at all today? Ozone layer depletion maybe? I haven't changed the location of the code or the sheet it's supposed to execute on. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Create a newworksheet with VBA code and put VBA code in the new worksheet module | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming |