Question

  • Thread starter Thread starter Anthony Viscomi
  • Start date Start date
A

Anthony Viscomi

I am not a XLS user; this project calls for the population of a XLS with
values that reside within Access, of which I am a power user. Anyway, where
do I put this code?
Sub ClearNamedRangeData()
Dim nName As Name
For Each nName In ThisWorkbook.Names
Range(nName).Clear
Next
End Sub
Click to expand...

I have over 25 Worksheets within this template. Is there a global that I can
place this in?
Thanks,
Anthony
 
Hi Anthony

With your workbook open and active: Open the VB editor (Alt F11 or similar).
Go menu Insert > Module. Paste the code in. Return to Excel. Now it's in
Tools > Macro > Run menu.

Optional: Put in somewhere either a button from the Forms toolbar, or any
object from the Drawing toolbar. Rightclick it, choose "Assign macro" and
assign it, then the code runs when you click the thing.

HTH. Best wishes Harald
 
As you are operating on the ThisWorkbook object it may make sense to
place the code in the ThisWorkbook code module and replace
'ThisWorkbook' with 'Me'.

Aside, here's a suggested code change:

Dim nName As Name
For Each nName In Me.Names
nName.RefersToRange.Clear
Next

--
 
Back
Top