Forum

Alan Elston
@doc-aelstein
Eminent Member
Joined: Dec 29, 2020
Topics: 0 / Replies: 21
Reply
RE: Macro remove leading and trailing spaces in cells

You are welcome. Thanks for confirming that the alternative works for you. That is good to know. Alan _.________________________________________...

4 years ago
Forum
Reply
RE: Macro remove leading and trailing spaces in cells

Hi, Just out of passing interest, I looked at the characters in the workbook with a function which I have that lists all characters in strings. ...

4 years ago
Forum
Reply
RE: Pass Named Range to VBA Function

You probably want to do something along the lines of what Veloria was referring to when she said " … you could amend the code so that it takes the ran...

4 years ago
Forum
Reply
RE: Pass Named Range to VBA Function

I have never used INDIRECT before, but I tried what I think Veloria suggested, and what I think she said to do seemed to work…So in a cell you type li...

4 years ago
Forum
Reply
RE: Pass Named Range to VBA Function

In the spreadsheet attached to this thread, the following function works. =Annuity(N5,N6,GAM83Male,N2,N3,N4)…_ _...which function coding exactly...

4 years ago
Forum
Reply
RE: Run-time error 1004

Hello David Range referencing in VBA is actually quite complicated. To understand fully needs quite a bit of reading of a good Blog, or good tuiti...

4 years ago
Forum
Page 2 / 2