Using the Excel names collection in Access VBA

[MichaelintheUK]

I am working with a series of dynamically sized ranges in which the contents are populated from an Access .mdb. The coding is in a Access module with a reference set to Excel. What I was doing worked fine until I tried using names.

I would like to place a marker at the start of each range and later go back and add totals and formatting by iterating through the names collection.

My declarations are

Dim myGroupRange As Excel.Range
Dim myName As Excel.Name
Dim myNames As Excel.Names

This is giving me a lot of problems e.g. crash on compiling.

What am I doing wrong?

thanks

Michael

 

[SkipVought]

Hi,

There must be more to your code. Is there any indication what statement is causing heartburn?

Perhaps you should post it all.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]