Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm running a simple macro to find and go to a cell containing specific
data using the cell.find method. I would like to add a Tab over to the cell adjacent to the found cell, and have tried the following: selection.typetext text:=vbTab but VB retruns an error saying "Object doesn't support this property or method. Here's the whole code: Sub Look_Here() Dim WhatFor WhatFor = ActiveSheet.Cells(7, 2) Cells.Find(What:=WhatFor, after:=ActiveCell, SearchDirection:=xlNext, searchorder:=xlByRows, MatchCase:=False).Activate Selection.TypeText Text:=vbTab GoTo End_Here End_He End Sub What should I be typing different to make the macro tab over from the found cell? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding a Macro to a VLookup Function | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Customising Macro Buttons, Adding an image in excel | New Users to Excel | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |