Skip to main content

Stack Exchange

chris neilsen

New Zealand

top accounts reputation activity subscriptions
Top Questions
No questions with score of 5 or more
Top Answers
672
How to avoid using Select in Excel VBA
stackoverflow.com

51
Excel VBA, getting range from an inactive sheet
stackoverflow.com

50
Excel function to make SQL-like queries on worksheet data?
stackoverflow.com

50
Formula in Excel to count occurrences of substrings within strings
stackoverflow.com

49
Check if value exists in column in VBA
stackoverflow.com

48
Disable clipboard prompt in Excel VBA on workbook close
stackoverflow.com

44
Excel Macro : How can I get the timestamp in "yyyy-MM-dd hh:mm:ss" format?
stackoverflow.com

38
How to Remove Line Break in String
stackoverflow.com

36
How do I create a timeline chart which shows multiple events? Eg. Metallica Band members timeline on wiki
stackoverflow.com

34
Excel function that evaluates a string as if it were a formula?
superuser.com

34
Effect of Screen Updating
stackoverflow.com

33
Add new row to excel Table (VBA)
stackoverflow.com

33
Selecting a Specific Column of a Named Range for the SUMIF Function
stackoverflow.com

32
How to search for newline or linebreak characters in Excel?
superuser.com

31
Get File Path (ends with folder)
stackoverflow.com

31
Excel compare two columns and highlight duplicates
stackoverflow.com

29
What is the difference between Sheets.Select and Sheets.Activate?
stackoverflow.com

28
Find all references to a cell
stackoverflow.com

27
Removing Formats From Entire Worksheet with VBA
stackoverflow.com

25
How to roundup a number to the closest ten?
stackoverflow.com

25
Excel VBA - Run macro before save
stackoverflow.com

24
How to CountIf in multiple columns?
stackoverflow.com

24
Cycle through sub-folders and files in a user-specified root directory
stackoverflow.com

23
How to dynamically show the current time (and not date) in Excel?
superuser.com

22
Excel VBA function to print an array to the workbook
stackoverflow.com

21
What is the most efficient/quickest way to loop through rows in VBA (excel)?
stackoverflow.com

21
Excel: suppress if cell above has the same value?
stackoverflow.com

20
Reverse order of For Each loop
stackoverflow.com

20
Excel macro to fix overlapping data labels in line chart
stackoverflow.com

19
Count/Sum a column but exclude #N/A
stackoverflow.com

1 2 3 4 5 6