By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes
listi.net
Excel problems [xp]
Various issues
E notation
Auto date formatting
Find on filtered list
Extra spaces in dates or numbers
Screenupdating issue where sheet looks locked
#N/A
#DIV/0
#NAME?
#REF
Calculations turned off
VBA code overwriting wrong sheet
VBA can't be undone with Ctrl+Z
application.events were turned off so new code I added didn't work
Slow recalculation
This workbook contains links to one or more external sources that could be unsafe [Update] [Don't Update]
Missing "&"
Missing "
Hard to understand formulas
Circular references
Cut while filtered
VBA code filter > 12/2/2020 and the date in sheet was 1/22/2021 or 01/22/2021 (Happens in Pivots also)
Sort screw up
Forget to save
Corrupted spreadsheet
Annoying calculations
Missing Reference causes error in weird places
Scrolling stopped working because of Freeze panes
Worksheet was protected
Value error when you blank out a zero as part of a formula
$ - if formatted for accounting
This function isn't valid - starting item with @ use '@
Find
Hidden problem
Selected row problem
Workbook vs. sheets
Hidden options
Update links warning
Names
VBA Buttons
Charts
search all workbooks for [
Options settings
R1C1
DDE setting
Screenupdating = false
EnableEvents = false
Calculation = off
insert row and get "Cannot push items off the sheet
Macro problems aka VBA Problems
Leading zeroes suppressed but what if wanted?
Cusips become e notation
Loss of shortcut keys if you move code from one module to another
Complex issues when creating strings with quotes in quotes
Undo doesn't work
Versioning and auto save needed
Parameter Mismatch (Parm)
Ctrl+P macro stops working (1. I moved the code to a different module, 2. the code is still in debugger and I don't know it)
Error 9 - Subscript out of range - Often sheet doesn't exist.
Button press and nothing happens - Could be stopped in debugger, Alt+F11 then Ctrl+L
Thisworkbook.name doesn't work if the window has a New window and it ends in ":1" May need to use activewindow.caption
Hardcoding
and the input changes, column removed or added, changed sheet name, etc.
used hc len and broke dash add code
Didn't initialize a global variable so on next run the data was wrong
SQL runquery on a memo field doesn't work, need to convert(varchar,memo_field)
Compile Errors
Constants, fixed-length strings, arrarys, user-defined types and Declare statements not allowed as Public members of Object Modules Caused by have a declare (aka API ) in a sheet code must be in a Module
Option Problems
The columns have numbers 1, 2, 3, ... instead of the usual letters A, B, C .. * Database Issue
Query didn't skip logically deleted records so the "b" shortcut add logic didn't work
mixed up the fields in config files switched config_value and config_data
query used wrong field names (I think I added a new table
ASP
On err resume next
Mismatched quotes ex. response.write "OK & p & " updated."
Forgetting to return a value in a function
Had javascript code after the <% and it should be before
Form tag caused reload of page so callback failed
dim all variables in a function or sub to prevent global var type effects
Webservice fails bc I added debugging and the return isn't OK or NG, the code should check this better
I'm having issues with vblf and vbcrlf and using the vbcrlf to denote new record
General common Errors
Spelling
Syntax error
splitting data by spaces but there are hidden tabs
Misc
mailto failed because user didn't have the default protocol set up
Giving out your spreadsheet often will show issues that you didn't code for
Hardcoding I have mid(a,1,2) but changes to A from
SQL code to get comma list not working from runquery until I set it up as a stored proc