Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0125· openaiHugging Face Suzhen/CodeChat

Can you please change this line of VBA code 'Set findRange =…

  1. User

    Can you please change this line of VBA code 'Set findRange = ws.Range("F:F").Find("VeryHigh", LookIn:=xlValues, LookAt:=xlWhole)' so that instead of dinding the word "VeryHigh", it finds the value of H3

  2. Assistant

    Sure! Here's the modified line of VBA code that will find the value of cell H3 instead of "VeryHigh":

    Set findRange = ws.Range("F:F").Find(ws.Range("H3").Value, LookIn:=xlValues, LookAt:=xlWhole)
    

    This code will search for the value of cell H3 in column F and assign the found range to the variable findRange.

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.