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. Number Of Cells Between Colored Cells?
  2. is there a way to control the sheet name you add
  3. Re: Date Format - simple question
  4. Beginner - Click a checkbox then calculation to be done automatically
  5. How to write a VBA program to load the webpages automatically
  6. Vertical line on Excel chart
  7. Copy Range of data using VBA
  8. Calculating occupational sick pay entitlement
  9. Create COM add-in using VBA
  10. How to get a macro to run on all files in a folder and save each one?
  11. naming ranges in Excel2007 using VBA
  12. Excel SQL VBA Command Reference.
  13. Re: Seperating Information In an Excel Sheet
  14. Custom function for vlookup
  15. Re: Increment Cell Value +1 with a macro
  16. macro
  17. paste special in this vba code?
  18. Re: Formulas that update other formula columns?
  19. Re: Problem with relative reference.
  20. Re: VBA-copy all worksheets except three specific ones
  21. Re: VBA-copy all worksheets except three specific ones
  22. Re: A simple printing pages depending on cell value
  23. How to copy multiple objects from Excel to PowerPoint
  24. including macro in protected worksheet
  25. Ensuring Combobox has Value entered if another ComboBox has aspecific value
  26. Re: Range With Variables
  27. Re: Easy answers for anyone
  28. Re: VBA find
  29. Saving in VBA to a particular location
  30. VB If statement Help
  31. QueryTables, some basic questions
  32. Re: If Cell Contains Partial Text String Copy Entire Row to Another Spreadsheet
  33. Re: hide rows in workbook
  34. Number displayed as text difficulties
  35. Help with macro lsit
  36. Determine name of macro contained in each excel file in a folder
  37. Re: VBA loop to create named .csv files for all worksheets and workbooks in a folder
  38. manipulating drawing objects in MS Office 2007
  39. Re: Excel Form
  40. 64-bit ADODB in Excel
  41. Add incremental character to cell value at change in value 449becomes 449-A 510 becomes 510-B
  42. Printing to pdf
  43. Run-time Error '1004': Selection is too large.
  44. VBA Project Password Changed on its own?!?!
  45. Macro required
  46. Re: Find name of 'My computer'?
  47. Why do charts disappear?
  48. Paste Excel Chart into Existing Powerpoint Chart
  49. Listbox populated based on Combobox
  50. Code to delete names works in one WB, but not another WB?
  51. Delete range names within a selection
  52. Row and column count last occupied cells in range
  53. Re: UserForm Image
  54. Re: Help to get data from excel 2003 worksheet into Visual Basic 6
  55. How to return the machine name?
  56. macro to show / hide grouping, linked to label button
  57. Re: paste if columns and rows are the same
  58. How to arrange columns
  59. Re: paste if columns and rows are the same
  60. Workbooks.Open always have
  61. Enter data in cell referenced in a cell
  62. Re: UpperCase changes date format
  63. Re: Macro to send an email automatically
  64. Save PERSONAL.xls into Excel 2007 PERSONAL.xlsm
  65. Finding and Replacing Sheet Names
  66. Re: Transport macro
  67. Re: Macro code to reference a cell for a date parameter when pulling data
  68. Re: Find, Copy files and Paste in new destination
  69. Convert text to values
  70. Conditional Formatting in Excel 2010 is being removed when I emailExcel Workbook
  71. Gather Data from Multiple Sheets
  72. conditionally format based on intersheet cell comparisons
  73. searchbox in excel sheet
  74. Re: Save as (filename,fileformat) from Word VBA will not work
  75. Stock expiry projection - Help-
  76. Stock expiry projection
  77. Have Excel 2007. I would like to have a spreadsheet perform thefollowing simple? tasks
  78. Re: conditional formating in adjacent cells
  79. Link certain cells to 2 photos each
  80. Count occurances in a range.
  81. Re: VBA help please
  82. VBA Insert Into Specific Cell
  83. Ms Excel 2010 problem with coping
  84. Re: Invalid name?!?
  85. Functions - visibility
  86. Re: Invalid name?!?
  87. how to use a variable in this line
  88. Embedded charts with events not working?
  89. VBA.Interaction.Shell ("msg.exe") = Run-time error '53': File Not found
  90. "Errored" Cells in Data
  91. Re: Extract each line of text from a textbox into an array
  92. Re: Run time error
  93. Attached Workbook with Autocomplete Combobox
  94. set/get value of checkbox (controltoolbox)
  95. Automplete Combobox with Dynamic Lists
  96. Using Excel 2007 with Excel 2003 template
  97. Todays date minus 1
  98. Writing code to objects within MultiPage object
  99. Re: inventory problem
  100. Identify adjacency cells with same value
  101. VBA vlookup enter data into one textbox have another auto fill
  102. easiest way to find next non blank row
  103. Linking cells, with values and formats: VBA
  104. XLL ('C' extension) question
  105. display a file in excel by using vba
  106. Re: can I use IF statement to call a VBA function ?
  107. Re: can I use IF statement to call a VBA function ?
  108. Ghost excel process
  109. Re: excel if condition or vba
  110. ThisWorkbook.Unprotect ("password") depends on Service Pack??
  111. Dynamically Adding Labels to a Userform
  112. Re: Cell Required before Closing
  113. Insert Value into cell automatically when new rows are created/inserted
  114. Delete 1st character if string is longer than 6 characters
  115. Copy item from Outlook to folder via Excel
  116. formula or macro in excel, to open another excel sheet?
  117. add a chart in a Add-In
  118. Changing pivot table ADO recordset
  119. Reference Separate Sheet for Formula
  120. Help with Evaluate/Eval
  121. Status bar in Excel 2010
  122. count duplicates
  123. Cut and paste with a combobox
  124. Re: Email validation?
  125. Select Picture from Data validation dropdown menu
  126. Re: ReturnBoolean???
  127. Do not undesratnd the error when calling EXcel macro from .vbs script
  128. Re: working on another excel sheet with an excel macro running
  129. Re: working on another excel sheet with an excel macro running
  130. Re: working on another excel sheet with an excel macro running
  131. Re: Help with VBA Macro needed
  132. Re: Returning two similar values from two different columns
  133. Data Validation
  134. append multiple worksheets data into a single multi-dimensional array
  135. Launching form blocks cell selection
  136. Status Bar text
  137. corrupt file plus 8 digit temp
  138. temp 8 digit file, original corrupt
  139. Re: Web page on the fly
  140. Re: Creating a Macro
  141. Re: Creating a Macro
  142. Re: Move rows to another worksheet with vba
  143. Excel formula for counting nr records with data and related empty fields
  144. FSO copy file returns permission denied
  145. copy paste problem
  146. case question
  147. long to wide transformation with of panel data with many variables
  148. Re: [Excel 2010] how to get a horizontal scroll bar form control
  149. SUMPRODUCT with 3 critearia not adding up correctly
  150. Re: Macro - Delete Rows with specific text
  151. Re: Add checkboxes programaticly
  152. Track Changes Question
  153. Conditional mandatory fielld ?
  154. Tab character in a Text Box
  155. How to add a calendar object to Excel 2010?
  156. Creating a formula in VBA with quoted strings
  157. Sorting Columns with a Formula
  158. How to Select A Cell in VBA with a Variable Row Number?
  159. How to Select A Cell in VBA with a Variable Row Number?
  160. Re: How to Activate Filter in Protected Sheet
  161. Macro shortcuts are running macros in different open workbook
  162. LOGEST,LINEST,?POWEST
  163. Combobox selection
  164. Rows To Columns & Hyperlink to Email Address
  165. How do you chart data from multiple sheets within a workbook?
  166. How to chart data from multiple sheets in Workbook
  167. Re: Create formulas using multiple pop-up input boxes?
  168. How to match and compare multi-columns datas
  169. Re: How do I copy several rows from one sheet to another?
  170. Lookup a value between 2 dates
  171. Lookup beween 2 dates
  172. How write into text file at first and last line with excel vba?
  173. How to activate Sheet2?
  174. Lookup a price that was valid at a certain date
  175. Excel and the Math Coprocessor for DLLs
  176. Excel chart, set a vertical baseline on a certain date
  177. producing a list from a programme
  178. show formulas
  179. Combobox Population
  180. Check if Excel workbook is open via Word VBA, if open how to close it?
  181. how to design spreadsheets to collect data and display the totalmaterial used in a plating department
  182. philosophical question about programming best practices
  183. ActiveSheet in formula
  184. Run Time Error "13" on For Each loop
  185. comment on "NEW" google group layout
  186. Application.Selection.Name gives "=Sheet3!$A$1"; I want the name
  187. system error &H 80010105 The server threw an exception
  188. Big dataset - batch process
  189. concatenate a range of data
  190. Adding A1:A7, then A8:A14
  191. Ribbon issue 2010
  192. Re: Rows right click menu?
  193. Array of Controls??
  194. Excel is messing with the math coprocessor
  195. excel 2010 classic look no ribbon
  196. Sumif similar to Countif??
  197. selecting a range
  198. Excel 2010 Windows.Activate name issue
  199. Re: Need to find a static value in a cell and then subtract from adjacent cell
  200. multiply array with a transposed array - EASY FOR EXPERTS!!!
  201. Use external file variable in formula
  202. Creating a defined name's Refersto range
  203. Application.Rows
  204. RAND() function error? ##
  205. help with generating a percentage value
  206. Select random records by two conditions
  207. Loop from left to the right
  208. question about the Marco inputbox.
  209. checking data in the A column
  210. Re: help with VBA
  211. Re: help with VBA
  212. No data from another macro in another module
  213. Two types of textbox input
  214. VBA comparing sheets and cells
  215. entering value without acivating sheet
  216. Copying a Name's Contents
  217. works in 2007 but not in 2010
  218. Re: Macro For Saving Worksheet to Word Document with A1 as filename
  219. Another For each headache I get
  220. LoadPicture workaround for Excel 2011 VBA for Mac
  221. Setting name value across workbooks
  222. File permission problem
  223. Re: Macro edit to add before contents to the new row
  224. Re: lock cell
  225. Re: lock cell
  226. Re: Macro For Saving Worksheet to Word Document with A1 as filename
  227. Pivot grand total
  228. Re: scrollbar hide
  229. IF find "Refund Needed" text, then copy rows into another Sheet
  230. Is there an easier way
  231. Re: hide coloumn
  232. Re: scrollbar hide
  233. Re: scroll window
  234. Re: freezepane set macro
  235. Cannot Shift Objects Off Sheet
  236. Copy ranges from several sheets to another one in a vertical position
  237. Re: scroll area
  238. Getting filename data
  239. Need help in converting text string based date to excel date format
  240. Formula appearing as Value in Formula Bar
  241. Excel 2007 Error: File not Found: VBA5.DLL
  242. Broken Hyperlinks
  243. Scatter Plot Question - adding straight lines
  244. Look for an efficient way to handle array formula with VBA
  245. Re: condition for run macro
  246. Re: condition for run macro
  247. Changelog
  248. Re: VBA - function doesn't calculate unless clicked on
  249. Re: VBA-User says active cell jumps to a different sheet upon Save.Please review my code
  250. Macro to assess
  251. Macro to assess
  252. Re: hide menu bar
  253. I have Matt's problem below. What is the fix - reply in a new messageheader please!
  254. I only see message headers using firefox? Explain the way out just inthe header please!
  255. Need VBA solution to find 1st and 2nd occurrences of non- zero, thenreturn column header value
  256. Run Macro Upon Entering Data into Cell/s
  257. On Entering Data in On Cell Enter a Formula in Another
  258. Why I cannot read this site
  259. VBA pagebreak question!
  260. Deleting near-duplicate records that differ only by blanks
  261. Macro to create log file
  262. VB Send Mail using Thunderbird
  263. Re: two list box
  264. Re: how to make sure two numbers are identical
  265. Re: how to make sure two numbers are identical
  266. Re: macro for enable capslock
  267. how to make sure two numbers are identical
  268. Order Automatically
  269. Assign Selection to a Variable
  270. Open Workbook Question
  271. Re: Auto add if condition is met
  272. sum visible amounts
  273. For Each Next
  274. Re: Survey Form as a Project
  275. Dim problems
  276. stacked bar chart - problem adjusting bar width - Excel 2007
  277. Broken hyperlinks in excel 2007
  278. Re: Gather multiple keyword and separate them to categories
  279. Conditional formatting
  280. Conditional formatting
  281. Conditional Formatting and VBA
  282. Pivot Tables - Filtering on summed values
  283. Assembling large "array"
  284. Populating a range of empty cells with usernames
  285. Change SourceName on Pivot Table
  286. iserror function
  287. Strange behaviour
  288. Re: VBA - Insert row, copy contents of original row except forcontents of columns A-N
  289. Re: VBA - Insert row, copy contents of original row except forcontents of columns A-N
  290. HTML string not formatting when copied into sheet
  291. how to find a last value in a column in excel
  292. Row Count...
  293. Re: VBA - Insert row, copy contents of original row except forcontents of column A
  294. Re: VBA - Insert row, copy contents of original row except for contents of column A
  295. Need urgent help
  296. XLM file and mac
  297. Lose macros before saving
  298. searching for text within shapes
  299. Need subtotals
  300. Need subtotals
  301. Email individual sheets from an excel file
  302. Re: disable shortcut key sheet tab
  303. Re: macro for sheet hide
  304. Re: lock keyborad & mouse
  305. Re: macro for sheet hide
  306. Re: lock keyborad & mouse
  307. Re: macro hide
  308. Don't want to hard-code file name in macro
  309. Formula or code?
  310. Re: select picture with list
  311. Formula or VB?
  312. Re: restriction for delete or change in cell
  313. Re: Macro for solver on certain worksheets
  314. Excel formula to count the number of records which contains a certaintext (wildcard)
  315. Re: Macro to add comments from cell values
  316. Re. Conditional formating of adjacent cells but down a column
  317. Get name of user who has a file open or checked out from a Sharepoint
  318. Re: How do I choose the rows that are filtered ?
  319. Re: 1st macro run then 2 macro is run
  320. Re: macro to select worksheet
  321. Re: How to Copy excel formulas from one excel to other
  322. Re: macro to select worksheet
  323. Re: How to Copy excel formulas from one excel to other
  324. Macro needs updated Range name addresses
  325. Cell Selection Control
  326. Excel 2003 VBA help problem
  327. Application.top=0 fails
  328. A little help needed please...
  329. Problem with FTP commands in Win7+Excel2010 (VBA)
  330. Conditional formatting with vba
  331. Pivot table drill down sort
  332. Handling hhmmss time format
  333. Problem with UserForm1.Show
  334. VBA password prompt workaround
  335. how to get the vba code behind an excel sheet
  336. Need warning message before a user changes worksheet
  337. Excel Graphs : Images in X-Axis
  338. create chart with column axis
  339. Retrieve NTFS security groups from network folder
  340. Exporting data with vba from Excel to an Access 2007 db with password
  341. Re: when sheet is active macro is run
  342. Re: macro for right click
  343. Calculating subtotals
  344. Calculating subtotals
  345. Problems with If function
  346. Hiding a column if a cell has an X
  347. Re: Rename 'VBAProject"
  348. Re: Date reference to another cell
  349. Re: Macro to search a text in a cell and copy the row to another setof cell
  350. VBA Conditional formating for specific text in several columns
  351. Remove data from column
  352. Re: Rename 'VBAProject"
  353. assigning a variable from an image alt text
  354. Re: password for macro
  355. Re: password for macro
  356. Pivot Table Macro with dynamic source data
  357. Excel Template Question...
  358. Chart Title color can't be duplicated (also series color)
  359. Excel macro for general insurance tracking
  360. Check each sheet for Auto-filtering and switch it off
  361. Need help with a simple macro, really lost.
  362. Identifying Machine or Location When a Procedure is Run
  363. Re: How to convert text file into excel using macro vba
  364. Re: How to convert text file into excel using macro vba
  365. Enable Slicer Data Refresh in Locked S/S
  366. Re: hide menu bar
  367. Re: active range to run macro
  368. Re: Separating fields
  369. Re: active range to run macro
  370. Converting macros from Excel 2003 to Excel 2010 - Client Access dialog
  371. FileSystemObject
  372. Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names
  373. Only cells with values
  374. Re: active cell to run macro
  375. Re: active cell to run macro
  376. Capture Web Page Source Code
  377. Where are all you MVPs hanging out now??? Pls?
  378. range names
  379. How To Make Pictures Scrol in Text Frame
  380. Re: data labels in excel using vba
  381. Re: data labels in excel using vba
  382. Excel module: Mark records if it contains names out of another list
  383. How to export excel sheet to CSV
  384. How to append data from different sheet and different workbook?
  385. Re: Problems with Activeworkbook.Close
  386. Can't delete sheets
  387. Re: Determine the percentage of a range of cells with a certain value
  388. Re: Separating fields
  389. Re: Copy data from a cell to the next available cell in a range.
  390. Re: Determine the percentage of a range of cells with a certain value
  391. Re: adding vlookup into Macro and table_array is different every week.
  392. Option Button in Excel 2007 and 2010
  393. Print macro using xlDialogPrinterSetup fails to use driver-specific settings
  394. Hidden sheet bleeds through
  395. Excel 2011 Mac - Import Worksheets into a Single File
  396. Ideas?
  397. Conversion from Number to Word!! Aki
  398. Move multiple values in single Cell To Cells of there own?
  399. Scrolling few Pictures at a time in a Frame
  400. forwards/backward compatibility Excel 2003-2007
  401. Re: Create Table with the range of selected cells
  402. Re: Create Table with the range of selected cells
  403. Re: UDF: More than one input type?
  404. Re: select worksheet and run macro
  405. Re: select worksheet and run macro
  406. Re: Create Table with the range of selected cells
  407. Re: UDF: More than one input type?
  408. excel 2003 vs 2007 menu and sheet issues
  409. Re: Create Table with the range of selected cells
  410. Re: Create Table with the range of selected cells
  411. Passing SQLPlus script location using Windows Script Host Object Model
  412. Application.Wait
  413. FIND ALL
  414. Re: Create Table with the range of selected cells
  415. Arrays and Checkboxes
  416. Macro to complete Google search based on a cell?
  417. Shared folder changed path - sometimes S://SharedFolder sometimes T://SharedFolder
  418. Open folder based on cell value
  419. run macro on close
  420. Blank item in listbox, how to remove
  421. Faster way to find and replace?
  422. copy and paste data only to a new file
  423. Formula in other Other Language
  424. Add to Dynamic Named Range
  425. VB.Net ToString Number Format
  426. Re: Having Trouble Getting My Userform to Populate the Corresponding Excel Spreadsheet...
  427. Conditional formatting excluding weekends and holidays
  428. Re: Filter ZIP codes into ranges
  429. Addin not allowing thisworkbook.save in before save event
  430. Re: Filter ZIP codes into ranges
  431. Highlight or Mark any values in a column that are duplicates insidethe column
  432. Pivot table code question
  433. How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook
  434. Would love to write macro to delete any row that DOESN'T containspecific text..
  435. Sorting columns of data
  436. [Q] For, Next - How to Speed Up
  437. Inserting subtotals very slow
  438. Buttons not always moving deleting rows. Odd behavior
  439. excel spreadsheet functions written in vba
  440. Error: Method 'open' of object 'IXMLHTTPRequest' failed
  441. 3 results possible on every day. add up the number of each on each day.
  442. Advance Filter Format
  443. User Defined Function
  444. Copy Matching Numbers To New Cell's
  445. Populating a listbox from an excel column
  446. Aligning related data
  447. how to work with all items in a listbox
  448. How to create a table of multiple combination
  449. =Sumproduct Question
  450. Optimize Slow VBA Code
  451. Sorting Question
  452. Combine Two Different Worksheet_Change codes
  453. New line vs line break
  454. Hiding an Excel file using VBA
  455. Re: Hide/shows raw based on drop down menue
  456. how to export pat_ids to another programme?
  457. Re: Hide/shows raw based on drop down menue
  458. excel 2010 statistical functions
  459. Excel question
  460. initiate a macro
  461. vlookup issue
  462. Managing Cut/Copy & Paste During Program Run
  463. Re: Function for combinations
  464. Re: Function for combinations
  465. Newline character in XML cell reference when creating xlsx from XMLzipped files
  466. Re: Using median if in VBA. Excel. 3 conditions stop running?
  467. Re: Help adding a condition to a print code
  468. Find matches in 2 cols using Collection vs Dictionary
  469. Variable Range, selecting/copying
  470. User defined function
  471. =Trend question
  472. Which Excel event to call when opening a .txt file
  473. Sumproduct Problem
  474. How to bypass password when pasting FROM a protected workbook
  475. '.Copy Destination:=' temporarily freezes multiple instances in Excel 2010
  476. Issue with TextFrame2: Library not found
  477. Delete matching cells
  478. Two digit dates and two digit days
  479. Is it possible to add variables to a pivot datafield name?
  480. Need help with merging Excel worksheets and deleting unwanted columns
  481. Loop & Print
  482. Replacing a hardcoded date
  483. How to pause without being "modal"
  484. Run time error 50290 method 'ontime' of object '_application' failed
  485. Changing mutiple data fields at the same time
  486. Re: Duplicate declaration in scope
  487. Re: Duplicate declaration in scope
  488. [Q] How to create new worksheets based on an array (via named range)
  489. Is it possible to just act on the filtered data
  490. Fade text in a cell, disappeared when we input new text.
  491. Find then highlight in yellow
  492. Re: Data validation trouble
  493. Technique for switching to the VBE
  494. Search function in Excel
  495. Copy sum of two columns from one workbook to one column in another
  496. Filling in some blanks to a data table
  497. Looping through checkboxes
  498. Removing Sequential Numbers
  499. My code need to go on a diet
  500. Get Data set range from closed workbook
  501. Error bar format
  502. Trying to create a mailing list using a combination of data and anaddress list.
  503. Sumproduct with double quoted strings
  504. Reuse old selfcerts (self certificates)?
  505. Transfer selfcerts to new machine?
  506. Extract Records via Userform
  507. List of Direct and Indirect Reports
  508. [Q] How to sort tabs in order of CodeName
  509. setting folders in odc file
  510. Loop has goofy message all of a sudden
  511. Functions not firing!
  512. Re: NFL spreadsheet
  513. Wrong import values from webquerry
  514. Seaching an excel sheet
  515. Duplicate Digits
  516. Re: NFL spreadsheet
  517. Counting rows
  518. Counting rows
  519. Can I send an email too?
  520. move cells up
  521. Copy data - Multiple Word Pages to Excel
  522. manipulate other program using excel macro
  523. Enhancing Explorer Excel Open Icon limitation
  524. Distributed excel apps with add-ins
  525. Break points will be ignored in Excel
  526. MAX and Min value
  527. PivotItem Visible prop
  528. MOVE CELLS DOWN
  529. =TEXT fuction
  530. Retrieve data from encrypted Access
  531. Excel automation fail
  532. Calendar Control for All Office versions - including Office 2010 64 bit
  533. CheckOut/CheckIn from/to SharePoint 2010
  534. Multiple (as in many) regressions
  535. HELP...auto-alphabetizing in excel 2007
  536. Copy specific cells to another tab
  537. End of Quarter Based on Fiscal Year
  538. Replace "A2" with Active cell
  539. row height
  540. ADOBE Connection to open Excel workbook
  541. Closing programs on remote PC - help please
  542. Compare Sheets
  543. Early binding problem
  544. Macro that opens a separate workbook to a specified worksheet whenthe active workbook is right mouse clicked
  545. Copying a range of cells and pasting them by using Transpose function
  546. Find the row for a Hyperlink
  547. toggle between method and source of inputs
  548. Compiling and Late Binding
  549. find newest file in all sub folders
  550. Macro help please
  551. Removing Duplicates from NameBox Table Using VBA
  552. Two-tone color column chart
  553. copy my digital certificates?
  554. Random selection of records based on specifc value
  555. how to automatic adding up 12 rows for one year, and 48 rows for therest of year
  556. Sheet Order _ Numbering
  557. 2000 -> 2007: gotchas?
  558. How to Insert Variables into Formula's
  559. how to use stacked line with markers plot to draw point estimationand confidence interval
  560. email from Excel Question for Ron de Bruin (or other really smart people)
  561. use stock plot to draw point estimation with confidence interval
  562. Attendance Tracker
  563. Compiling Error in Earlier Version of Excel
  564. Re: Opening workbooks and stopping the messages
  565. Re: Avoiding cells being included in a chart
  566. function with collection of custom objects as results
  567. Newby, ..Membercode
  568. Re: Tidy VBA Code
  569. Adjust Pivot Table Filter based on a Range
  570. Re: Tidy VBA Code
  571. how to add error bars into bar chart
  572. Form Control versus Active Control? When to use which?
  573. Failure to load icon causes UserForm to minimize to bogus object inworksheet area.
  574. Re: Read .TXT file line by line?
  575. Help with specific textbox entry...
  576. Help: Chart & data
  577. VBA Linest function for polynomial regression on horizontal range
  578. Making .dll files for Excel 2010
  579. Re: Read .TXT file line by line?
  580. Re: Read .TXT file line by line?
  581. Re: Read .TXT file line by line?
  582. Value of True etc
  583. Re: Can this be done with Excel 2007 VBA?
  584. Excel 2007 VBA: Convert laaaaarge number to Hex
  585. Re: Read .TXT file line by line?
  586. Re: Read .TXT file line by line?
  587. Re: Read .TXT file line by line?
  588. Re: Read .TXT file line by line?
  589. use vba to open pdf then save as xml
  590. How to Disable the Insert Worksheet tab at bottom of screen
  591. Button to Save File as PDF
  592. Add-in WITH worksheets??
  593. UserForm - pointing control source to new sheet - long delay
  594. Move cells down
  595. Move cells down
  596. Incrementing IPv6 address
  597. Separating Workbooks
  598. Check a 'Logsheet' for a match, before continuing a sub
  599. cross referencing two worksheets
  600. Don't re-run macro for five seconds...?
  601. creating frame and option buttons programmatically
  602. Is there a way to automtically apply macros in a script
  603. How to apply a macro to all workbooks
  604. Check for file open/closed status
  605. Listbox displaying incorrectly on opening worksheet
  606. formula to filter out blanks
  607. Adding values across files
  608. Variable SUM range
  609. Using IRibbonUI in VBA Excel 2010
  610. Reduce Numbers Down To A Specific Value
  611. Refresh Bloomberg data in an excel file from a script
  612. Can I use a variable contain the name of a sub or function to call it?
  613. Calling a Sub created on the fly
  614. Creating Charts using VBA
  615. Re: search cell
  616. Move cells down
  617. Thanks
  618. search cell
  619. Data in columns
  620. userform exception error 4 textboxes
  621. Tech help
  622. Identify each cell that has dependents
  623. How do I get VBA to make AND print a chart with a square grid
  624. Average If Problem
  625. VBA Code organizer
  626. Duplicate name range error when copying sheet (Excel 2010)
  627. Changing a cell from another cell's formula
  628. Can an Excel 2010 file be shared on the cloud?
  629. How to remove duplication in text string?
  630. Loading pivot table problem
  631. VBA Script useable by like workbooks
  632. How to make rows autofit when cells merge and multi line text inside
  633. Excel 2003 VBA string literal help location
  634. XCL 2010 VBA: I want to copy/paste from a rtf file to a spreadsheet
  635. Find last row and column for 1st page only
  636. Lookup
  637. loop to copy paste
  638. microsoft office web components wizard in office 2010
  639. How to Pause an Excel VBA script without freezing excel
  640. ADODB
  641. Multiple charts in microsoft excel VBA macro
  642. hot to calculate peaks of an "irregular" sine wave
  643. Variable Range Copy...
  644. ADODB CopyFromRecordset problem
  645. Compare font colors
  646. Copy value
  647. Re: "Following Features Cannot be saved" error on LOADING ??
  648. Finding range
  649. Center application window
  650. De-activating Excel 12, Leaving 11 Active?
  651. Re: Is ActiveSheet in ThisWorrkbook?
  652. Re: Is ActiveSheet in ThisWorrkbook?
  653. Script to remove file clutter
  654. Re: Is ActiveSheet in ThisWorrkbook?
  655. Upload files to a Share Point Site.
  656. Can you create a global variable ?
  657. Can you create a global variable ?
  658. Re: Dynamic links to other sheets
  659. Re: Dynamic links to other sheets
  660. problem with finding horizontal page breaks
  661. Change ActivePrinter in a Add-In
  662. Excel 2010. How to copy chart format to all charts in sheet
  663. Re: VB Script not working in Excel 2010
  664. setting one worksheet cell range reference to another worksheet
  665. Checking if a workbook exists
  666. Filll range with "NA" if another cell has certain value
  667. ExecuteMSO on copy
  668. Adding New Sheet, But Carrying Over Previous Sheet's Cell Calls
  669. 2 more questions on excel and vba
  670. Cell value on top, inside drawing
  671. How make long string in a cell become text line by line in same cell?
  672. Sorting a string array containing combinations
  673. copy a 2 dimensional array to a range
  674. Re: Adding to Array
  675. Default folder when saving a "Cute" PDF file
  676. Iterating through a ComboBox's values
  677. Tax Form with Merge and Center
  678. VBA Code Writing to Excel Box Name
  679. Is a signed certificate necessary to run macros in a marketed file?
  680. does anyone have any idea how to import this spreadsheet?
  681. MIN in VBA?
  682. Merging 2 sheets.
  683. Changing Cells depending on data entered in other cells
  684. Use userform to select autofilter requirements
  685. Breaking One Row into Multiple Rows using VBA Macro?
  686. Adding a condition to VBA CountIF
  687. Using only variables to reference a range
  688. Combobox date value matching
  689. how to use VBA code to create 'Select Data Range' userform.
  690. Autosum
  691. Deleting Columns with VBA
  692. Range Reference Problem
  693. how to run a recorded macro in many files at a same time
  694. Compatability Checker Question
  695. Template Folder with Excel Macros in Sub-Folders??
  696. Setting a .Range to equal another .Range
  697. VBA's Q? Printing None-Zero Valye ONLY
  698. halt macro execution, inspect progress and then resume execution
  699. display list based on validation
  700. ComboBox value matching
  701. Formatting short times
  702. VBIDE.Codemodule.addfromfile putting code in wrong place
  703. Multi-Dimensional Array
  704. LinEst using arrays
  705. Insert columns and values programmatically with IF statement
  706. Insert page break
  707. How can I Lock a Link?
  708. Error handling
  709. Wait till pivot finishes refreshing
  710. VBA Example of Using WHILE and LOOP?
  711. macro to copy columns from one sheet to another sheet
  712. Newbie help needed please...
  713. Odd Export as PDF problem - Killing me.
  714. C drive size
  715. Copy Multiple Areas from One Workbook to Another
  716. Delete characters from behind if too many
  717. Ignoring a blank cell while running a macro.
  718. Re: UserForm doesn't show?
  719. VBA Compare part of cell to another cell and then calculate
  720. Determining if a query is refreshing
  721. List all sheets in the work book and select by double click
  722. Error '1004'
  723. Pivot tables not refreshing after data source update
  724. Check a Check Box with VB
  725. How to print multiple sections from different worksheets
  726. Mixed-font string both to cells and word document
  727. Syntax in worksheet functions for individual values instead of ranges
  728. Working out of Statistics on Exam Results URGENT solution needed!
  729. VBA API for Outlook and Email managment
  730. Replacing the formula text's substring
  731. Lookup Formula Problem
  732. Compile Error:Invalid use of property
  733. Loop to hide sheet based on cell
  734. URGENT help needed for a macro to place and size command button
  735. Hiding Columns produces error <----HELP PLEASE
  736. Macro to select, set, and print
  737. HELP! Command buttons moving to edge of Worksheet when unhiding rowsand-or columns
  738. Macro to upload file to http://
  739. 4 out of 35 data connections running high cpu/memory
  740. Syntax question using :=
  741. Paste to next free column
  742. How to set range to autofiltered visible cells?
  743. Embed information in Worksheet for error checking
  744. loop to copy paste
  745. Pivot Table Refreshing
  746. Looking for all the opinions about Self Certification for macro's
  747. Vlookup error
  748. Find and delete error value
  749. Countdown 1 every workday
  750. Cycling through collection