Click here to Skip to main content
15,867,704 members
Home / Discussions / Article Writing
   

Article Writing

 
Questionanother lemon from the same tree ? Pin
BillWoodruff19-Jul-21 10:55
professionalBillWoodruff19-Jul-21 10:55 
AnswerRe: another lemon from the same tree ? Pin
Sean Ewington20-Jul-21 1:16
staffSean Ewington20-Jul-21 1:16 
Questionnot an article ? Pin
BillWoodruff19-Jul-21 10:25
professionalBillWoodruff19-Jul-21 10:25 
AnswerRe: not an article ? Pin
Nelek19-Jul-21 10:35
protectorNelek19-Jul-21 10:35 
GeneralRe: not an article ? Pin
BillWoodruff19-Jul-21 10:58
professionalBillWoodruff19-Jul-21 10:58 
GeneralRe: not an article ? Pin
Nelek20-Jul-21 3:22
protectorNelek20-Jul-21 3:22 
AnswerRe: not an article ? Pin
Sean Ewington20-Jul-21 1:05
staffSean Ewington20-Jul-21 1:05 
QuestionInterrogating the Excel VBA 'Filters' object Pin
captaincoder215-Jul-21 16:27
captaincoder215-Jul-21 16:27 
<pre>
I need to interrogate the Filters object to learn what columns have active filters (Filter.On = True) and what the filter criteria are for each filter.
The problem that I have encountered is that the Filters object does not contain any information about which column each Filters.Item relates to.
There is no real problem if all columns have been ‘enabled’ for filters (i.e. each column header cell has a down-pointing arrow), because Filters.Count = the number of columns in the worksheet, and I can easily associate each filter with its relevant column.
But when some (but not all) columns have been ‘enabled’ for filters (for example columns 4-8), I have not been able to discover an algorithm for correlating each of the 5 filters with its relevant column.
Can the hive mind I know and love as Code Project please help me.
</pre>
AnswerRe: Interrogating the Excel VBA 'Filters' object Pin
Richard Deeming15-Jul-21 20:57
mveRichard Deeming15-Jul-21 20:57 
QuestionRolling back to a draft. Pin
Jon McKee11-Jul-21 12:59
professionalJon McKee11-Jul-21 12:59 
AnswerRe: Rolling back to a draft. Pin
Sean Ewington11-Jul-21 21:50
staffSean Ewington11-Jul-21 21:50 
GeneralRe: Rolling back to a draft. Pin
Jon McKee12-Jul-21 8:53
professionalJon McKee12-Jul-21 8:53 
GeneralRe: Rolling back to a draft. Pin
Sean Ewington12-Jul-21 9:32
staffSean Ewington12-Jul-21 9:32 
GeneralRe: Rolling back to a draft. Pin
Jon McKee12-Jul-21 10:02
professionalJon McKee12-Jul-21 10:02 
QuestionCode Pin
Member 152746173-Jul-21 7:48
Member 152746173-Jul-21 7:48 
AnswerRe: Code Pin
Greg Utas3-Jul-21 8:00
professionalGreg Utas3-Jul-21 8:00 
QuestionI wonder if there is a way to download all the articles submitted by myself? Pin
Dr. Song Li30-Jun-21 11:16
Dr. Song Li30-Jun-21 11:16 
AnswerRe: I wonder if there is a way to download all the articles submitted by myself? Pin
Sean Ewington2-Jul-21 3:58
staffSean Ewington2-Jul-21 3:58 
GeneralRe: I wonder if there is a way to download all the articles submitted by myself? Pin
Dr. Song Li4-Jul-21 8:17
Dr. Song Li4-Jul-21 8:17 
QuestionAuthors' names order inverted Pin
Dener Araújo28-Jun-21 2:14
professionalDener Araújo28-Jun-21 2:14 
AnswerRe: Authors' names order inverted Pin
Sean Ewington28-Jun-21 2:22
staffSean Ewington28-Jun-21 2:22 
GeneralRe: Authors' names order inverted Pin
Dener Araújo28-Jun-21 2:46
professionalDener Araújo28-Jun-21 2:46 
GeneralRe: Authors' names order inverted Pin
Dener Araújo29-Jun-21 2:54
professionalDener Araújo29-Jun-21 2:54 
GeneralRe: Authors' names order inverted Pin
Sean Ewington29-Jun-21 3:00
staffSean Ewington29-Jun-21 3:00 
QuestionObsolete article? Pin
Nelek27-Jun-21 4:55
protectorNelek27-Jun-21 4:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.