Range.ResetContents

[Colin Legg]

This one is more of a curiosity than anything else. I was exploring the Excel object model in the VBA IDE and I noticed that there's a Range.ResetContents() method. It's a hidden member so you have to right click > show hidden members in the object browser to see it. I don't remember seeing it before and I can't find any online documentation about it. Does anyone know exactly what it does and whether it's new or old? I'm wondering if it might have some edge case uses.

 

[Micron]

My version is MSO 365 and I don't have it. Then again, I don't allow updates so I'm probably behind. By chance do you have any add-ins installed? It might belong to an add-in. This is as close as I came in a search, but it's not exactly the same

Excel.Range class - Office Add-ins

Range represents a set of one or more contiguous cells such as a cell, a row, a column, or a block of cells. To learn more about how ranges are used throughout the API, start with Ranges in the Excel JavaScript API.

learn.microsoft.com

 

[MARK858]

I see it with my version although I also had to toggle the Group Members option to get it to show.
I also note that it is greyed out on my version.
I have no idea about it and also can't see any documentation

Version
Microsoft® Excel® for Microsoft 365 MSO (Version 2407 Build 16.0.17830.20016) 64-bit

 

[Colin Legg]

Okay, thanks both - sounds like it's been added fairly recently then.