Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code for FIND values
Hi
What I'm looking for is the VBA code to FIND the content of cell F8 sheet1. Basically I've been trying paste cell F8 into EDIT FIND, "This cell value changes sometimes" Hope I've been clear in my question. Thanks in advance Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code for FIND values
Sub findF8()
Dim a As Variant a = Worksheets("Sheet1").Cells(8, 6).Value MsgBox a End Sub Is that what you wanted? "DaveM" wrote: Hi What I'm looking for is the VBA code to FIND the content of cell F8 sheet1. Basically I've been trying paste cell F8 into EDIT FIND, "This cell value changes sometimes" Hope I've been clear in my question. Thanks in advance Dave |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code for FIND values
Hi Nate
Apologizes I should of been a little clearer With no message And to find value in Sheet2 Column A would be nice. Thanks in advance Dave "NateBuckley" wrote in message ... Sub findF8() Dim a As Variant a = Worksheets("Sheet1").Cells(8, 6).Value MsgBox a End Sub Is that what you wanted? "DaveM" wrote: Hi What I'm looking for is the VBA code to FIND the content of cell F8 sheet1. Basically I've been trying paste cell F8 into EDIT FIND, "This cell value changes sometimes" Hope I've been clear in my question. Thanks in advance Dave |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code for FIND values
A simplified way
Sub findbasedoncell() mr = Columns(1).Find(Range("e8")).Row MsgBox mr End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "DaveM" wrote in message . uk... Hi What I'm looking for is the VBA code to FIND the content of cell F8 sheet1. Basically I've been trying paste cell F8 into EDIT FIND, "This cell value changes sometimes" Hope I've been clear in my question. Thanks in advance Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find multiple values code tweak | Excel Programming | |||
Need help with VB code to find certain values & select changing va | Excel Programming | |||
VBA Code To find Hardcoded Values in Formula | Excel Programming | |||
Find ALL WorkSheets according to 2 ComboBox Values.... Help with Code | Excel Programming | |||
code to FIND value, copy, paste values onto other sheet | Excel Programming |