Paste in Find and Replace Dialogue
Sub Tester4()
Worksheets("Sheet2").Select Cells.Select Application.SendKeys Worksheets("Sheet1").Range("A1").Value 'Application.Dialogs(xlDialogFormulaFind).Show Application.Dialogs(xlDialogFormulaReplace).Show End Sub Regards, Tom Ogilvy "bobby" wrote in message ... Sorry for the second post, but i think i need to explain myself better. What i am trying to do is to have a macro go to another sheet and find the value that was copied into the clipboard. for examp: if cell a1 is 200, I want the macro to copy the cell and open up a find and replace dialogue box and copy the contents of the clipboard into the find spot. hope that makes sense, thanx |
All times are GMT +1. The time now is 11:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com