Kimberlee MartinNov 7, 20223 minDebugging VBA without Line NumbersI wrote a post several years ago about adding line numbers to your VBA code. To this day, it remains my post popular post ever. Why? It’s...
Kimberlee MartinNov 4, 20227 minAppending Excel Data to an Access TableUse an append query to add Excel data to an Access table
Kimberlee MartinOct 25, 20226 minConnections: Importing Excel Data into AccessTips for making your Excel data import smoothly into Access
Kimberlee MartinJun 7, 20223 minDynamic Highlighting in ExcelFind cells containing specific text A customer called me today to ask a question about Excel. I thought it was an interesting challenge,...
Kimberlee MartinApr 20, 20226 minOne Click to Run Your MacroI’ve written a couple of blogs lately about creating Excel macros. In a related topic, today I’m going to talk about one of the easiest...
Kimberlee MartinMar 21, 20223 minIt's All RelativeRelative references vs absolute references in Microsoft Excel macros
Kimberlee MartinMar 14, 20222 minWhere to Start with the Excel Macro RecorderWhen getting started with the Excel macro recorder, start small, and build on your successes.
Kimberlee MartinJun 9, 20214 minMaking the Most of Excel – Data ValidationLast week I discussed using Excel effectively, in order to ensure it best serves your small business. I’m going to expand on that today,...
Kimberlee MartinJun 3, 20214 minMaking the Most of ExcelIdeas for maximizing your use of Microsoft Excel