stevenmcheerful
New Member
- Joined
- Apr 16, 2002
- Messages
- 20
Hello - I'm trying to create some templates that I want to be able to add data to from an ASP app. I'm struggling with a couple of issues:
- How do you (or *can* you) enter code in
the formula window ? i.e., I want to COUNTA() and SUM() some columns that will be variable width, but the Formula entry will not accept VBA like Range("A1").End and the like ...
- I gather that you cannot create a VBA Function (add-in) that returns a Range ?
(that would be really helpful)
- I have created some user-defined Functions in VBA, but they seem limited to returning a numerical result. So I guess in order to do things like choose a Range, such as A1.End(xlDown) it needs to be in a Macro.
I can write macros, but I want them to fire off based on the data in my columns - just like cell formulas. How do I make that happen ?
and last, is there a web site or specific book I ought to pick up to cover these things ?
Thank-You
- How do you (or *can* you) enter code in
the formula window ? i.e., I want to COUNTA() and SUM() some columns that will be variable width, but the Formula entry will not accept VBA like Range("A1").End and the like ...
- I gather that you cannot create a VBA Function (add-in) that returns a Range ?
(that would be really helpful)
- I have created some user-defined Functions in VBA, but they seem limited to returning a numerical result. So I guess in order to do things like choose a Range, such as A1.End(xlDown) it needs to be in a Macro.
I can write macros, but I want them to fire off based on the data in my columns - just like cell formulas. How do I make that happen ?
and last, is there a web site or specific book I ought to pick up to cover these things ?
Thank-You