PDA

View Full Version : Microsoft Excel Programming


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 [62] 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236

  1. Help with code issues
  2. Print one-sided and override two-sided default
  3. Deleting columns/rows
  4. REFEDIT.DLL???
  5. help on sizing a check box created using the Forms toolbar
  6. finding the scale on a chart
  7. ctrl-p
  8. Inserting multiple rows...
  9. Macro imports data into cols A,B,C. Would like the data in D,E,F
  10. Help with compile error
  11. Condition Formatting Code for text in cells
  12. Print an Embedded Word Doc
  13. How do I get a list from an excel sheet into a userform/listbox?
  14. Explanation please
  15. Custom filter setting
  16. Object LIbrary Versions 11.0 - 10.0
  17. SYLK files Excel Picture format
  18. Some wierd and wonderful macro required
  19. Sumif SumProduct Several Criteria
  20. keypress interception
  21. Determine data type in a string
  22. Error on all My Excel books
  23. Test for Values Q
  24. Close worksheet, dont save
  25. Error Loading UserForm
  26. Macro to add word to existing text in different worksbooks
  27. What is the maximum number of unique strings in Excel 2003
  28. Message box and loop
  29. Count Specific Total Numbers from a Set
  30. McAfee problem
  31. User forms
  32. WindowsMediaPlayer1 Mute Sound?
  33. macro to filter rows containing user defined data
  34. SUM Macro
  35. Manipulating arrays
  36. How can I reuse function for a userform button
  37. My code works in command button but not in public sub
  38. Correct approach for clearing memory with repeated Database queries
  39. setup project for Excel addin, won't register addin
  40. combining different size tables
  41. Newbie : question on VBA and checkboxes
  42. how to bring a value from access into excel based on criteria
  43. Macro to Paste Data in Non-Office Program
  44. Set Row as Variable...
  45. Check Cell Content before continuing...
  46. Change code to popualte into cols D,E, & F instead of A,B, & C
  47. Moving columns about
  48. Txt file properties
  49. Copy data from Workbook Alpha & reorganize it in Workbook Bravo
  50. Consolidate a worksheet from different workbook into one master
  51. Named range prob using VB to move wksheet to an existing wkbook
  52. Search Multiple Sheets Then Add Txt1.Txt to Cell
  53. VBA Imaginary Breakpoints Error
  54. Compile error - Can't find project library ????
  55. Compile error - Can't find project library ????
  56. Need Help Expanding Macro
  57. Counting Occurences According to Time
  58. Macro name issue
  59. Excel Equivalent of Access OptionBox
  60. Error: Block If without End If
  61. Macro to change the column references automatically
  62. Disable Macro Workaround Doesn't Work!
  63. Macro copied from ng returns a #VALUE!
  64. Line break in cell
  65. Borders on Fixed # of Columns, Variable # of Rows
  66. Borders on Fixed # of columns, Variable # of Rows
  67. Menu Vanishes on Opening a Worksheet
  68. averages with formulas
  69. Selecting which macro to run based on a user entry
  70. BeforeSave event
  71. Updating Custom Menu Code References when New Workbook is saved
  72. Change Default Printer Causes Abort
  73. Query Close code question??
  74. Pivot cache when pivot table copied
  75. Alternative VBA to copy a worksheet
  76. Toggle buttons, Check boxes
  77. Select Entire Row if Text is Red
  78. simple edit
  79. clearing memory using VBA
  80. Insert Row Specified Sheet
  81. Run-Time Error and UserForms
  82. Sum macro for a variable "i" in a loop
  83. Sum Left Formula, Excel 2000 & 2003
  84. Sum that ignores text
  85. how do i link a picture to a vlookup result?
  86. Text box value lost
  87. Move Worksheet from one Workbool to another - fails on Excel 2007
  88. macro to copy range of data between worksheets
  89. API Class Question
  90. Exporting / or copy to Excel
  91. VBA Code : Example 9-1 David Bourg's Book
  92. Block copy of Datatable to Excel Spreadsheet using C#
  93. Using autofilter to trigger an event
  94. There's got to be a better way....
  95. Find row and insert formula, skipping columns
  96. how can i run excel/word macro to C# .net programs
  97. After copy of row, cannot paste to activated sheet
  98. Customizing menu buttons in Ecel 2007
  99. Strange Occurences
  100. Difficult text to number conversion
  101. Copying a range
  102. vlookup with match
  103. select row(s) and shift up one place automatically
  104. Coloring fonts
  105. Dynamic File Name Referencing
  106. Export "Define Name" Dialog
  107. How to filter and count unique record?
  108. How to display results in a shape?
  109. spreadsheet control
  110. Error renaming Worksheets when addin is loaded
  111. Speed up saving of a workbook
  112. How do I adjust 2 variables to minimize the difference between 2 waveforms?
  113. Can't run macro
  114. Attaching to Running Process
  115. workbook before print target
  116. Use of Variable
  117. Autofill Macro.
  118. Listobject selected and Deselected event
  119. Import Macro in PERSONAL.XLS will not import to my main document
  120. List files that contain macros
  121. Office 2003 SP3 Installed Now Can't Use Excel Through COM
  122. Looking up 2 values to return only those that match to another cel
  123. autofilter questions
  124. Programed sort generates error: originated as recorded macro
  125. automated copy and past special feature
  126. Choosing a Subject Title, How to be Specific
  127. SUBTOTAL in SUMIF formula
  128. Run VBS from VBA?
  129. Problem with code
  130. Loop How-To
  131. Want to find a service company to write an Excel 2003 macro
  132. #Value! Same formula, different outcomes
  133. How to synchronize the data changed in Excel to a SQL server
  134. How to ensure sequential command execution via SQL Query tables?
  135. CreatePivotTable: Invalid procedure call or argument
  136. Add Subtotals after inserting row
  137. Prompted for VBA password when closing Excel with "Lotus Notes Qui
  138. Range definition
  139. Request for error handling tips
  140. RunTime Error 57121
  141. need some pivot table help
  142. Error Handling in Each Sub
  143. Object properties viewer
  144. Print to PDF with Acrobat 7.0
  145. If help. Multible IF's
  146. Excel 2007 Save As xlsm by default
  147. how to auto-print if data is on report after each sort?
  148. vba code for opening password protected workbook
  149. Import data from MS Sql Server to Excel
  150. Group by SUM
  151. Selecting and cutting unknown picture numbers from a specifc range of cells
  152. Data Array in Listbox?
  153. Create ListBox and Populate with Array
  154. Help - Macro has stopped working - Compile Error
  155. Problem filtering by data >12/01/2002
  156. email out Pivot Chart with one record only
  157. Return User to Last Active Worksheet
  158. Date Problem in VBA
  159. writing amendments to a different worksheet
  160. How to delete imported data
  161. Macro on new file
  162. Unknown column length
  163. Copy data to another wb based on specific criteria.
  164. XL2002 - SeriesCollection.Index
  165. Data Labels Macro
  166. Out of Memeory
  167. Error 424 when trying to determine whether Sheet exists..
  168. Match Found - Delete
  169. The object invoked as disconnected from its clients. - To many she
  170. Passing worksheet as an argument
  171. Passing worksheet as an argument
  172. find and copy rows based on dates in two columns
  173. Manipulating arrays
  174. Select non empty cells
  175. Search in matrix.
  176. MAKING A GRAPH WITH A MACRO.
  177. Store variables in code just as you can w. constants? Available to read/edit?
  178. Listbox-2 entires should select by Clicking Listbox-1 entires. How
  179. addin running in different Excel instances
  180. "Listing Contents of Sub-Folders"
  181. How to Enhance Excel as a Distributed Application?
  182. Trigger Macro on Worksheet Delete
  183. Custom Pivot table results
  184. Create generic macro for a custom toolbar
  185. Run macro when cell is selected
  186. Printing
  187. represent tabular information as plain ASCII text
  188. Copy a Variable range
  189. Pulling "Irregular Shaped" Data from Excel
  190. How can I use VBA to creat new web query?
  191. "Dir" uot of order
  192. Combo box on user form
  193. Retrieving hyperlink from MS Access database
  194. ppic
  195. Sub RepStats()
  196. Print individual schedule; 1=attend class 0=don't attend
  197. Print individual schedule; 1=attend class 0=don't attend
  198. ToolBox cotrol
  199. Replacing the contents of a variable as the name of an array
  200. Error Could not set the ControlSource property. Invalid property v
  201. Create Combo Box and Populate
  202. how can get average of 3 max values out of 7 values in a row
  203. Convenient way to ignore Debug.Assert ?
  204. insert pictures
  205. A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated
  206. Working with 2 sheets, need to auto fill 2nd sheet with date from
  207. Manipulating arrays
  208. Match and extract
  209. Reading a cell content and using it later
  210. transfer data from excel automatic to access
  211. Accessing a control
  212. Function/Sub
  213. Microsoft Excel Web Query Connectivity Kit
  214. Pivot Chart Problem when Refreshing
  215. Auto mail from xl
  216. Activecell range copy
  217. Copying cells between sheets
  218. Copy and Paste LAST ROW of data non-contiguous
  219. sum if
  220. Delete code after use
  221. Find/Replace Event or Find/Replace for Protected Sheet ...
  222. Automation Error
  223. "Set" problem
  224. How can I open on 3rd Sheet Q
  225. How to use excel form in VS2005
  226. auto fill data
  227. EnableEvents
  228. question on VBA and Checkboxes - Newbie
  229. Format date as Custom YYYY yields 2005, but fx still shows 1/1/2005
  230. Transporting text files from notepad to excel
  231. Reference error in excel
  232. Help with if elseif verification
  233. Save file as XLS (2003)
  234. Worksheet_Change
  235. Scope of Tables Is Workbook, Not WorkSheet
  236. Macro to delete specific cells
  237. Calculating a total controlled by multiple variables?
  238. ComboBox font color
  239. Sub-Menu Listings
  240. Userform Background Transparent?
  241. Help/Advice copying from one sheet to another
  242. Command Button That Will Toggle
  243. Copy/pastespecial error
  244. Extract hour from date
  245. Excel auto copy cells
  246. Automation Error
  247. Use Macro from Source
  248. Excel-based MIDI Music Synthesizer
  249. Floating button
  250. Validation Lists
  251. Using application.ontime
  252. Is it possible to run a macro in tandem with, or right after, ctrl+c?
  253. Adding Line Style on Forms (or another way)??
  254. where do my SQL querries get stored in the MS query tool in excel?
  255. Value issue
  256. Date calculation
  257. Series Number when Create Chart
  258. How to know a pattern's texture features
  259. Macro to sequence ("$A:$A") to ("$IV:$IV")
  260. Address of calling cell?
  261. Copy specific cells to new rows
  262. Excel VBA Noob question: Read row data into VB6 Structure(UDT)
  263. Custom Properties or Tags for Shapes in Excel
  264. VLOOKUP in Excel
  265. Clone a record, edit it and add as new record to database.
  266. Test for if sheet is HIDDEN
  267. Compare Two Sheets Generates Runtime Error 13
  268. Cut/Paste Certain Rows from Workbook1 to Workbook2
  269. Printing forom different tabs
  270. Check this free people search out
  271. can not find installable ISAM
  272. Copy sheet1.range("A3:G5000") from an open file
  273. [Quickly!] Removing PrefixCharacter (i.e. leading, hidden apostrop
  274. Subtotal < 0
  275. How to connect MS SQL Server using VBA Macro Programming?
  276. skip blanks in array formula (help!)
  277. Convert string to date
  278. Compound Interest
  279. change the format of a cell message appear "Too Many Cell Format"
  280. delete drawings in a centain selection
  281. macros or formulas not sure
  282. Last day of month is saturday or sunday?
  283. delete drwaings in a centain selection
  284. Group & Outline - how do I hide detail programmatically
  285. Export to CSV file problems
  286. Weekdays
  287. Excel problem
  288. Deleting a sheet in a shared and protected workbook
  289. I want to highlight multiple cells using VB
  290. Addin Error after installing Excel 2003 SP3 , does anybody have same problem?
  291. Saving to USB Drive either D or E
  292. Re: reading longvarchar(484), data always empty in Excel Options
  293. How to make the sheet index name same as the sheet name after inserting sheets?
  294. Product Finder
  295. Recording Regression in Macros
  296. Form button crashes XL2007
  297. Error when changing the sign on numbers
  298. Lock formatting
  299. Hide UserForm Background??
  300. copy values from vertically-horizontally
  301. When content of a cell changes, content of another deletes
  302. vba
  303. Difficulties Opening, copying from another workbook and closing
  304. Macro Help
  305. Syncronizing tables in different worksheets.
  306. email macro read receipt
  307. Paste special values and formats
  308. Force save to CURRENT directory
  309. compare columns
  310. Function Problem.
  311. Hierarchy Macro
  312. how to add a sub at the application level open event?
  313. Pass an array
  314. customizing drag functionality
  315. Moving Public Function From Workbook Module to XLA
  316. Issue with imported data
  317. multiple cells
  318. Selecting Autoshapes
  319. Shell command writes file to wrong directory
  320. Using a function to hide rows
  321. Can this be done?
  322. pause without break point
  323. Counting number of occurrences.
  324. Relative reference to a table across multiple worksheets
  325. Collections and Keys for Ranges
  326. I need to change hardcoded background color
  327. Why are my date results incorrect
  328. Will countif work?
  329. Copy worksheet to new workbook question
  330. Selecting a range by using a loop
  331. Missing Data
  332. Coverting single-value array into an ordinary variable
  333. Search for worksheet name in Excel spreadsheet
  334. Fill Right Variable Number of Columns, then Calculate Using Offset
  335. Change format DATE language
  336. Arrays problems
  337. Custom colours in charts
  338. Formula to VBA
  339. Conditional formatting (?) help
  340. Search data inside column
  341. exception 0x800A03EC in excel
  342. Return Value of Number
  343. List duplicate Files in Drive
  344. Returning a value in a range
  345. MsgBox()
  346. How can I select a range manually with the mouse?
  347. Conditional cell protection
  348. Range variables
  349. Problem with a a number ending in -
  350. Macro in Different Versions of Excel
  351. See the line number
  352. On Error
  353. More Sumproduct!
  354. Add and remove toolbar custom buttons
  355. Hidden excels popping up when a new excel is opened.
  356. Why does the date toggle between formats
  357. Buttons lose macro assignments
  358. If statement with VLookup can't quite figure the formula out
  359. Create Custom Paste Special - Row Heights
  360. moving personal.xls to another computer
  361. million dollar question!!!!!!!!!!
  362. GetPivotData in VB
  363. Passing parrameters when calling a sub from by clicking an object
  364. Name of Class instance
  365. Macro won't execute when Worksheet is Protected
  366. Location of validation message box
  367. Can't find Excel 4.0 Macro in Excel 2003
  368. Print All Subfolders Workbooks
  369. How to automating Excel from an SQL Server Script?
  370. Macro to select max value of range E
  371. Direct DLL reference?
  372. Clocking - Maybe Caught in a Loop?
  373. Setting the namespace when doing a SaveAsXMLData
  374. Macro to copy adjacent columns for a specified condition
  375. .Find, cells with spaces
  376. Custom Toolbar - Buttons, Macro Assignment.
  377. Series Collection Question
  378. Japanese text lost when save as tab delimited text file
  379. Redim Public Array variables
  380. Deleting Column Based On Header
  381. Cells.find only reporting range in AutoFilter...
  382. Is there a better way?
  383. Allow value in only one of two cells
  384. First time I see something like this!
  385. Auto Mail
  386. Custom Commandbar, dropdown vs combobox
  387. Lookup in External document
  388. Pivot Table Calculation
  389. Office Clipboard empties itself when enabling/disabling commandbars
  390. Convert name into email address?
  391. IF Statement with Dates.
  392. Validation code when using File + Send to
  393. IF function for two columns in diffent cases
  394. Merged Cells
  395. Remove Sharing Code Error
  396. Lookup and Sum
  397. Creating a Variable Range
  398. Selecting last sheet in workbook
  399. Problem entering data in hidden cell, via macro
  400. Macro to change chart references
  401. Save Current Workbook
  402. Print row repeated on selected pages
  403. Sum of a column if some rows contain #n/a
  404. printing a quotation mark in a text file
  405. Select top 10 in a list
  406. Excel 2007 - cannot get worksheet change macro to work
  407. Menu Selection as an Event
  408. Deleting Column Based On Header
  409. Paste Special a string value
  410. Referencing cell numbers in a formula
  411. REpeating Values
  412. Control tab order of unlocked cells on a sheet
  413. Multiple cells to listbox
  414. Custom commandbar, submenu questions
  415. Search Spreadsheet add to list
  416. Help figuring out chart design
  417. Workbook_BeforeSave behaviour
  418. SendKeys "%{F11}", True
  419. Urgent - running time error type mismatch
  420. delimiter sign in csv files
  421. Effect of "Save As..." in making VBA code work, or not
  422. How to highlight a Formularised Row
  423. Comment or not
  424. Cells.Find bug that's very strange
  425. Problem with excel macro - getting automation error - URGENT
  426. APPLICATION OR USER DEFINED ERROR
  427. Trouble saving xlsm worbook in Excel 2007
  428. replace unicode characters
  429. Pivot tables field grouping
  430. how to hyperlink to different files as per my choice from a list
  431. Offset question
  432. programatically inserting a control within a frame
  433. Adding text to an Activecell
  434. Entering a certain text automatically
  435. remove selection from listbox.
  436. BUG in excel iteration system? Very simple illustrative example: can you replicate?
  437. run time error 13 type mismatch
  438. Automatically running an Excel macro on open once only
  439. Automatically running an Excel macro on open once only
  440. Automating weeky copy / paste
  441. UDT copying a array to worksheet
  442. Search Results to Listbox
  443. Search Results to Listbox
  444. FileDialog Question
  445. Setting up Excel (2003) to handle users with different editing abilities
  446. C++ code
  447. copy/paste
  448. Slow Print out of the last of 3 pages in this macro any ideas????? Need Help
  449. Inserting or Deleting Rows
  450. Automatic Serialization and print
  451. Userform moves when hidden and shown again.
  452. Compare two lists for matches
  453. Fill Blank Cells With Text Value
  454. import data after last line of data
  455. Select and Run
  456. Please help debug this code!
  457. Newb VBA sub...
  458. Conditional formula
  459. Excel 2007 "Tables" Reference with oledb?
  460. What am I doing wrong?
  461. Activate a template file
  462. Macro designed to send mails via Outlook : question on certificate
  463. Loop, reading registry settings
  464. consolidate Sheets
  465. Excel Rows
  466. Delete a Range After Paste Special
  467. Export options
  468. how do i automate parsing a workbook
  469. Creating "mega formulas" - help me test macro?
  470. Was ok in 2003 not in 2007
  471. Checking color of conditionally formatted cell
  472. Macro to assign cell values as folder name
  473. Question on MS Office "certificate for VBA projects"
  474. column returning null values
  475. Why doesn't Workbook.Save work?
  476. how do i fill cells with random color?
  477. SQL string-how to reference cell/range
  478. Border around range working -Border for cells within range not wor
  479. Open workbook from code without running macros
  480. Open workbook from code without running macros
  481. Skip or Ignore Missing Worksheets
  482. How to load values to a form combo box
  483. text parsing_table creation for single column
  484. Help getting multible subs to work together
  485. Search with multiple results on different lines same column
  486. Need help with Vlookup with and IF statements
  487. How can I prevent #NA in Lookup
  488. reduce calculation time
  489. Copying, Pasting and Saving as (delimted.txt) on seperate sheets
  490. Problem with Loop
  491. add a calendar control in Excel form
  492. Syntax error
  493. Cells.Find Bug that's very strange
  494. mspview.exe
  495. Complex strings break 'Evaluate' UDF
  496. Workday fxn not recognizing Sat/Sun/Holiday start
  497. Track changes in cells.
  498. change font color for cells starting with "T "
  499. Copy Selection - Paste Selection - Delete Selection
  500. Macro Question. Is refresh needed?
  501. RE: Sumif not equal to
  502. Excel VBA Programming
  503. Arranging Pivot Table data
  504. Set formula as variable w/o "=" sign
  505. Advanced "Conditional" formatting which changes by cell selection
  506. Named range in chart - any way to change the workbook reference with VBA
  507. Deleting an ambiguous shape name
  508. Delete a chart
  509. Emailing with Lotus Notes to multiple, user entered, recipients
  510. Complex SUMIF
  511. nested formula alternative
  512. Reference... AddFromGuid
  513. How do I add info to "Change Tracking" comment box (blue triangle)
  514. Odd behavior
  515. WorkbookBeforeSave different actions on exit
  516. How do I Track Changes on Multi-Cell Targets?
  517. How to display Excel 2002+ "Find & Replace" dialog via VBA
  518. how to get vba to display excel 2002+ "Find & Replace" dialog
  519. Should Be Empty Cells
  520. "Debug" not available
  521. Open workbook to specific worksheet
  522. Combobox number formats
  523. Clear Cells and Worksheet_Change Q
  524. Hotfix for Office Excel 2007 (KB943075)
  525. Copy & rename a sheet appending 01,02,03 ..etc
  526. reading longvarchar(484), data always empty in Excel
  527. HELP!!! using full hyperlink filepath within VBA/API
  528. Retrieving data over a network
  529. 2-byte characters: from VBA code to a worksheet; in MsgBox prompts
  530. delete sheet in shared workbook
  531. How to run 2 CreateEventProc modules on 2 sheets simultaneously
  532. Identify last row of record in a pipe-delimited text file
  533. how to lookup a value in a table
  534. Using a userform to enter data to specific cells...
  535. Input Box Question
  536. Custom chart types; Recorded macro acts strange
  537. Simplfying the Sort macro
  538. Automated Web Form throught Excel
  539. Automating via VBA - Delete "Corrupt" Excel Names
  540. Copy sheet from file to file
  541. Query Wizard - Table Options
  542. How do I set up connection between cell with consent and outlook?
  543. The Most Simple Question Ever
  544. ActiveSheet.Shapes macro
  545. Repeat Button
  546. getting table name from a text box query
  547. Running a gif in an html window
  548. Hiding Windows Start bar
  549. Issue
  550. Additems from one listbox with multiple columns to another
  551. Help with modifing code??
  552. Count of rows with nulls
  553. Declaring Offset as a variable
  554. themecolor, colorindex, color picker
  555. Append existing cell value
  556. Selecting varying length range
  557. Print Pages by Page Number
  558. Creating matrices and subsequently prosess those in a loop
  559. Web query and carriage returns
  560. How to trim cell information
  561. ISNA command in VBA
  562. ISNA command in VBA
  563. Find range for plotarea
  564. SYLK file format ?
  565. VBA Cell to TextBox
  566. Retrieve value from closed workbook without using recordsets
  567. Use Contents of Drop Down List
  568. Macro Help
  569. Worksheet_Calculate with no effect
  570. Commandbar dropdown vs combobox, how do I set values
  571. distinguishing filenames
  572. programatically deleted code still triggers macro warning
  573. Ron de Bruin
  574. Access query not returning results
  575. Commandbar works first pass, but not thereafter
  576. Importing data: OLE DB and data link properties dialog
  577. Data replacement
  578. Paste special macro
  579. ComboBox question??
  580. UDT in an Add-in
  581. Error trap only works once
  582. Printing a UserForm
  583. Can't wordwrap the contents of a text box
  584. Creating a unique list of Cost Codes in Col. A from all worksheets in all workbooks in folder X
  585. Get avoid of message
  586. Excel Conditional Formatting
  587. Verify selection of cells
  588. cutting entire rows based on conditions and moving to new tab
  589. Help! Jumping ListViews!
  590. Excel Performance
  591. Add Data Scaling in same chart
  592. Conditional formatting?
  593. is there an equivalent to windowsoff in Excel macros?
  594. Multi-Select List Box
  595. Find and copy range from one workbook to another
  596. How to prevent focus by clicking combo box ?
  597. Tooltip to Differernt Datapoints in Scatter Chart using OWC
  598. Workbook.Saved problem - bug or feature?
  599. Named array value in a string variable
  600. trapping Print events in VBA
  601. How to change the default directory
  602. Click on the Cancel button
  603. Slow Network
  604. Error in loading DLL message
  605. Insert picture, resize to specific width, keeping height proportio
  606. how to display answer as whole number and remainder
  607. Objects height and width scaled percentage placed in work sheet
  608. Stopping a macro
  609. help with macro to query data from DB
  610. How to open an Excel window hidden
  611. [VBA] loop, problem of 101'st iteration
  612. Find the actual date or higher one
  613. Open a workbook then goto a specific range
  614. VSTO, with Visual Studio Express Editions.
  615. Help creating a form that will pre-fill from another worksheet
  616. Userform Textbox
  617. Worksheet change doesn't look at code
  618. Com-AddIn for protection of VBA code
  619. Close Userform
  620. Close Userform
  621. Data Validation - lists if certain column is certain value
  622. One line query on for loop assignment
  623. Valid values to use in Names collection?
  624. Chart Size & Position
  625. Credit Card time to payoff and defered balance
  626. Verify Userform complete before close
  627. connect to Access 2007
  628. Specifying the Sheet
  629. Find Conditional Format Met
  630. Link textbox2 to textbox1 via a vlookup
  631. Havig a problem Syntaxing a range ?
  632. Filtering on dates
  633. InputBox Ypos Calculator, oct07
  634. How to find data in Sheet1 and list them in Sheet2
  635. Printer Problem
  636. Data Validation
  637. Help end the testing tedium please
  638. Time in Excel problem :(
  639. Charts still linked to old book.
  640. Selecting Values Based on Constraints
  641. ComboBox Question
  642. pivot....urgent
  643. Problem in Linking a software with VBA
  644. runtime error 1004: how can i use rows.
  645. runtime error 1004: how can i use rows.
  646. runtime error 1004: how can i use rows.
  647. Print worksheet but dont want two cells too print is it possible
  648. Looping through multiple listboxes
  649. UsedRange.Select - but is it?
  650. Selecting correct MS Outlook Object Library (repeat)
  651. SQL script to select another file in same folder
  652. Saving a Chart
  653. Undo VB macro action
  654. Add data to excel worksheets from text file
  655. UI controls change size when used
  656. Import data from multiple txt files into one xls file
  657. DLL that takes and returns ranges does not always work
  658. Problems with importing data from WEB
  659. Ignore Missing Worksheets
  660. backfill cells with macros
  661. Absolute verses Relative file path in SQL
  662. Activate ribbon tab via VBA
  663. Has file EVER been saved?
  664. FOR loop macro
  665. Macro to change directory based on cell content
  666. Change / Remove Border from ActiveCell
  667. Strange Type Mismatch Error #13
  668. Check an object reference
  669. Change Project Name
  670. Forms.HTML??
  671. ShowModal = False gives improper form paint
  672. Pivot table based on amount ranges.
  673. Lets try again code help
  674. Step through sheets, but exclude one
  675. user form for dates, used in variables
  676. Working with a template - referencing and activating
  677. SaveAs Method adding a large number of comma-delimited blank lines
  678. Working with Visual Basic Check bo contrls
  679. Attempting to use VBA to Ping within Excel...
  680. Vertical Page Break How To Change Help
  681. how to clear all unlocked cells except D4
  682. Range Usage
  683. Value Sheet
  684. BeforeSelectionChange
  685. Save File to specific place`
  686. FOR loop macro clarification
  687. "PasteSpecial method of Range class failed" when range Number of Rows > 2000
  688. shrink to fit expand
  689. Excel 2003 advanced programming
  690. Removing rows based on isDate
  691. Second Fractions
  692. get data from excel, paste to web page then run web page?
  693. Help with search and create code
  694. Access query feeding spreadsheet control in a user form
  695. Create new sheet with a macro
  696. Vlookup help
  697. Copy/Paste Formula
  698. Newbie question
  699. How to capture the Print button event
  700. Auto_open from Worksheet Object Code
  701. Macro to allow spell check with protect sheet
  702. CLOSE WORKBOOK FROM MENU WITH USERFORM
  703. Disbale button when worksheet protected
  704. Code Fails at this Line: .Refresh BackgroundQuery:=False
  705. Create an alphanumeric value
  706. Help needed... please (Copy Past Macro)
  707. Modal dialog delays ribbon update
  708. Zoom to fit Columns
  709. Watch Window
  710. Conditional Formatting Macro?
  711. Open hyperlinks when file is moved
  712. xl2002: Position Picture in SeriesCollection
  713. Add a row to the current Selection
  714. RGB fill colours
  715. URGENT LOOP ?
  716. How to create protected VBA project?
  717. Size chart to window
  718. Refresh Data if Access File has Password
  719. Access Reference
  720. Automatically Save a file on the Desktop
  721. Get Property value of class instance by passing string property name
  722. Solution on previous threat 17/10 about error 1004 while inserting HPageBreak by code
  723. Check if all values in a column is identical
  724. Used range and SQL query
  725. How to use ScrollColumn?
  726. Why does this hang up?
  727. VBA and find: "lookat"
  728. Proprogate column calculations from row1 to rownn
  729. VBA - JumpTo Specific Row
  730. How to add series to a chart using a macro
  731. asdoublevector() xlw (c++ )method
  732. VBA Broken in Excel 2007
  733. excel program to create and update soccer league table.
  734. Problem with ActiveX control
  735. How to force users out of edit mode?
  736. Divide the values of 2 integer variables?
  737. READ ONLY RECORD SETS
  738. Email tabs based on checkboxes
  739. User List Box - List from Hidden range - VBA worng
  740. Import External Data: Dynamic URL
  741. Listbox populating progmatically
  742. excel if Range a1>a2
  743. How to create an excel Pivottable-report from a dos command
  744. Pick List
  745. Re-run subroutine when pivot page field is changed
  746. Problem in exporting to csv
  747. Run Time Error 2147417848 - 80010108 method Copy of Object Range F
  748. Is transfer data from one Excel file to another possible?
  749. Importing mutiple tables with the same field names
  750. Hide Command button on close