Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've found some posts that cover something similar to what I'm trying
to do, but I've not been able to apply it to my situation. It maybe just syntax. I have a named range that covers A7-A16. I need to find the first blank cell in that range. I tried to use: Set rng = Range("AACash") rng.Find("").Select but I get a runtime 91 error: "Object variable or With block variable not set". Maybe I'm just missing something. Any ideas or alternatives to apply? TIA Here's my code so far: Sub Asset_Allocation() Dim lastrow& Dim assettype$ Dim currentrow& Dim acct_type1$ Dim acct_type2$ Dim assetname$ Dim amt# Dim rng As Range Dim aa_row1& Dim aa_lastrow& Sheets("Asset Detail").Select 'start in S10 'find last row of print area lastrow = Range("Print_Area").Rows.Count With ActiveSheet Range("S10").Select For x = 10 To lastrow currentrow = ActiveCell.Row assettype = ActiveCell.Value If assettype = "" Then GoTo next_rec acct_type1 = Range("AB" & currentrow).Value acct_type2 = Range("AD" & currentrow).Value assetname = Range("H" & currentrow).Value amt = Range("J" & currentrow).Value Sheets("Asset Allocation").Select With ActiveSheet Select Case assettype Case "Cash" Set rng = Range("AACash") ------ rng.Find("").Select Case "Fixed Income" Case "Large Cap" Case "Mid Cap" Case "Small Cap" Case "Foreign" Case "Company Stock" Case "Real Estate" Case "Alternative Investment" Case Else GoTo next_rec End Select End With next_rec: Next x End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
Query Named Range Return Single Column Value | Excel Worksheet Functions | |||
Named Range reference via single Cell | Excel Discussion (Misc queries) | |||
named Range Referenced vai single cell | Excel Discussion (Misc queries) | |||
Identifying single column within named range | Excel Discussion (Misc queries) |