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. UserForm Not Hiding
  2. Pivot Table Column Issue
  3. Select certain tabs using macro
  4. Conditional Formating
  5. Best Practices Question
  6. referring to increasing VBA variable name in loop
  7. Pasting lists into Forms
  8. Hide/Show column at run-time
  9. Using Data entered in Textboxes in a User Form to filter a workshe
  10. Get data from email attachments
  11. autocomplete method disables the copy function
  12. Vista and VB6 DLL
  13. Winform Exporting Data to Excel form Datagridview
  14. Filtering a numerical range
  15. Macro to change macro or module level const that is calculated
  16. Fast Filesearch
  17. Conditional Formatting with Dates
  18. Determine if clipboard is empty
  19. Restrict dialog box closing
  20. type mismatch error help
  21. delete data from excel without openning it
  22. SQL Sentence from Text File
  23. convert date as text to number
  24. Error every other run
  25. QueryTable Last Refresh Date?
  26. Find variable in Col B, Copy Paste Values in Cn:Tn to Row below
  27. Checking reference for named cells
  28. Concat a parameter into a vlookup?
  29. Exporting selected tabs multiple times to different file names
  30. Use column of data in query to SQL
  31. UserForm.Show error
  32. moving to the next line in the appropriate column using VBA code
  33. Copy tab ? times
  34. Edit Sheets in Excel Addin
  35. Automating creation of named ranges???
  36. Pivot Table question
  37. Inserting a picture that is embedded in an Access Report
  38. Automating the conversion of CSV files to XLSX files
  39. Output on .csv with 90 line limit
  40. Select Case
  41. Sounds
  42. Re: Removing Access External Data Queries from Excel
  43. Running macros in Excel 2007
  44. putting a picure
  45. Removing Access External Data Queries from Excel
  46. EOF general usage
  47. Add-In macro execution problem
  48. Delete Row if Value in Column L equals zero
  49. multiple if statement
  50. SplitVertical + C#
  51. resetting combo box to top line
  52. Row Insert Function
  53. New to Arrays, want to use them in user forms,
  54. Setting Print Area
  55. Identifying Beginning and Ending Rows in a Selected Range
  56. Invalid Procedure Call Or Argument with VBScript
  57. Replace Worksheet
  58. Why use Class Modules?
  59. Moving all the cell content
  60. Producing a login sheet for excel and a linking stock with an ordrpage.
  61. Calculate *without* updating external links
  62. I can't update external data sources using vba
  63. Capital letters in cells
  64. Saving an update file in same directory as older one
  65. how can i create a cell that will blink on/off on a true conditio.
  66. Find text from range and delete row
  67. Ignore case of text in code
  68. Refereing to a picture in a excel cell
  69. Selections fill a form
  70. Sum values in listbox
  71. REVERSE GEOCODE LOOKUP
  72. changing function keys in windows xp
  73. Macro opens files as it tries to access them !!!
  74. how to extend columns
  75. Minverse
  76. Forms Combo Box Listindex set to zero
  77. Alternating color row makes excel run very slow
  78. Help with array
  79. Delete Columns if value equals zero
  80. Need macros in file to be available, but don't want file to open
  81. Hide cell contents
  82. Single stepping gives different result
  83. Transferring my data from one workbook to another
  84. Updating total cells after column deletions.
  85. Find numeric characters found within cell text and convert tohyperlink
  86. Help with formula
  87. Help with formula
  88. Create Folders From Excel
  89. Calendar
  90. Paste-special values disabled
  91. Unlocked cells become locked on paste
  92. Problem with transfert between Sheets
  93. Check path and files
  94. Spell checking textbox on a userform
  95. Calendar Control Help
  96. E-mail if Cell B33 = Yes
  97. Updating Code when a row is inserted
  98. Scrolling error in listbox on Vista
  99. Checking for a picture
  100. Input box rounding
  101. Tweak to clear button code needed
  102. macro to convert string to dec
  103. Help with Macro
  104. Combo Box help
  105. Exporting Excel to acces
  106. User Forms in excel 2007
  107. Calling a Macro from another workbook
  108. Compare allowing variance
  109. Create a new Worksheet with a few Twists
  110. Comma in number in msgbox
  111. Grouping and Macros
  112. Automatic Open Created Spreadsheet
  113. Prevent PivotTable Overwrite Warning and Disallow Overwrite
  114. xlDialogOpen arguments
  115. Vba - conditional formating
  116. User Form
  117. Programmatically allowing user to select worksheet
  118. Command Button / Macro won't execute properly
  119. Automatic date formating
  120. Macros with Grouping
  121. Find and colour all cells with Validation
  122. Automatic date formating
  123. How to add a Macro (.bas file) in Excel?
  124. Is there a fuction that counts number of highlighted cells Excell
  125. Pause, print preview, resume macro
  126. Lost My Personal Macro Workbook - Thanks Ron de Bruin!
  127. Pivot Table via Macro
  128. Changing Path for SaveAs Functions
  129. Filter pivot table results without filtering in SQL query
  130. Email using Outlook
  131. System Error &H8007007E (-2147024770) The specified module could n
  132. CommandBarButtons not responding
  133. Excel Question
  134. drop-list with different colors for the same charachter
  135. Change LinkedCell with VBA
  136. How to Set datarange for pivot table?
  137. Turn off Auto-Converting entries
  138. Change CommandBarButton state not working
  139. messagebox macro
  140. hash value of range
  141. Opening form in VBA. No error,code just breaks.Works on other PCs!
  142. Problems with RefreshAll method
  143. LinkedCell problem
  144. Form In .xla file
  145. Custom tooll bars in excel 2007
  146. get the Alternative text of a pic.
  147. Command Button Naming
  148. Option box for running a macro
  149. Is there an If Or Then statement?
  150. Bitch Arabic
  151. Set Page Break Lines using VBA
  152. work from home jobs
  153. Cell index?
  154. Pivot Table help
  155. Printing according to computer
  156. Macros function sporadically
  157. How to create a trigger macro in Excel
  158. get from Excel 2003 add-in to Excel 2007 add-in
  159. Complete Excel VBA Reference
  160. Comparing pivot tables entries with data in another worksheet
  161. My Excel VBA form "Whites" out
  162. VBA to count rows from specific cell and insert rows
  163. Load a File Error 9
  164. Using "Paste" Method in VBA
  165. copying
  166. MyArray (ComboBox.ListCount-1) possible?
  167. Another to get hard returns in instead of: " & Chr(10) & "
  168. How to add total from alternate cells?
  169. Updating PivotTable SourceDate using VBA
  170. Save as problem for Excel 97/2000 (with VBA-protection in excel 20
  171. Positioning a comment
  172. Wildcard Character Placement in MS Query
  173. Mail Merge Question
  174. Delete Data from textboxes
  175. How do I insert blank cells with VBA?
  176. Using VBA to parse RTD objectdata
  177. Office 2007 compatible with Office 2000 macro programming
  178. assigning tasks to users
  179. Comparing Pivot table entries with cells in another worksheet
  180. Count backwards with a for next loop
  181. make buttons move when scrolling
  182. find multiple values code tweak
  183. invalid procedure call
  184. Enumerating the names of *subs* and *functions*
  185. how can I get the worksheet with the pivottable sourcedata whenworking with a pivotchart ?
  186. Concatenate a Const Name in Sub Routine
  187. how do i get get worksheet name for pivottable sourcedata whenworking on pivotchart
  188. Autofilling
  189. How do i restritict permission with IRM in Excel 2007?
  190. ThisWorkbook.Path & Windows Vista
  191. Filter on active cell
  192. Excel Add-In and Data cache
  193. Hide rows within a range IF...
  194. Change Rotation of category axis in XL 2007.
  195. Create a Clear button to clear unprotected cells
  196. Delete row if value does not exist
  197. Read and search
  198. Duplicate
  199. Using Graph properties in VBA
  200. Variable Issue
  201. Graphing
  202. comparing contents of worksheets
  203. How to protect excel workbook from macro starting from Developer - Code ribbon?
  204. "Protecting" VBA macro from source reading...
  205. adding cells to show in a text box
  206. Document Container in Excel
  207. Code to auto update a footer
  208. how to set workbook window active
  209. adding shapes to forms
  210. Lost My Personal Macro Workbook
  211. User Defined Function Opens Improperly - Round III
  212. How to code: If active cell is B1, goto H17 when enter pressed
  213. reutrn a value from a cell in each workbook filename from another
  214. reutrn a value from a cell in each workbook filename from another
  215. Hi, I am new and looking to hookup
  216. Add text to a cell that has a formula
  217. Find Method question...
  218. set cell value
  219. using textbox for cell values
  220. With excel 2003 could open .csv file but not in excel 2007.
  221. copy rows based on conditions and insert them into another sheet...
  222. activating the previous sheet
  223. How to force selection of all current text in textbox control onentry?
  224. Making list from varius data
  225. Cell value consistency/macro problem.
  226. file not found stumped
  227. Return a value programming
  228. Copy/Paste Values & Formats from each Sheet & Book in Folder A to B.
  229. User Defined Function Opens Improperly - Round II
  230. hi arrays again
  231. Print only down to last occupied row
  232. Complex numbers in excel
  233. Multiple search and copy
  234. search column for data
  235. Copy range from one workbook to another
  236. Temporary Internet Files
  237. error 5174 file could not be found
  238. Trouble Setting Up Graph With Scroll Bar
  239. Volatility, recalculation
  240. understanding the .FIND example
  241. Can you set up a "Return" key - like a typewriter?
  242. Find and Replace
  243. Fetching data from WCF/Web service?
  244. Capturing data from a form
  245. End a procedure from a different procedure
  246. Multiple sheet #REF
  247. =COUNTIF(A5:A51,"=D240:Q251") Why will the cell D220 not TOTAL
  248. How to do bit manipulation in VBA?
  249. User Defined Function Opens Improperly
  250. round time in column to nearest half hour
  251. How to disable certain code segment?
  252. Create image in Form 'on the fly'
  253. Autofilter-Filtered List Scan
  254. Vlookup with varing Column length
  255. Returning a qualified drop down list
  256. delete rows when finding certain content.
  257. Securing coded hyperlinks
  258. Exit Sub not exiting
  259. At a complete loss for lookup/delete...
  260. Long User Form Question.
  261. arrays
  262. Macro to have equal size charts and picture in MS Word
  263. Excel if and else statement
  264. head spinning loop...
  265. Preventing printing
  266. Custom sort with user form
  267. How can I attach a combobox to a cell and have it resize if the column width is alterd
  268. lookup information on separate sheets to delete
  269. loop through columns (using for-loop)
  270. Vlookup where value begins with
  271. Vlookup w/ #N/A suppression
  272. Combobox with current date
  273. Refresh Ext Date Range Query with workbook closed? (Exc2003)
  274. Newbie Excel Programming Question
  275. Finding text or part of a text inside the value cell
  276. Range as cell numbers
  277. test mark
  278. Can't activate an existing workbook
  279. Find the last hidden sheet
  280. Chart vs Sheet distinction
  281. fill in empty cells beneath filled ones
  282. Retrieve focus After Update
  283. Autopopulate via VBA
  284. Change Refedit control icon
  285. Tracking border event
  286. VBA modules protected by password
  287. Using the outcome of cell A in a formula in cell B as a worksheet
  288. Calling a procedure from another workbook
  289. Automatic distribution of raw data?
  290. Strange behaviour - very slow after filter
  291. VBA if loop
  292. Chart points ON/OFF help request
  293. Search gui
  294. alert if selection contains hidden rows
  295. About Promt Window
  296. Storing and retrieving 3-D arrays in/from workbook names
  297. counting through the alphabet that is above 702..
  298. Calendar Userform Problems
  299. VLookUp Syntax Error ?
  300. Controlling cursor w/ macro
  301. Button in Form
  302. excel
  303. Password prompt when closing Excel
  304. Dinamic Validations Lists
  305. INDIRECT and SUBSTITUTE
  306. vb6 vs vba question
  307. Pivot Table to count values
  308. Visual Basc window displays after unlocking the computer
  309. Excel-called Dotnet DLL is using wrong Framework
  310. Vlookup in different sheets and workbooks
  311. Excel 2000 User Forms & Macros - Will they work with Excel 2007
  312. Reference to Columns
  313. Short cut keys within excels VBA Forms
  314. VS2008, Excel Add-in, Problems with Reflection
  315. Call a sub procedure from another workbook
  316. Formula
  317. Referencing Active Sheet
  318. Excel Function Query
  319. merging cells
  320. Why would 1 excel PC understand chr(13) and anoughter wouldn't?
  321. data disappear after extracting from querytable
  322. Consolidation - including text consolidation
  323. Transporting Excel 97 Macros
  324. Is Workbook open without error
  325. Pictures runtime error using VBA
  326. move formatted cells
  327. Refresh table after code runs
  328. Compare columns
  329. Future of VBA?
  330. diff between used range row and lastrow
  331. How to add Menu Bar to User form
  332. How to paste a shape on a specific index in Excel 2007 worksheet
  333. Reference Outlook in VBA
  334. Library not registered Error Message
  335. Deleting content after the last data value in VB or Macro.
  336. ScrollArea : How I can do that
  337. How to populate a combobox based on selection from another combobo
  338. Query Table Deleted on Refresh
  339. remove sheet2 gray out
  340. Subscript out of range setting Workbooks.Item(bookname)
  341. Drag and Drop editing that does not change cell references
  342. Use a variable for a Form reference
  343. Paste value and Auto row increment
  344. Error LineStyle
  345. Select a sheet
  346. ActiveNext
  347. test file - is open?
  348. Rest execution of procedure's or macro's
  349. Call Excel Macro from Outlook
  350. How to know which cell caracters are underlined
  351. macro timing issue
  352. Sort issue
  353. recording macro for a formula
  354. type error
  355. How to match a text value to a number value?
  356. Last Active Sheet
  357. automtaically choose printer
  358. How to fix this erorr (Selected Collating sequence not support by theoperating system)
  359. How to fix this erorr (Selected Collating sequence not support by theoperating system)
  360. How may actionable items can you have under an ElseIf Statement
  361. Time multiplied by currancy rate
  362. input box to allow range OR strings
  363. .Parent.SaveAs Filename: Without Prompting To Replace File
  364. how do i ser up a repeatingh meeting in outlook
  365. Needing to compare worksheets
  366. Calling an Excel function from Delphi w/ OLE
  367. Saving HTML as Excell
  368. Date entry and format changing?
  369. can someone help me with code for tab/enter stops?
  370. Create Export CSV file From Worksheet
  371. Step through cells in a selected range
  372. Programmatically set checkbox values on worsheet
  373. Macro - Clear Borders
  374. Find the End of a Pivot table
  375. Advanced filtering of Union of named Ranges
  376. select range
  377. insert 24 hour clock worksheet
  378. Hide Totals in Pivot table
  379. elements in an array
  380. Auto IsError
  381. Copying a row to new sheet based on column value
  382. Page Setup not working in macro
  383. Dynamic graph
  384. Finding blank cell
  385. Fill Combo Box
  386. long memo access fields when loaded to excel 2003 with vb
  387. syntax error
  388. EXCEL CRASHES ON SECOND XLQUERY REFRESH
  389. Programatically Filter a protected shared worksheet
  390. Slow excel because of shapes?
  391. Need a macro to count number of occurrences
  392. Simulate a doubleclick on Internet trough VBA
  393. How to run a procedure from other Project
  394. rearrange Columns according to predefined order
  395. Project Planning using Excel
  396. posting code
  397. How to select Visible Cells range minus 2 rows (frozen panes)
  398. How to set up caption on a button at startup?
  399. Select range then name it
  400. 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
  401. How to resize worksheet
  402. Set variable to active cell address
  403. how to call a custom menubar item
  404. circular reference when using dynamic rage
  405. Microsoft.Office.Tools.Excel.ListObject
  406. How to pick the second largest value in a data set?
  407. Increasing Row Value
  408. Excel Link (MATLAB) help
  409. Scientific Notation problem
  410. SUMPRODUCT array formula
  411. My page settings changed and won't reset (print settings)
  412. Module Question
  413. Collate option unchecked in excel
  414. Convert and save a worksheet as a PDF file
  415. Windows Media Player - how to establish references?
  416. Invalid Procedure Call or Argument - Run-time error '5'
  417. CountIf cell value greater than 14
  418. Need furmula of R-squared by polynomial regression
  419. Return row
  420. Excel DCOM Identity
  421. UserForm_Initialize, how to exit sub based on condition?
  422. Using offset to select a range
  423. Constrain Excel Solver solutions to a list?
  424. Evaluate Method Returns Type Mismatch
  425. Evaluate Method Returns Type Mismatch
  426. Evaluate Method Returns Type Mismatch
  427. Excel macros - shared between different xls files?
  428. UserName Function: Not Working
  429. Converting Cell Values Through Automation
  430. How to automatically covert excel version by coding
  431. Match and copy rows from 2 sheets
  432. Sheet name from range
  433. OneColorGradient
  434. Update of UDF (User Defined Function)
  435. changing location of words either in word or excel
  436. Pivot Table via Macro
  437. VBA Help Naming Sheets
  438. Pictures.Insert not working correctly in excel 2008.
  439. ListBox Control
  440. Deleting Check Boxes Within a Range
  441. Help with nested IF statements
  442. Copy sheet with >255 chars per cell
  443. opening worksheet
  444. Corrupted sheet - What the cause?
  445. can you store macros on server?
  446. Chart Title Reverts Back To Previous Value
  447. Generating Passwords in Cells
  448. Automated Gradient Calculator Macro
  449. Creating Complex Functions in the Worksheet Formula Bar - THIS ISNUTS!
  450. how to name filename with date in macro
  451. Print Preview chart when chart is clicked request.
  452. Toggle Design Mode in Excel by AddIn
  453. referencing Solver.xlam vs. Solver.xla - 2007 vs. 2003
  454. How can I copy a linked excel doc including the source database
  455. VBA FOR SUBTOTAL
  456. OnTime Event Scheduled?
  457. Generating pairs from a given set
  458. Controling alignment in header
  459. If in Excrl not in VBA
  460. Chess!
  461. Open a file from vba code
  462. macro for copying background color
  463. Help me transfer values from sheet 1 to sheet 2
  464. Saving in csv file after removing unused cells
  465. How to select range like page setup
  466. StartFromScratch is bugging me
  467. Problem trying to use Excel objects in VS 2005 Express - Worksheet
  468. Assigning Tasks to another User does not seem to work
  469. IRM and Sorting
  470. How to Access a Range in Another Workbook
  471. Filter using Mid
  472. Formatting the background of unlocked cells
  473. if for merged cells
  474. dynamic range in a macro
  475. Create New Spread From Old Worksheet
  476. pivottable/pivotcache question
  477. select only where text exists
  478. Edit a Literal or Integer
  479. Macro Help - truncate text
  480. autorun macro from access
  481. Losing Named Range Definitions
  482. Max of 1 column for each unique entry in another column
  483. Open .net form from Excel VBA
  484. How do I export event dates into a calendar format?
  485. changing property of a box while using if/then statements
  486. 2007 Help
  487. Programmatically Restart Excel
  488. Conditional Cell Link in Spinner?
  489. protecting boarders
  490. Check if number already are in the sheet
  491. VBA Macro With User Protection Settings
  492. Deleteing cells
  493. Change the cell value based on changing date
  494. Detect existence of a sheet
  495. Using cell data to open other templates?
  496. How to create XLA?
  497. Custom property of a cell.....how?
  498. Date Sorting
  499. Cell range excluding blank returns
  500. Comparing Dates
  501. Assigning a macro to a button on a toolbar
  502. Phases of the moon
  503. Refreshing Pivot Tables
  504. comparing dates
  505. Pivot Table via Macro
  506. User form - Get record & Edit Data
  507. how to limit custom toolbar's display
  508. How do i translate figures in a cell to word in another cell?
  509. database formats
  510. copy and paste
  511. user form, field split???
  512. filling a row with data, depending on certain criteria
  513. Importing VBA file into Excel
  514. Test for record dates?
  515. Show Results in TextBoxes, ONLY if All TextBoxes have Data in them
  516. Refresh Data
  517. Test if entire row is selected
  518. Autofilter used with merged cells
  519. Tracking cell values...?
  520. Showing the same line when going to another sheet
  521. Programatically Filter a protected shared worksheet
  522. How to add New Module through coding
  523. Show progress of copying
  524. copying Excel file without opening file
  525. Excel converting dates to numbers.
  526. compare 2 xl sheet with same data
  527. IRM protect Excel-Addins programmatically
  528. IRM protect Excel-Addins programmatically
  529. Add-in memory leak
  530. Looking for someone
  531. Storing real time data into Sql Server
  532. Copy Worksheet Function
  533. Remove - "A program is trying to access e-mail addresses you..."
  534. Printing in miniature
  535. Events don't seem to trigger after deleting cell values
  536. Cell Visibility Algorithm
  537. Vlookup - Issue....
  538. Set range to value from another sheet
  539. assigning different background colours in a range
  540. Multipage dialogbox
  541. ParamArray debug anomaly
  542. Is there a way to add a timeout value to a line of code or functio
  543. Does nobody have an idea ?
  544. macro doesnt run
  545. Re: Re: Help, excel error 53 (loading userform) <== problem solved
  546. Maximum non-blank row in a specific range as a variable
  547. Using autofilter results
  548. Help, excel error 53 (loading userform)
  549. LinkSources full workbook path
  550. Write array from vb6 dll to a specified worksheet in Excel
  551. VBA code for expiry date
  552. VBA FOR expiry Date
  553. Copy Sheets to RAM and back
  554. Chess!
  555. VBA Code/Formula to generate list of rows
  556. Help
  557. PDF995 on NE00
  558. Need macro or programme
  559. Reading back a Read/Write Property
  560. Beginner macro programming question
  561. Userform, select entire field
  562. How to get count summary of number that corolates with a name?
  563. Format code returning error
  564. Excel 2007 for next loop bug
  565. What is the quickest way in Excel 2007 to export all modules?
  566. Limitation to Number Format in VLOOKUP?
  567. linking problem
  568. help for applying formula
  569. Reading a Range from a VB6 DLL
  570. Reference dynamic filename
  571. Reading a file
  572. Speed of fixed array versus dynamic array
  573. Convert to Number Issue
  574. How to create a To-do list in Excel20003
  575. forgot the password
  576. VBA look and Replace
  577. Backup routines
  578. How much slower is Excel VBA compared to Visual Basic .net?
  579. How to do it on excel?
  580. Printing contents of an array into a message box
  581. Text to Column with fixed width in VBA
  582. User Defined Types and Overloaded Operators
  583. Excel 2000 issue with ComboBox list entries disappearing
  584. On excel, can customer ID generate name address field?
  585. How to detect locked linked xls file ?
  586. what happens when this code is run?
  587. Update when worksheet close/delete
  588. Changing AutoSave location programmatically
  589. range not carrying over
  590. How to prevent vba code from running?
  591. Need Help - Small Macro
  592. "Add/Remove Rows Code" adds rows on grouped sheets, but won't remove rows.
  593. command button caption
  594. Searching external file for values
  595. If Cell is Null Enter Value of Cell Above
  596. Select range on a worksheet
  597. User Form List box, unique records listing
  598. Code to run Value of cell rather than the Formula
  599. using selected data from a pivot table to populate new list
  600. using selected data within a dropdown list to populate new list
  601. Button Problem
  602. Pivot Table help.
  603. VBA statement "scroll active cell to center"???
  604. Toolbar already exists, but where?
  605. Wrap not working
  606. Please help with my code
  607. Mandatory Cell
  608. disable a shape
  609. Error handling issue
  610. Modifying code to save data
  611. Error Handling Issues - Pls Help
  612. Initiate Macro via change in drop Down List
  613. Export from Access
  614. Search within a ComboBox list
  615. Declare Function for global use then call on change event
  616. Reusing Form Code
  617. Looping through
  618. Err 13 Cant find problem
  619. compare 2 x files with same colum labels but different aranged da
  620. Count Red Cells on a worksheet
  621. SourceData of a chart
  622. Numbering cells in a range
  623. How to get of all number rows in the autofilter range
  624. Accessing Excel worksheet names via ASP.Net 2.0
  625. Addin interference
  626. german text in english xls
  627. Loop and simple calculation
  628. time
  629. Problems with application.worksheetfunction.correl
  630. Error 13
  631. Calling Fourier plug-in from VBA
  632. User Defined Functions - Input prompts
  633. PivotTable VBA help needed
  634. check if values is already in listbox
  635. sending message
  636. Spreadsheet does not recognize my VBA function
  637. Merging data between worksheets using reference index?
  638. My Type Library is not complete
  639. Password Protection
  640. Sorting macro
  641. Remove VBE Component failed
  642. File Properties Location retrieve to refresh background query?
  643. Late Binding access reference in Excel Module
  644. Table ranges do not work in multilingual configurations
  645. Declaring a collection as a particular type of object or a particular class
  646. Data not recognized as a number
  647. clear contiguous fields with one keystroke
  648. Do Until Loop
  649. Find text then cut and paste it
  650. AutoRun
  651. Delete in different worksheets and workbooks
  652. VBA codes to get dates of files in a folder
  653. Deleteing columns starting at a certain row.
  654. Pictures on worksheet flickering as they are repainted
  655. Hide Code
  656. Rename Parent worksheet.name?
  657. How to move to next cell automatically no keystrokes?
  658. How to limit scrollable area
  659. Macro to Conditional Format if cell contains a word
  660. Userform Question
  661. Get data from Access tables in an Excel pivot table
  662. List box style
  663. String Compare... Tough one?
  664. Printing multiple embedded Word Documents
  665. Re: Insert Existing Data
  666. Macro type
  667. Change width of 51 Columns
  668. Hiding / unhiding rows based on change of a cell
  669. Please help with my code
  670. VBA can't remove drop shadows on bubble charts in Excel 2004 for Mac
  671. Textbox.Value as a new text file
  672. Using an Excel Spreadsheet as A Data source for Miscrosoft Query
  673. automatically sorting
  674. lock cells based on formula
  675. VBA Code Colors
  676. Linking Problem
  677. Excel 2003 DataForm
  678. How to activate a text box
  679. 91 object variable or with block variable not set
  680. On Change Search for Value
  681. Generate a combination list of values
  682. Identifying whether an excel file exists
  683. Data Selection for graph plotting
  684. Hiding Named ranges
  685. Imposing rights to excel add-in
  686. Email file properties via command button
  687. no calculation during readin large cols (Speed)
  688. Find last used row in a column (not in the whole worksheet)
  689. Re If statement....HELP!!!!
  690. Close workboook if it is open
  691. Create Summary then export
  692. Extracting data into a CSV file
  693. Using cell color in conditional format makes Excel unstable
  694. Formatted word file from an excel file???
  695. RTD Wrapper called for every cell in an array formula
  696. atm project
  697. textbox backgroundcolor
  698. Application.Enableevents = False doesn't stop all events?
  699. help on "scripting.filesystemobject"
  700. Refer to workbook
  701. [Automation] Why do my cells with formula appear as text?
  702. how to add a chart into different workbook using VBA
  703. Long Code
  704. ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
  705. ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
  706. Calculation Project Date skip Sun and Sat
  707. Evaluate Formula with Named Ranges does not work if Workbook isalready open
  708. Evaluate Formula with Named Ranges does not work if Workbook isalready open
  709. Evaluate Formula with Named Ranges does not work if Workbook isalready open
  710. RE: Insert Existing Data
  711. Return Largest Value in an Array
  712. Cut & Paste Excel Format & Values to New Folder in PdF
  713. Button Won't Work
  714. VBS Script and ClearContents -- Code Throws An Error
  715. Error 461-Method or data member not found
  716. Transfering spreadsheet data to a master spredsheet.
  717. Error testing combobox to variable
  718. store default printer, change printer and then restore default printer?
  719. Stubborn Excel Options
  720. VBA Automation advice
  721. Edit Query Window
  722. Change Font Properties causes Excel failure on Save
  723. Do Loop Goal Seek won't End Sub
  724. Copy userform
  725. Entering text in a Form
  726. wrap text with quotes ("")
  727. vlookup query - 2 parameter check....
  728. Best way to send disparate cells to database
  729. Protecting XLA
  730. Change workbook path in formula
  731. Apply footer code to all new workbooks
  732. Need to find and collect all cells with a certain word onto a shee
  733. ListView control in Excel 2007 jumps!
  734. Pulling Data from one sheet based on value of column
  735. chart and automation error
  736. SaveAs in xlNormal Format
  737. cell address of hyperlink
  738. PasteSpecial failure
  739. Enum Members Declaration
  740. How to update data in a Control ?
  741. How do I STOP excel from making a Backup"filename".XLK file
  742. Changing From: emailing with Excel...
  743. delete element is collection
  744. Conditional Data Validation
  745. Remove and Add Text to Numbers
  746. Worksheet saved out as new workbook
  747. Code to filter a database displays no rows at all
  748. How do I show a "list" in an "if" statement?
  749. key assignments
  750. custom menu disappears when I File, Exit, Cancel