LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,124
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find multiple values code tweak ToddEZ Excel Programming 5 November 26th 07 08:26 PM
Need help with VB code to find certain values & select changing va Jessica Excel Programming 0 July 18th 07 02:32 PM
VBA Code To find Hardcoded Values in Formula anjohn Excel Programming 4 August 19th 06 09:31 PM
Find ALL WorkSheets according to 2 ComboBox Values.... Help with Code Corey Excel Programming 5 July 7th 06 11:33 PM
code to FIND value, copy, paste values onto other sheet ufo_pilot Excel Programming 2 December 6th 05 04:14 PM


All times are GMT +1. The time now is 06:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"