Macro recoridng not recording search functions?

[Brad_Miller]

Hello execl people

I am running execl 2019 I wanted to record a macro to find a value and selcet all the rows it is found in then using the keyboard shortcut ctrl+- to delete the entire row but the macro did not record a single thing.

Can any one advise if this is an operator/setting issue or if macro recording has some issue with the search function?
I tried with all keyboard shortcuts and mouse clicks but no luck....

all I get is the below and the stuff it did record was not the actual function I wanted....

Sub Macro1()
'
' Macro1 Macro
'

'
Selection.EntireRow.Delete
End Sub

 

[Marc L]

Hi,​

​

as it may depend on what you have operated during the record … Try without any shorcut.​

 

[Brad_Miller]

did both clicks and shortcuts nothing worked.

When you bring up the search box and type in your criteria to search and find all nothing is recorded in the macro

 

[Marc L]

​

The more recent Excel version, the less Macro Recorder abilities …​

​

The reason why I keep my old Excel 2003 version, the best version for recording !​

 

[Brad_Miller]

I tried a 2010 and 2019 both dont record the search function properly

 

[Fluff]

The Find All will not record as you cannot do a Find All in VBA.

 

[Joe4]

The more recent Excel version, the less Macro Recorder abilities …

I cannot say that I have noticed or experienced that at all.

I am running execl 2019 I wanted to record a macro to find a value and selcet all the rows it is found in then using the keyboard shortcut ctrl+- to delete the entire row but the macro did not record a single thing.

How about using Filters on your data, and then delete all the hidden (or unhidden rows)? I do that a lot with Excel.
If you need help, please post a sample of your data along with your conditions, so I can see what the data structure is.

 

[Marc L]

​

According to Fluff's post, try a record for a single find or just following the VBA help sample of the Range.Find method …​

 

[Fluff]

You can also use Chip Pearson,s FindAll function FindAll VBA Function

 

[Brad_Miller]

thanks everyone for your input.
I did version of Chip's VBA script and looped then deleted the entire row.