Results 1 to 4 of 4

Excel VBA For Creative Problem Solving Part 1 Assignment 4

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2023
    Location
    Norfolk, VA
    MS-Off Ver
    Office 365
    Posts
    3

    Excel VBA For Creative Problem Solving Part 1 Assignment 4

    Hi all,
    Can someone to provide me with a to solve the assignment #4? My subroutine as follows:
    Sub HighlightRows()
    Dim nr As Integer, i As Integer, identifier As String, key As Integer, ID As String
    nr = WorksheetFunction.CountA(Columns("A:A"))
    For i = 2 To nr
       ID=Cells(i,1)
       If identifier(Range(ID) = Range("identifier") And key(Range(ID) =Range("key") Then Range("A:C" & i).Interior.ColorIndex = 4
       End If
    
    Next i
    
    End Sub
    Not sure why "expected array" error pops up.

    Please, I just want an "advice" , not a complete fix.

    Thanks in advance
    PS: fairly new with VBA by the way
    Last edited by 6StringJazzer; 10-19-2023 at 01:58 PM. Reason: please use code tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help Needed: Excel VBA For Creative Problem Solving Part 1 Assignment 4
    By webcam723 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-04-2023, 08:28 PM
  2. Kindly Help in Solving this Excel Problem
    By yousufsaleem in forum Excel General
    Replies: 1
    Last Post: 12-07-2015, 06:37 PM
  3. Multivariate Calculus in Excel - Help Solving a Problem
    By el4n in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-07-2012, 04:52 PM
  4. Need help in solving a problem using Excel 2007
    By newbieexcel123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2010, 12:59 PM
  5. Mathematic problem solving using Excel
    By Stonewall in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2006, 03:20 PM
  6. [SOLVED] i've got a simple excel problem that needs solving...
    By Massive in forum Excel General
    Replies: 8
    Last Post: 05-16-2005, 04:28 AM
  7. Thorny VBA problem. Any creative solution appreciated.
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2005, 06:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1