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. Re: Excel crash
  2. Help needed - Strange hyperlink problem
  3. Re: Excel crash
  4. Re: Excel crash
  5. Check whether URL exists
  6. COUNT for 2 or MORE CONDITIONS
  7. Re: ActiveSheet.CodeName?
  8. activating windows
  9. [XL2003] get results from a subform back to the main form
  10. Using Consolidate Methode with a relative Range
  11. Formatting from CopyFromRecordset
  12. Re: ActiveSheet.CodeName?
  13. Summary View From Database
  14. Re: ActiveSheet.CodeName?
  15. Re: ActiveSheet.CodeName?
  16. Summary View From Database
  17. Re: Excel 2003/vbx macro errors.
  18. Re: Excel 2003/vbx macro errors.
  19. need help creating a Batch-File
  20. Check boxes
  21. VB Printing problem
  22. number seperator by coma
  23. Macro to Convert Value to Number, Sort, then Delete
  24. sumproduct error
  25. open workbook in new window using VBA
  26. open workbook in new window using VBA
  27. Re: Determine which user has write access to a file?
  28. Check for the existence of data labels
  29. Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts
  30. Need help with Lotus Notes Automation!!!
  31. More Formula Help
  32. Re: Using Excel to search Word documents?
  33. Re: Double click message on userform....
  34. Pivot table - show monthly data based on start/end date data
  35. Hide Sheets to Left Q
  36. Refreshing NON-embedded External Data Connections
  37. Name Range Help
  38. Removing Dashes in Excel
  39. Re: different value for setting with breakpoint vs regular running code
  40. Re: Refresh a local web page via Excel
  41. Help with excel VBA
  42. different value for setting with breakpoint vs regular running code
  43. Drawing a line for a set range
  44. Get line no from right click menu ("Cell")
  45. Re: Explicit declaration of variables
  46. Explicit declaration of variables
  47. Cutting row data and pasting into next available row on different tab
  48. Re: Rick Rothstein
  49. Save Array in memory
  50. = cell above last entered data
  51. Conditional formating via VB
  52. Sending an Outlook Template from buttons on Excel sheet
  53. Where was I before pressing enter/return or tab key
  54. Pivot Table in a sheet
  55. Pivot Table - charts - default ?
  56. Creating named ranges automatically
  57. Data validation, mandatory and restricted field length for excel vbs
  58. Delete Rows with Conditions
  59. Two column deletion
  60. Pivot tables - refresh.
  61. amend row height on all sheets
  62. Excel 2003 VBE - Inside function, cursor over variable name does notdisplay contents
  63. html output to file *.xls - how to stop date formatting <td>01-01</td>
  64. Help With Input Box
  65. Re: Delete all drawings/shapes except DownArrows
  66. Problema Copia ed Incolla
  67. Run macro from email
  68. Macro to Delete multiple/duplicated lines
  69. Pixels counting !
  70. Algorithm of GROWTH function
  71. Remove Duplicates
  72. Counting used cells on sheet
  73. Save a userform that has been created programmatically at runtime?
  74. ONLINE CODING COMPETITION
  75. Look Up 2 Values, Match 2 Values Different Tab Return 3rd Value
  76. VBA macro
  77. Re: 2D array of strings problem
  78. Re: 2D array of strings problem
  79. Count days between two dates excluding weekends
  80. Sumproduct not counting if the formula result is zero
  81. GoTo Sheet reference
  82. Export Sheet Values to new workbook
  83. excel macro
  84. Strange behavior
  85. Auto filter "ALL"
  86. Calendar object
  87. Subtotal Sidebar query
  88. User form: select all text on text field entry not working
  89. replace 29 february with 28 february with vba
  90. new xlsm & VBA problem
  91. visual basic editor automatically opens up
  92. Please let me know the error in this code
  93. Problem with deleting blank rows or last row
  94. MVP's Where Are Thou?
  95. Code runs different on different machines
  96. Excel 2010 code wont copy/paste to values
  97. Excel Ribbon
  98. Problem transferring VBA code w/ ProcOfLine & ProcBodyLine to VB.NET
  99. Getting the caption from a HTMLSubmit button
  100. Set Active Cell to A1 on Open Q
  101. Display a StockChart In UserForm
  102. Re: Listbox problem
  103. lookup values from tabdeliminated text file
  104. Import a comma delimited file & match records
  105. Use VB to unlock & lock cell protection
  106. Re: Pass "array of strings" into a function??
  107. Setting range by cells fails
  108. How can delete file by Marco
  109. vba dynamic
  110. Can you call a Color by # in Excel?
  111. password protect individual sheets
  112. Help please!
  113. recognizing conditional formatting with VBA
  114. Is there a limit to how far autocomplete will match user input?
  115. Count cells with content in different color background
  116. Rounding Time down
  117. Copying date if 'date' matches with the reference
  118. Sticky filepaths at Assign Macro step
  119. Error message Macro cannot be found
  120. transpose
  121. Re: Refresh a local web page
  122. Hyperlink - default font size and colour.
  123. Converting weekly price data into daily (5 days of the week) format
  124. How can I know whether an excel sheet is running in a PC or Mac environment?
  125. The Road- Matching data within a range of values
  126. How to imitate VLOOKUP with DAX?
  127. Transpose
  128. Paste cross section of 3D array in one step
  129. HELP
  130. Why no intellisense for ActiveSheet
  131. better way to copy cells
  132. Re: getting data from web
  133. getting data from web
  134. Last used cell in column
  135. Automating producing PDF of my Excel reports
  136. Changing default "Group dates in the Auto Filter menu"
  137. Clear cells
  138. Usenet group message fonts
  139. ADODB
  140. Note related background color of a cell
  141. Locking and Unlocking Cells via VBA
  142. cut/paste columns efficiency
  143. Re: Toggling navigating between 3 cells?
  144. Re: Toggling navigating between 3 cells?
  145. Data Form
  146. How to extract data from an array
  147. Select and sum all numbered cells in Column A
  148. today's date static
  149. Input box display
  150. Matching cells
  151. Cells with same contents
  152. Cells with same contents
  153. Cells with the same contents
  154. conditional formating
  155. search and replace loop problem
  156. Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another cell?
  157. [VBA] How to convert an Excel woorkbook completely from Excel 2003to Excel 2007?
  158. New Google Groups
  159. Finding matching cells
  160. file extension shows up twice on attachment
  161. Cell change WB1 -> textbox WB2
  162. Add-Ins: remote macro updates
  163. little help
  164. Clicking cells - run VBA
  165. Copying all whilst Range Forbidden active
  166. Macro to update other local macros
  167. Copy cell change to other workbook
  168. Re: Prorating an amount
  169. Prorating an amount
  170. Prorate amount
  171. Can't Open Text File From Website in Excel 2010
  172. Prorating an amount
  173. Property of a cell with a string
  174. Changing the worksheet scrollbar increment
  175. File size grows 10-Fold after changing VB Code
  176. Concatenating Cells
  177. Usin OpenDiagBox to set ActiveWorkbook Name
  178. excel isObject or collection exists
  179. Who is linking to my file? And what files am I linking to?
  180. ODBC QueryTable Location (Cell address)
  181. Show/Hide Minimize/Maximize Button in Excel 2007/2010
  182. Conditionally copy cell from one column to another VBA
  183. Programmatically set UID & PWD in existing ODBC DSN connection string.
  184. Context Menu 2007/2010
  185. Combine multiple worksheets in one Workbook into one big worksheet
  186. Borders around cells with data in them
  187. SQL Syntax
  188. xlDialogWorkbookMove crashing Excel
  189. Update Pivot Table Filters based on a Cell Value in Excel 2007
  190. ODBC Query
  191. range name define on non active(focused) sheet
  192. disappearing procedure
  193. Re: Sum formula in E5, add in same cell formula for gain/loss?
  194. Re: Sum formula in E5, add in same cell formula for gain/loss?
  195. Active cell is to jump from one cell to another when conditions are met
  196. CRC32 checksums with Excel VB
  197. Re: Best way to result more than 1 result?
  198. Printing Setup help
  199. passing values from form to module
  200. Re: Adding another column
  201. How to Remove Code
  202. xl2010 and UserForm
  203. problems with "CurDir"
  204. problems with "CurDir"
  205. Sum a range of cells based on relative position
  206. regex validate rangename
  207. Center across selection
  208. Cell alignment
  209. For Next with negative step ?
  210. Macro to compare and copy ranges of cells
  211. Data Validation when entering hours over 24
  212. UPDATE Query
  213. Getting in xcel in 1 cell txt valua based on number in other cell
  214. Re: Magic Excel function or UDF?
  215. Placing commadbutton
  216. PageSetup doesn't work
  217. Carriage return in a cell
  218. Carriage return in a cell
  219. Carriage return in cell
  220. CurDir, ChDrive, ChDir error questions
  221. Re: User Defined Function being called by changes to an independent workbook
  222. User Defined Function being called by changes to an independent workbook
  223. Hiding row ?
  224. Shadows
  225. Re: UDF to merge duplicate rows
  226. Printing problem
  227. Re: UDF to merge duplicate rows
  228. Re: UDF to merge duplicate rows
  229. Re: Magic Excel function or UDF?
  230. Re: Magic Excel function or UDF?
  231. Re: Magic Excel function or UDF?
  232. Re: Magic Excel function or UDF?
  233. Re: Magic Excel function or UDF?
  234. Return a string based on which Textbox is clicked
  235. Re: Magic Excel function or UDF?
  236. Unwanted chart plot area resized when .Axes(xlValue).MinimumScale = "-0.1"
  237. VBA error while using SQL "with rollup"
  238. testing ADO recordset for PrimaryKeys
  239. compare and color cells with similar values in a column using vba
  240. Excel Userform
  241. Re: Re-enter space in a cell if user accidently deletes it
  242. Superimpose an XY Scatter chart over a Background image.
  243. Re: Re-enter space in a cell if user accidently deletes it
  244. Need help with Concatenate function
  245. range values into list via c#
  246. Accelerator or Access Key
  247. Error Control - null rnage
  248. Show file properties when file opened
  249. Is there such an Excel Function?
  250. Excel to Access
  251. IE Automation
  252. Checking if a font is installed (2007)
  253. Calendar control in 2010
  254. Copy tab from one spreadsheet to multiple tabs in another spreadsheetwhile retaining the targets spreadsheets tab names
  255. wrap text in merge cells
  256. function with more functionality then typical UDFs?
  257. Help Needed, May have bitten off more than I can chew
  258. Efficient Excel to Access uploads
  259. print 2 sheets on one paper
  260. Re: Code after the "Unload Me" call?
  261. Clipboard macro seriously locks up (or whatever it does) myclipboard! [XL2003]
  262. How to access certain website log in with user name and password andclick certain button?
  263. Shading pivot table based on value in 1st column
  264. Personal Macro Book and VBE showing
  265. Changing File "Summary" Properties Programmatically
  266. Single key press date input
  267. Application.StartupPath not set in Excel 2007
  268. Re: Migration to Excel:Mac 2011, but what about the VBA projects?
  269. Re: Another textbox question
  270. Re: Another textbox question
  271. Moving extra characters to a new column
  272. Sumproduct instead of SumifS in VBA (application.sumproduct)
  273. Re: Test for string of space chars?
  274. Web based newsgroup needed
  275. Re: Extract text from a "textbox"
  276. Re: Extract text from a "textbox"
  277. my latest C++ excel OLE automation code
  278. Re: Calculate if 2 times differ by 24 hours?
  279. Re: Calculate if 2 times differ by 24 hours?
  280. Puzzling printarea code
  281. Re: Assign subroutine to a key press??
  282. Re: Range("a21") .end(xlDown) or .end(xlUp) . offset(1,0) . value
  283. How to implement mySum(Sheet1:Sheet3!B1)?
  284. Range("a21") .end(xlDown) or .end(xlUp) . offset(1,0) . value
  285. Need Clarification
  286. before save event
  287. Re: List of data?
  288. Re: Let a user choose a folder?
  289. Problem using a named range
  290. Conditional formatting not working with AND
  291. Need a macro to alert me when the value of a formula in another sheet changes
  292. Renaming cell contents
  293. Copying a range
  294. Excel -- Cutting and Pasting Certain Values from a Column to another Sheet?
  295. How to do double quotes in "cell language"?
  296. Class Module Question
  297. Incorporating feature of second macro into first?
  298. Launching Windows Search application from Excel macro
  299. Return Value of GetOpenFilename, Excel 2007
  300. Record Click on Error Indicator
  301. web automation - repost
  302. Point and Figure Excel Sheet Program
  303. ++ Web automation
  304. Calculating Costs for Each period
  305. Calculating Costs for Each period
  306. Copying and Deleting Range using buttons on worksheet
  307. Code in Excel 2000 template doesn't work in Excel 2010
  308. Can't Reference from Webserver
  309. changing the controls for a userform
  310. Drop Down Menu link to Pivot
  311. Help with Index formula
  312. Simple Macro
  313. Evaluate does not work
  314. Why do I have to restart Excel when ActiveSheet.QueryTables.Addfails? Options
  315. Fractions in a userform.
  316. Find all in vba
  317. Can I automate Range.mergeCells = True?
  318. Re: Save a bakup file when opening the file
  319. Re: Capitlize a column?
  320. Re: Capitlize a column?
  321. Formatting date as first letter of day only
  322. Problem with the VBA / Excel interface
  323. Worksheets
  324. Comparing Similarity of Strings and Returning Best Match
  325. How to: copy value from active sheet to all other sheets with VBA (in desired cell)
  326. Copying Range but Font not Copied..
  327. Importing URL into Cell in Excel
  328. Re: Can Excel do 'lookups' and show different data depending upon thecell with the focus?
  329. Data Table Issues
  330. Re: C#NET2008 Excel Merge Cell Problem
  331. Re: C#NET2008 Excel Merge Cell Problem
  332. Declaring variables programmatically
  333. Conditional copy and row insert based on criteria
  334. Excel, Python, Linux
  335. Compating all rows in two sheets
  336. Get results from Access Database.
  337. inserting trademark in excel 2003
  338. Select Previously Selected worksheet (and/or select previouslyselected workbook)
  339. What If a Table has a Million Rows?!
  340. How to group my students using Excel
  341. Range reference in array formula
  342. Silverlight
  343. running macro from keystrokes versus from ribbon
  344. Excel hangs
  345. Excel VBA Training Courses
  346. Re: Times before noon show different
  347. Re: Times before noon show different
  348. linking data
  349. Looping through Non contiguous cells in a row
  350. Re: Change Cell Background
  351. Change Cell Background
  352. Re: Change Cell Background
  353. Run a recorde macro in multiple excel workbook at a time
  354. Problem with file path to sharepoint
  355. Insert Excel Data in Oracle
  356. Excel Database Readability in Linux?
  357. Conditional borders
  358. Microsoft Internet Controls
  359. trend data, with twist
  360. Updateing file links
  361. What does " " turn the cell?
  362. Help with text file
  363. Does M.S. Project have to be installed in order to use the ProjectObject Reference within Excel to grab read-only data from .mpp file?
  364. Conflicting functions
  365. VBA to write Excel data to Oracle table
  366. Average/Sum formula with offset
  367. issue embedding 2003 xls vba objects with powerpoint 2010
  368. Capitalise on Input Q
  369. Anyone speak Japanese excel?
  370. MS Excel VBA Interview Questions & Answers
  371. From 2 predefined test data ranges, how do I detect which one has a anon linear trend through Excel VBA ?
  372. Do Until - If-then problem
  373. Problem using Range objects
  374. Can't create a new instance of the Range class
  375. Sum Dynamic Range
  376. Recognize currency in a cell
  377. Find item in column Copy to new location
  378. macro listing subfolders from selection of mainfolders
  379. Trying to print specific worksheet from outlook attachment
  380. variants and freeing bstr memory (C++)
  381. Excel 2010 crashes on Workbooks.Open for csv file -- sometimes
  382. DLL not available in system32 folder - vista/excel 2007
  383. Web Automation, Form Filling, Web Scraping with Excel
  384. VBA Save As problem with file that already exist
  385. Pasting to a new page on existing sheet if not enough rows on the page
  386. Attach to RTD communication (.NET)
  387. Manipulating embedded excel charts in Word
  388. Frames Scroll event causing cursor to move to first textbox
  389. Populate list or combo box from closed workbook
  390. Simple userform tutorial
  391. Creating UserControl with VB6 for excel
  392. Existing sheet formatting removed when changing active cell border color
  393. custom function - finding cell address
  394. ListBox Remove Certain Text
  395. how to store a macro to be available to all workbooks
  396. block of quoted lines
  397. How to change active cell border color in Excel 2007
  398. Remove Blank values
  399. SHRINK/REDUCE EXCEL FILE SIZE
  400. Multiply Corresponding Values in Range
  401. Convert Excel IF ISERROR formula to VBA
  402. Save dialog box
  403. Differences among VBA in Excel 2007 and 2010
  404. Subtotal by VBA
  405. Finding the maximum in an array of strings (Excel VBA)
  406. combo box - last value
  407. Using Collection to also capture range adjacent
  408. Formula problem
  409. Why do I have to restart Excel when ActiveSheet.QueryTables.Add fails?
  410. Excel 2010 Component Id
  411. Excel 2010 Component Id
  412. Excel 2010 Component Id
  413. Delete Entire Column
  414. Summing Criteria with Index - Match
  415. PasteExcelTable does not work in OS X
  416. Drop down list - link to another worksheet
  417. Filter with an IF, AND, NOT formula
  418. Emulating Ref Edit in VB6
  419. referring to texbox
  420. VBA date conversion
  421. Solution for Application.FileSearch Excel 2007-2010
  422. VBA form imported into VB6 project
  423. INDIRECT Syntax
  424. Merging Multiple Named Ranges
  425. Macro errors when upgrading to windows 7
  426. Macro question: Using named ranges
  427. SofTeC 2010: Calling all Testing Professionals, Managers, Leaders[Nov 20th, Pune]
  428. Beforeprint not executing
  429. Save dialog box
  430. Run-time error '381'; on Listbox remove item - (Please Help)
  431. How to Schedule a VBA Macro?
  432. Save box / file name
  433. Prevent Coping/Transffering item twice from Listbox1 to Listbox2
  434. CheckIBAN
  435. HELP - Radio buttons and other controls suddenly moving in Excel 2010 only
  436. SofTeC 2010: Calling all Testing Professionals, Managers, Leaders[Nov 20th, Pune]
  437. Listbox
  438. special characters, other multi-language gotchas?
  439. Save data to closed workbook
  440. workbook open password protected
  441. Password protected sheet
  442. Calling subroutine defined in another workbook (autostart workbook)
  443. controls and dynamic events
  444. controls and dynamic events
  445. CSV decoding line-by-line
  446. How can I transfer information from Excel to Outlook?
  447. Subscript out of range
  448. SUMIF with the criteria range
  449. Data Table
  450. noob problem - Conditional hiding.
  451. Inserting 2 columns when cells don't match
  452. make a named range with an array not using a workseet cell range
  453. make a named range with an array not using a workseet cell range
  454. make a named range with an array not using a workseet cell range
  455. make a named range with an array not using a workseet cell range
  456. make a named range with an array not using a workseet cell range
  457. make a named range with an array not using a workseet cell range
  458. make a named range with an array not using a workseet cell range
  459. make a named range with an array not using a workseet cell range
  460. make a named range with an array not using a workseet cell range
  461. make a named range with an array not using a workseet cell range
  462. make a named range with an array not using a workseet cell range
  463. make a named range with an array not using a workseet cell range
  464. .find does not find if .NumberFormat = "#,##0.00"
  465. Move Column Values to Rows - THANKS in Advance
  466. Cleanup this macro please
  467. Lookup?
  468. Make this into a toggle command? [XL2003]
  469. Howto populate a column with values coming from another sheet
  470. Combining Procedures into Loop
  471. closing a vba project - dumb question
  472. Export to txt file using VBA
  473. Using VBA to move system files
  474. Set macro security level to 'low level' on opening a certain workbook.
  475. Automatically select entire rows on pressing down and up-arrow key
  476. Code Snippet - Activate VBE window
  477. Problems automating Word from Excel
  478. Chartspace & Excel2003
  479. Protect each worksheet individually
  480. membercode check
  481. Re: Pivot Table problem
  482. Save All Worksheets as CSV
  483. Association between cells
  484. Delete duplicate rows
  485. loop using double
  486. Why you should change your vehicle to flex fuel
  487. How to embed INDIRECT.EXT into workbook Excel 2007
  488. On Error Resume Next not working (2010)
  489. Delete duplicates based on time
  490. How to separate on very long line of code in VBA
  491. User input into cell formula?
  492. Which zones are touch given this range
  493. Help with pseudocode translated into VBA Code
  494. Excel VBA Multipage
  495. Option buttons not responding
  496. ProgressBar control in 64-bit Excel
  497. How to use MS Flex Grid in Excel vba form
  498. ResetAllPageBreaks
  499. issues with getting .pdfs to be created
  500. Ensuring Macros Are Enabled
  501. Is there a better way?
  502. How do I view/edit code on Excel 2003 Worksheet Command Button
  503. conditional sum
  504. Why would End(XLup) stop working??
  505. OPEN EXCEL - Needs your support and enthusiasm...
  506. Timing Macros
  507. paste value column based on first cell command button
  508. How to Reference a VSTO AddIn
  509. Intersect and Union
  510. Multiple Conditions - VBA
  511. Read smarttag value
  512. Comment Box Placement
  513. How to copy one worksheet vith command button???
  514. macro using forms button
  515. Non Uniform Random Number Generator
  516. Re: Application.dialogs and PDF - again
  517. VB coding for complete cell copy rather than what ^C does?
  518. non-repeating Comboboxes values
  519. class module and encapsulation
  520. Re: Application.dialogs and PDF - again
  521. Re: Application.dialogs and PDF - again
  522. Can you change the font and font size for a forms control ?
  523. Can you change the font and font size for a forms control ?
  524. selecting a range
  525. copy and paste 3 rows run macro and continue to end of columns
  526. Test if a user defined chart name is valid
  527. Import CSV Data from Outlook Public Folder
  528. End(xlDown) giving me blanks
  529. End(xlDown) giving me blanks
  530. Re: Formatting currency with the cents but without the decimal point
  531. What is the difference between 'Select' a sheet and 'Activate' a sheet
  532. Wanted: Business end of Excel
  533. Populating 2-D array w/ Application.[Function] results
  534. VBA vs C#: filling a spreadsheet with random numbers - C# 4x slower...
  535. Placing picture with code
  536. Delete Rows as per Text, Font Color, Font Type, Time Format
  537. RDBMerge ADD-IN
  538. Setting a cell's color based upon RGB values
  539. Text box value to userform
  540. loop
  541. Seconds missing from time/date properties
  542. Userform Save data To Worksheet & File
  543. Events
  544. What happened here...?
  545. Filter, Delete and Error handling - need help
  546. Pick from drop-down list gives empty or erroneous result
  547. Sort current range by column j
  548. Change DeleteValue1 to named range
  549. Help with DoEvents to show progress form, please?
  550. How can I sum two arrays together?
  551. VBScript help
  552. Remove cell from range
  553. Go to next row depending every nth iteration
  554. Run-time-error 1004 "ListIndex method of listbox class failed"
  555. What is the new object name after copying & inserting line?
  556. Conditional Formatting
  557. Macro to modify property of an object
  558. Match and Range Reference Syntax
  559. Re: In Excel 2007 where is the Personal workbook saved?
  560. Hierarchy of Codename and error catching if no worksheet.
  561. .Lookin through Outlook
  562. Mistery Link
  563. Pickup Data from a Worksheet
  564. VBA editor doesn't prompt to save changes, doesn't save
  565. Why is my .Findnext not working?
  566. Best way to run Find or Vlookup down specific column in range
  567. Kind of a "reverse" Vlookup; or please help me use Find instead
  568. Kind of a "reverse" Vlookup; or please help me use Find instead
  569. Index and Match - Errors
  570. help with sumif formula
  571. interior colored cells counting
  572. VBA handle on a C# ribbon
  573. Format Telephone Numbers
  574. Re: Automation and XLL add-ins
  575. Re: Automation and XLL add-ins
  576. Re: Automation and XLL add-ins
  577. Re: Automation and XLL add-ins
  578. Add a sub folder
  579. increase / decrease font size based on value in cell having a formula
  580. Even procedure in xla
  581. save worksheet data to alternate closed workbook - next row
  582. Referring to ranges as Cell, Range, and variables
  583. Using a function to return a populated array
  584. Define a Range based on a Range object
  585. copy/paste records into different sheets by status
  586. Search Target <= in Col. "B" to return Date in Col. "A"
  587. Search Target <= in Col. "B" to return Date in Col. "A"
  588. Referring to Range addresses when in variables
  589. Worksheet_SelectionChange Not Firing
  590. Populating one sheet with specific data from another sheet (I'm dumb)
  591. Excel prompts for VBApassword after saving workbook under new name and exiting excel
  592. CommandButtons moves to another place in office 2010
  593. Loop don't work
  594. Change definite value to string reference for criteria
  595. compare named ranges and list duplicates
  596. Date format.
  597. Insert rows in grouped sheets
  598. activesheet.name ending in "-" &Style1
  599. Counting and deleting duplicate rows
  600. Strange pasting array to cells behavior
  601. Quarterly Analysis in Excel
  602. Highlight row and insert text on click
  603. How to build a bulletproof application Using excel
  604. Open File in Skydrive through VBA
  605. VBA to Extract time that user logged onto Windows
  606. Semi Autofilter code
  607. Convert Conditional Formatting to Conventional Formatting
  608. Set range, perform operation, set new range, repeat
  609. Code help
  610. How to get the available languages (MUI) of Excel using VBA?
  611. Using VBA to close a running application
  612. Excel 2003 autofiltering options from a userform
  613. How to structure specific macro task, oop or procedural approach?(Excel 2003)
  614. Limit range of values for integer
  615. How to deploy my new addin
  616. Personal Macro Book
  617. Working with moving dynamic ranges
  618. parse csv file contents into powerpoint textbox Autoshapes
  619. scrolling 2 frames simultaneously
  620. cell comments, hiding columns, "Cannot shift objects off sheet"
  621. Code deletes first row/headers.
  622. Create new worksheet and use a number as its name..
  623. Re: Totals rows shouldn't become invisible when filtering
  624. Dynamic Names
  625. Re: Totals rows shouldn't become invisible when filtering
  626. Payment Coupons
  627. Personal Macro Book
  628. Total by Invoice Number
  629. Vlookup using array ?
  630. Dynamic Names
  631. Re: Totals rows shouldn't become invisible when filtering
  632. 2007 Table
  633. Use VBA to Populate Listbox from Open Spreadsheet
  634. On-screen buttons turn to white
  635. loop through class module
  636. Import Excel to Access (used range only)
  637. Apply Alternate Shading to selected rows
  638. Excel model - Very fast first time - Very slow second time
  639. Find a date in list less or equal than target date
  640. Duplicate Entries
  641. Find Running Total Value or % at a given Target Date or vice versa
  642. Range object causing Sort to fail
  643. Re: How to change a device name into a resource name and v.v.
  644. using two cell references to make up the save as file name
  645. Stopping a macro to edit the template then re-saving the macro for use
  646. Stopping a macro to edit the template then re-saving the macro for use
  647. password protection
  648. Picture on comment
  649. Generate Subtotal Summary from Sheet1 into Sheet2
  650. Saving templete / workbook to a specific drive / file...trying again
  651. Change file name when saved to C drive
  652. save as cell A1 to to a specific drive
  653. Conditional formating question
  654. Can I do automation on Access if the database is open?
  655. UTF-8 File Opened in Excel from Firefox Browser
  656. Sorting columns horizontally
  657. Copy/Transpose into a matrix of merged cells. Use Offset formula orVBA ?
  658. Re: Help with Excel VBA code
  659. Copying used range from other sheets ignoring row 1
  660. Automatically copy files into folders
  661. Re: Help with Excel VBA code
  662. Re: Help with VBA code
  663. count dates
  664. PERSONAL.XLSB will not load
  665. Mail Multiple Sheets via PDF Q
  666. Running a Macro periodically between Time A and Time B
  667. Referring to control value on form using variable name for control
  668. Saving templete / workbook to a specific drive / file
  669. Sorting problem : "The sort reference is not valid..........."
  670. #VALUE
  671. Re: ADO question
  672. Auto select worksheets - and goto a specific cell afterwards
  673. Charts.add or ActiveSheet.ChartObjects.Add doesn't work
  674. Group rows based on indention of string in a column
  675. MS Excel/VBA Macros Training for professionals in Chennai
  676. Convert dates
  677. Comparing dates
  678. VBA Public Function - Excel to PPT Stacked Chart, How to Remove Legends
  679. Add-in question: can I store default values for a form in the Add-in?
  680. Remove a criteria from countif based on user selection
  681. Re: ADO connection to a protected workbook?
  682. How to "freeze" all cells in Excel sheets?
  683. counting a specific "text" occurance in a selection of sheets withina workbook
  684. Re: Restore a range of cells to "empty"?
  685. MACRO to paste row into next empty row
  686. Macros I want dont appear in the customise box to drag to a toolbar
  687. group of worksheets in a workbook
  688. group of worksheets in a workbook
  689. countif - in an entire workbook
  690. Re: ADO connection to Excel 2007 *.xlsx files?
  691. Re: Using an ADODB.Recordset in Excel 2007
  692. find
  693. MS Excel VBA Copy and Paste from external workbook data to central worksheet
  694. Re: IBAN Number
  695. converting excel VBA macros to VB
  696. Excel 2007 Ribbon Will Not Re-Validate Unless Excel Window Has Focus
  697. Can I import 2003 .xlb definitions into 2010?
  698. Re: Searching a group of Excel workbooks.....
  699. How to import events VBA code in Excel?
  700. EXCEL 2003 file doesn't update certain cells
  701. Re: Searching a group of Excel workbooks.....
  702. Transpose & reorg data from 2 WS to new WB
  703. Re: Any way to know when my worksheets get opened at remote location?
  704. Change Pivot Table Filter Based on Cell Value
  705. How to program with this problem
  706. How to compare two spreadsheets
  707. How to get a MsgBox to pop up if I have VBA write a wrong link
  708. ThisWorkbook.Close crashing Excel (2010)
  709. writing macro to match the group and age
  710. Good way to open a .txt file, copy/paste all text into Excel?
  711. Excel reporting
  712. Expose Function Fieldnames to VBA
  713. chart objects top
  714. countif and vlookup
  715. Help with code restricting TextBox entry
  716. Filter between Dates
  717. Resetting autofilters
  718. Programatic access to VB-editor not trusted
  719. Substituting zero values in blank cells
  720. ActiveX Properties missing from menu
  721. Excel 2003 VBA In directory Open Spreadsheets Extract data
  722. Re: Strange CopyRange behaviour
  723. Spreadsheet object in VBE appears with the ThisWorkbook icon
  724. Re: Strange CopyRange behaviour
  725. sheet cycle macro
  726. Conditional Formatting Weirdness
  727. Require user to enter numeric value in TextBox
  728. MsgBox problem
  729. Retrieve Excel Colors
  730. DropDown List (Validation) from other worksheet
  731. Start Time to End Time... Minutes On Each Hour... How to distribute proportionately?
  732. Allow text in locked cells on a worksheet from a userform
  733. Option button enabled when tabbed to - how?
  734. SUMIF and SUMIFS Error
  735. Excel 97 Mouse scroll-wheel stops working after run macro- edited
  736. Adding a row with the previous one if....
  737. Macro to line up rows
  738. Mouse scroll-wheel stops working after run macro
  739. Pass xlworksheetId to VBA
  740. *Click And Fill Form Instant Get $3000
  741. Properly Saving a .CSV File With an 11 Digit Numeric Field
  742. How to extract & save an image from an object?
  743. From WebPageA to WebPageB: Error . . . windows opener document isnull or is not an object
  744. Why Insulation is a Good Investment
  745. copy text from textbox to another application
  746. Data Validation issue with two date entries Options
  747. ++outlook automation
  748. +++Outlook Automation
  749. PageSetup - Speeding up - Code snippet Requested
  750. Randomizer Modification Help.......