Macro Search and display
Closed
PM
-
Aug 13, 2009 at 04:00 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 13, 2009 at 07:14 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 13, 2009 at 07:14 AM
Related:
- Macro Search and display
- Www.google.com search video - Download - Video playback
- 3 beeps on startup no display ✓ - CPU & Desktop Forum
- Vim search for word - Guide
- No display on monitor but cpu running ✓ - Hardware Forum
- 5 beeps on startup no display ✓ - CPU & Desktop Forum
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Aug 13, 2009 at 07:14 AM
Aug 13, 2009 at 07:14 AM
use this macro
Sub test() Dim rng As Range, d As Date Set rng = Range(Range("a1"), Range("a1").End(xlDown)) d = Date rng.Cells.Find(what:=d, lookat:=xlWhole).Activate Range(Cells(ActiveCell.Row, "b"), Cells(ActiveCell.Row, "c")).Copy Worksheets("sheet2").Cells(Rows.Count, "a").End(xlUp).Offset(1, 0).PasteSpecial End Sub