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. What happens to data validation when created from VBA?
  2. printing worksheets and charts
  3. Loading data from a PDF
  4. Define range by last cell in column?
  5. Display Value from Sheet1-A1:A10 to Sheet2-B1
  6. Add Item To ActiveX ComboBox
  7. custom menus in excel
  8. List or TOC of Macros in Wkbk
  9. populating a list box based on another cell
  10. web services w/ Excel 2007
  11. How to work multiple ifs
  12. pause code while Query is refreshing, then continue
  13. match the cell and bring the amount
  14. Wrap Text code with merge cells
  15. How to work multiple ifs
  16. Copying cell contents a specified number of times 4 mail merge?
  17. Excel 2007 Ribbon
  18. Excel 200 conditional formatting problem
  19. Split file, saving each tab/worksheet to a new workbook, w/tab asworkbook name?
  20. FORMAT ENTIRE ROW BASED ON SPECIFIC TEXT
  21. Get Network Login Name
  22. Prompt for tab name and then prompt for number of iterations of ta
  23. Fill Color Macro
  24. Display Employees based on Login
  25. How to completely remove duplicate rows in vba
  26. Deleting - Rick Rothstein
  27. vlookup
  28. Macro to copy specific data from master workbook to another workbook
  29. vlookup
  30. Personal menus in Excel 2007
  31. copy text to clipboard
  32. Simple - Del empties
  33. SAVE AS MACRO
  34. How to stop Excel 2007 to create new instance while opening multiple files ?
  35. Macro To Filter As Per List
  36. Having A Macro Run When A Selection Is Made
  37. Help with loop
  38. Exporting & Importing with macros
  39. what wrong here, range Cell as counter
  40. question about UDFs
  41. marco/formula
  42. E-mail notification not working
  43. Display Sheet1: (A1:A10) value in Sheet2: (B1)
  44. historical price data into excel from msn money
  45. Loop cells, add rows and transpose for values greater than zero
  46. Re: Date dd-mm-yy(EXCEL) manipulation in VB macro
  47. VBA Sort for varying dimensions
  48. Problem with OptionButton click event
  49. UDF Looks for Named Range Not Function
  50. Sum of every time 2 different texts are found in 2 different colum
  51. Find text in columnThen count rows with data
  52. Export autoshape as picture using VBA? (object doesn't support met
  53. write cell values to a closed file
  54. Write to a closed excel spreadsheet
  55. Copy a File to the Clipboard
  56. scan sheet names?
  57. Highlight a cell and a message box
  58. Network Drive Info Retrieval
  59. Hide a command button
  60. a little tweaking might work?
  61. Re: Colum to line
  62. Lookup data from another excel files
  63. Copy cells to the left of an event in a cell
  64. Loss of an Excel reference in Dot Net programming
  65. Worksheet_Change help please
  66. copy from combobox to worksheet
  67. Grouping Shapes in 2007
  68. call a combobox KeyDown event from another procedure
  69. find TWO values in a worksheet
  70. Extract time from date
  71. Tough teaser!
  72. compare name in cells
  73. DTPicker Lock property
  74. Extracting data from multiple worksheets
  75. How to set the ActivePrinter Property for Microsoft.Office.Interop
  76. copying an existing sheet
  77. Run Access Macro from Excel
  78. How to compare two sheet using vba and remove duplicate content?
  79. Force synchronize list with VBA
  80. RE: Date dd-mm-yy(EXCEL) manipulation in VB macro
  81. SAVE AS MACRO
  82. Re: Date dd-mm-yy(EXCEL) manipulation in VB macro
  83. Why is the negative point on the chart Black not Red ?!!!
  84. copying row data through a macro
  85. trimming a space in the middle of a string
  86. SAVE AS MACRO
  87. hyperlink creation problem
  88. Setting A Default Value
  89. Macro to Hide/Unhide various columns
  90. Macros have slowed to a crawl
  91. RE: How can I use VBA to SubTotal
  92. Find stops macro if no match...
  93. How to confirm a cell entry is a whole number
  94. Ron de Bruin's Merge - Can I use multiple named ranges??
  95. Wildcards in a case statement
  96. help with my code
  97. Multiple options with multiple ranges
  98. code to hide rows based on criteria - but without looping
  99. Change the action of TAB Key
  100. Comments changes as active cells changes
  101. Problem exporting code in Excel 2007 VBA
  102. Need values not formulas - CopyMultipleSelection
  103. Group lines of data and subtotal
  104. Delete defined names with errors using VBA
  105. Number Transforms Into Euros
  106. input box
  107. a little help with an non critical but annoying error
  108. VBA code to copy multiple Excel files from C drive to network driv
  109. Object required Run-time error '424'
  110. Change one label in another form
  111. Help with a very complicated For each Next code
  112. Edit File Properties: Title, Subject, Keywords, (MetaData) w/ VBA
  113. Synax help/ worksheet array
  114. Macro to copy nonadjacent range and paste
  115. GemBox.Spreadsheet v3.3 Released
  116. Sending mail to different mail address based on cell value
  117. Sending to email different email address based on cell value
  118. Query from Access Database based on user selected parameters in Excel
  119. Using a dde link how do I write the data from the "live" cell to astatic cell
  120. Scan/copy and automatic update
  121. Display an Excel form from PowerPoint
  122. RE: ListBox1 = ""
  123. Round Percentage
  124. Macro to save the excel sheet to PDF
  125. Replace cell values in multiple columns
  126. Sub to check data by client n add new symbols to client's list
  127. .Find method with numeric and date values, Aug2009
  128. Stubborn Array won't Populate from single ADODB.Connection Query
  129. Find and replace
  130. Re: ListBox1 = ""
  131. UserForm Question
  132. On error resume next
  133. On time from cell time - Followup
  134. xlUp Not Working
  135. Activex Initialization error?
  136. Find value from one sheet and replace value in second sheet
  137. Having a problem with 2001 compatable functions in 2007
  138. Compare two sheets, then copy/paste if different
  139. Office 2007: #NAME error on UD formulas that were fine in 2001
  140. Rond merge help
  141. external link to start excel form
  142. Exit Sub when File Open Dialogbox is cancelled
  143. Display of a negative percentage in Excel with Brackets (22%)?
  144. Variable in Range for excel
  145. Excel 2007 Tables - Get Active Cell Row and Column
  146. variable not reading correctly using sumproduct
  147. Action from list selection
  148. TIPS ON A GENERAL STRUCTURE TO START WITH, ANYBODY?
  149. Change Textbox Backcolor and Forecolor at Runtime
  150. Shouldn't the last workbook/worksheet created be the Active one?
  151. RowSource as Sheet Names in UserForm ComboBox
  152. Between Dates Criteria
  153. Re: calculating ages from dates before 1900
  154. Re: calculating ages from dates before 1900
  155. copy area on spreadhseet as picutre
  156. special graph format
  157. Reference Range across Worksheets
  158. Row Height-expand if text wraps in a cell
  159. How to disable " Send To " menu choice from the file menu
  160. Insert Column into active Excel Sheet from Access
  161. Consolidate all tables
  162. CreateWindowEx
  163. backup file
  164. show/hide sheet tabs in '07 ribbon
  165. specifying the column for double click
  166. Copy WS w/ Named Ranges in Excel 2007
  167. Formula Help
  168. Syntax to close Workbook
  169. VBA book
  170. How do I find last occurence of a character in a text string in Ex
  171. Migrating Add-ins to Office 2007
  172. 1004 Error: Unable to set the LineStyle property of the Border class
  173. Vlook up to combine data in many sheets
  174. Multiple Graphs VBA
  175. Security Issue with Excel 2003
  176. Message Box should Popup on condition
  177. Sub to transfer values and log the transfer
  178. Working on segments of data from within a list
  179. How to combine amount in manys sheets into 1 summary sheets
  180. Convert 2-digit year
  181. Button to copy formulas
  182. Macro for use in individual workbook
  183. Remover ODBC Dialog Box
  184. Please help with formating
  185. Absolute Scale of Chart Printout
  186. Code for combobox
  187. Customize where FileOpen Pop-up starts?
  188. web query : part of a table not captured
  189. Code for unique Data Entries?
  190. Adding % to gether?
  191. automatically load an object library in real time
  192. Using Macros to Write Links
  193. Sum If - Using the value of a parameter or constant in a formula tochange a condition
  194. Run-time error 9
  195. Querytables WebTables equivalent for InternetExplorer.Application.Document.all()="HTMLTable"
  196. just learning
  197. application.worksheetfunction
  198. UserForm Show Problem
  199. How to load this online worksheet into Excel?
  200. COMBOBOX AND TEXTBOXES QUESTION !!
  201. Compare dates in two worksheets
  202. opening outlook and populating
  203. Determine if specific text is in a cell
  204. Acos function
  205. Mail merge leaves excel process running
  206. Resetting ListBox1.ListIndex to -1 after user selection
  207. Invoking Range.SpecialCells using IDispatch.Invoke
  208. differentiating between checkboxes
  209. Playing Embedded Sound
  210. Help with .Find Function in code
  211. Why variable isnt working
  212. Tough one - Cell referencing in Excel/VBA
  213. Multiple critera
  214. Tannspose and cycle
  215. Excel 2007 chart line width + axis labelling with VBA
  216. Using Macros to write Links
  217. How do I have multiple workbooks open and have a menu to switch be
  218. Retrieve data only
  219. Application.FileSearch
  220. THANK YOU
  221. Code Run-time Error '13
  222. interactive findnext
  223. Excel .xlsm / Vista / Speed Problem
  224. Can I loop this somehow?
  225. Run Macro (VBA) every 5 minutes
  226. Concatenate and Delete Macro
  227. Copying a row to another spreadsheet
  228. Need to Copy Files (all Subfolders and Files)
  229. Multipage - If .Page(#).enabled Then
  230. Names
  231. Automating macro to run macro from Access
  232. Help with Worksheet_Change;section of code not woring as expected
  233. Excel Worksheet Function Large
  234. Find/Autofilter
  235. Userform and email
  236. Sort Named Range
  237. How to export a range to CSV
  238. Referring to a cell without using Offset
  239. Did evalution of empty cells change in Excel 2007?
  240. Refresh External Data code
  241. Rhino V
  242. Simple if statment just not coming to me
  243. VBA Collections
  244. MACRO THAT BUILDS ON ANOTHER MACRO'S DATA
  245. Can I pull 2 different data tables into one pivot table
  246. Autoshapes loose formating when formula is removed
  247. Help please
  248. Main data sheet convert to high level
  249. drop down and textbox
  250. Give CurrentRegion a RangeName
  251. web query and formatting
  252. Can't find bug because program justs Stops !!
  253. print the pdf file
  254. populating the recipient address in outlook
  255. Run-time error 40036 Application defined or object defined error
  256. SAVE AS MACRO
  257. Run - time error '1004'
  258. problem with "file not found" calling a dll from VBA
  259. Automatically adds a row
  260. Help with counting cells in a selected range
  261. turning off pop up message
  262. ADO help
  263. 10/21 Screen
  264. How to populate VBA Variables from ADODB.Connection Results?
  265. Macro for Consolidation of Info from Different Tabs
  266. text to column/row
  267. Colorindex and conditional formatting
  268. Pause in a macro
  269. Copying certains rows to certain worksheets.
  270. How do I pull variable URL from one column and download the contentto another column?
  271. vba insert row does not update Sum formula
  272. programming in vb.net application
  273. Excel Code does not work in Access
  274. Row G equals to any of these part# turn color
  275. Importing Word Data from Form Field with Line Breaks
  276. Combobox - Problem on AddItem
  277. query to external data
  278. Data Entry Macro or other
  279. Checkbox problem
  280. For Each Row in Named Range
  281. Row Height-expand if text wraps in a cell
  282. modules removing problem
  283. REPOST - CF, MACRO
  284. Personal Ledger Problem
  285. Public variable Forgotten by VBA!
  286. XNPV in VBA
  287. IP Address
  288. Macro for Consolidation of Info from Different Tabs
  289. Macro help please
  290. Tier As Range Function
  291. MACRO EVENT
  292. find file that starts with todays date
  293. Datediff & bissextile year
  294. How to change SQL in an existing pivottable
  295. Copying Data OR Selecting Columns In Pieces
  296. Debug, Please help
  297. Clarification need, not just by me
  298. Blank cells problem
  299. TreeView.Nodes.Clear crashes Excel 2002.
  300. UserForm Question
  301. Just out of curiousity, why didn't this work (a change perpetuated to all sheets)?
  302. col A,B and C-P moved fr Sheet 1,2, to Sheet 4
  303. Need VBA code to make app expire after period of time
  304. How to display first line in a text box
  305. use sql select statement to load data into pivottable
  306. Can't added two columns from one listbox to two columns in another
  307. Retrieving Data from SQL Server to Excel
  308. Hide Macro Password Characters
  309. Macro VBA Help please :)
  310. check date format in regional setting
  311. Creating a Macro that Selects Determined Values from Drop Down Lis
  312. Help with a complicated For ... Each ... Next statement.
  313. Auto-sort data tables after refresh
  314. VBA Hangs
  315. Lottery Spreadsheet - Find data in a table and color it...
  316. Excel Spreadsheet display with autorefresh
  317. lookup function or table from dates that the overhead changed
  318. Print Avery Labels from Cell Data
  319. How to: Create Dependent Drop Down in a Form
  320. Add ins (.xla) VBA project
  321. Listbox help.
  322. Conditional Formatting Help
  323. SetFocus problem
  324. Macro
  325. MSQuery Parameter in WHERE defaulting to All
  326. Complex Compare Values, and Copy/Paste if in One Sheet but Not Oth
  327. How do I avoid printing cell borders?
  328. rename sheets(tabs)
  329. hide rows of blank cells
  330. How do I list Ampersand in a caption or quotes? -- & in " "
  331. New Name Dialog parameters
  332. Excel 2007 import text file VBA code - Origin:=
  333. myCell = CStr(SomeDigits) ?
  334. pulling just unique records
  335. How to hide "View Code"
  336. Random Numbers
  337. Macro
  338. Want to read text files of random extensions into recordset
  339. Biased Number Generation?
  340. Re: I've been working a littlbit too long
  341. Store VBA-Code centrally
  342. Run-time error '1004' on server extraction
  343. R1C1 Formula
  344. References Different on different machines
  345. Parameter Query Refresh issue
  346. how to add a pic in to excel cell
  347. Clear Contents of Offset cells automatically
  348. Inserting an object into a cell
  349. Excel cells automatic formatting of text
  350. Change Event
  351. Workbook code works on my machine but noy others
  352. How to make the application wait until ODBC Extract is finished
  353. HOW CAN I SETUP IN EXCEL IN THE CELL AMOUNT IN LETTER IN OTHER CE
  354. copy a cell value to an open outlook template
  355. Worksheet automatically saves itself after data is inputted in cel
  356. VBA to delete Duplicate Records (1 column), before which, non-duplicate data merged into remaining row
  357. Iterating on several Cells within a Row
  358. Displaying Currency numbers (e.g. "CAD 1,999") on worksheet
  359. Application Name differences between Excel 2003 and 2007
  360. selecting data for a chart based on specific criterie
  361. Copy range from Sheet1 into empty range in Sheet2
  362. VBA, Macros and Pivot Tables
  363. PivotLines collection
  364. Show Userform when Application Opens
  365. highlight row of active cell
  366. Sorting sheets works okay, but how to keep 2 sheets at the front.
  367. MACROS WONT RUN
  368. password protecting one particular file
  369. Erasing cells when the validation dropdown choice changes
  370. Macro To Update Pivot Tables on Several Worksheets
  371. Share and protect
  372. not showing blank cells in a chart
  373. Data from 2 sheets to create a new sheet with user input?
  374. Sub-total using Advanced Filter?
  375. Center spreadsheet in middle of window
  376. Creating a form
  377. Create N variables
  378. Userform Calendar
  379. Re: Converting Times
  380. Using .xlam issues with Vista and XP
  381. dynamic pie chart
  382. Insert total of page in a worksheet in a cell
  383. taking a word out
  384. Select one or more worksheets from a listbox
  385. Comparing values or text in 2 different workbooks
  386. Combo Box text vertical alignment
  387. Update to List-Comparison Macro to Show What Data Has Changed?
  388. Copy & Paste - Unsafe?
  389. autonumber plus
  390. reference named range
  391. Use of NOW() function - followed by locking the cell
  392. Listbox with Multiple Columns
  393. follow hyperlink then de-select cell (VBA)
  394. Query Data in Excel S/S from Access DB
  395. how to copy and paste "averages"
  396. Putting Formula in all cells give Circular Reference. Please help
  397. FTP DOS vs Windows cmd
  398. Compare columns
  399. ATPVBAEN.xla!Moveavg- where to find explanation of arg involved.
  400. Pivot Table - how do I get the name of the current table
  401. Workaround for Excel 2002/2003 UDFs recalculating and changing cel
  402. a macro that runs automatically when a workbook is opened
  403. Excel Worksheet ListBox
  404. PARSING DATA TO SHEETS
  405. Help needed for creating PDF file from macro enabled xls file
  406. Complex Filter
  407. Help writing a CONCATENATEIF function (filtered concatenation overrange)
  408. protect VBA project view by VB code
  409. Invalid procedure call or argument
  410. RE: Refresh Queries in All Worksheet
  411. Macro to copy certain data from one workbook into another
  412. Pls help with Excel UserForm
  413. Hyperlink with an active x control button
  414. Template(s) Question
  415. Run-time error 91: Object Variable or With block variable not set
  416. Reference Combo Box to Column of Data
  417. Find match from 1st 3 columns and return the row number
  418. import from text file with VBA code
  419. send email to email address in column
  420. Excel 2002 Errors
  421. Copy-Pasting Excel Chart into Outlook default email editor (not MSWord)
  422. How to pass a dynamic array FROM a function TO a sub
  423. Macro - Import, Delete, Concatenate
  424. Copy & paste special
  425. Conditional Format issue
  426. finding the "(" in text
  427. ModifyAppliesToRange question
  428. Run macro to update fields?
  429. alternative required; Fo Each Loop
  430. Match question
  431. Formatting issue when sending e-mail via CDO to Excel 2007
  432. lookup part number and category and provide intersection price
  433. Open files with String prefix
  434. Re: Macro - Find unique value and paste with content from column with border
  435. Activecell.ServerActions
  436. Disable a file from searching for a link update on a different user'scomputer
  437. Combox Box - Need to Reference Named Range
  438. VBA Code and Pivot Tables
  439. Sendkeys "{pgdn}" in Excel 2003/2007
  440. vba & bloomberg (gethistoricaldata2)
  441. Re: Macro - Find unique value and paste with content from column withborder
  442. Type mismatch error
  443. Help with macro
  444. Run - time error '1004'
  445. Re: Line Input Not behaving...!
  446. excel addin
  447. Pivot and charts.
  448. runtime error 424 'object required'
  449. List Box
  450. Getting data from the Internet
  451. Recurring report recurrence updates and history tracker
  452. Unexpected window positioning error
  453. Shape Captions/Labels
  454. Excel not calculating
  455. format a mail-merge file to send 1 message with a list of items
  456. update combo values based on listbox values
  457. Is Multi-Sequence Search Selection Macro Possible?
  458. Works on the trial verson of excel 2007 but not my student version
  459. find last column with data
  460. Move AutoShape in Sync with Date
  461. Problem running code in proper order
  462. Disable Change-event macro
  463. Change Event (How post Date/Time to Changed Cells Rows but different Column)
  464. Range("Y1:Y" & LastRow & "&")
  465. call duplicated
  466. Number of searched items by google groups
  467. RE: Line Input Not behaving...!
  468. Run file from VB in Excel
  469. How to restrict printing certain sheets
  470. finding last column from a target row
  471. Testing length of a number
  472. More Dates
  473. Damn Dates
  474. looping issue
  475. Re: Upgrade VBA code from 2003 to 2007
  476. Re: Upgrade VBA code from 2003 to 2007
  477. Excel 2007 how to set solver options as available in Excel 2003
  478. Comment boxes
  479. Working with times - Bug?
  480. Create User Defined Function with VB.Net
  481. How to Change ALL Hyperlink Addresses in a Column?
  482. Concatenation in MsgBox
  483. Excel not painting client area
  484. Copy To New Sheet
  485. Macro to insert value from range on different sheet and copy sheet
  486. copy sheets
  487. Printing Message
  488. cell to worksheet
  489. Copy & Paste on same day of each month
  490. MACRO - RELATIVE & ABSOLUTE - 2007
  491. Setting references in VBA
  492. Sub to freeze all sheets & delete all comments
  493. Need hardware locking for Excel application
  494. Delete Sheet executing macro
  495. Copy Entire Row - Rick Rothstein ?
  496. move cells that meet a certain criteria to the row below
  497. Counting OptionButtons
  498. help with code for scientific worksheet
  499. Multiple drop down list
  500. Print Preview Ribbon
  501. How to prevent a number stored as text from converting to a number
  502. Reusable ActiveX button?
  503. Still can't validate entry
  504. Question about globally declared array not available in function
  505. Re: References to multiple sheets
  506. User Form
  507. Varialbe Loses Value
  508. excel macros on windows mobile devices
  509. hiding rows with zero values
  510. Copy info between 2 specific words
  511. Colour alternating tabs?
  512. How do I make a button in an excel spreadsheet for sorting?
  513. loop a specific number of occurrences
  514. Auto footers on multiple pages
  515. mving select data (var # of cells) frm a range to another workshee
  516. How can I make my function result in an error
  517. copying code from personal folder
  518. Now you can Protect/Unprotect Excel Sheets using VBA Programming
  519. Sendkeys bug? Office 07
  520. Can I use INDIRECT in the code (of a function)
  521. Recording Macro for select workbook
  522. Sum Variable Range of Cells
  523. Printing Problems
  524. Shape Change Event
  525. populate a drop down list with commands
  526. Looping question
  527. white space between names
  528. Code Not Working Properly Anymore
  529. Date Calculations
  530. Converting data format from .xsl to .xml
  531. appending data
  532. little off topic, but with excel 2010 conditional formatting properties will be accessible through vb
  533. Can my UD function know what cell it's in?
  534. Is there a better Sort than Excel's default Sort?
  535. macro 2003 error 2007
  536. One click row highlighting
  537. Filter Field selection.
  538. Re: Separating Values in a cell
  539. References that move down as formula moves across - and vice versa?
  540. Range.
  541. Macro button help!!
  542. MAximum Lines Of Code
  543. MsgBox working is Excel Macro Programming
  544. RE: Separating Values in a cell
  545. Can macro type "vbKeyNumpad5" into a cell - to check for NumLock o
  546. Resetting error reporting after On Error GoTo
  547. Find current row number and select row
  548. Run Marco on 5 out 10 sheets
  549. radio button text bold when clicked
  550. Prevent duplicate entries within a range of cells from a drop-down
  551. letter inside radio buttons (option button)
  552. .Execute replaced in Excel 2007?
  553. Error 1004, paste method of Worksheet class failed
  554. Matching Rows 2nd try
  555. application.filesearch
  556. XChecking i a chart variable is empty
  557. autoclick "ok" msgbox
  558. Macro to import CSV file from fixed directory
  559. Populating Userform and then using selected data.
  560. VB password lost
  561. Looking for an easier way to change the name of copied controls...
  562. Adding date to bottom of worksheet
  563. Do loop with find
  564. array formula question
  565. Sort problem
  566. [VBA] COMBOBOX SHOW WITH CONDITION
  567. Pipe to cmd from excel and back
  568. Refresh screen during scroll
  569. macro to loop thru sheets and add info
  570. Suvive value of Public variable
  571. How can you change file format from .xsl to .xml programmatically
  572. Re: Data Validation Pull-Down: How can I make it longer?
  573. RE: Data Validation Pull-Down: How can I make it longer?
  574. Problem importing Access Choose function into Excel via VBA - skip
  575. Macro reference to a specific cell on a different worksheet
  576. Control a worksheet w/o activating
  577. counting xls files in a folder
  578. Finding the Y-Value of Points
  579. 2 loops? got me spinning
  580. Another UDF Question
  581. Help with userform problem: error message> "obj doesn't support thisproperty or method"
  582. Copy Entire Row based on Cell Value
  583. use a variable to set a range
  584. Hyperlinks
  585. VBE and Arranging Windows
  586. Application-defined or object-defined error
  587. How do I increase the available number of formats in Excel 2003?
  588. RE: Vlookup and VBA
  589. Re: Vlookup and VBA
  590. Creating folders as per date.
  591. Too much coding for macro?
  592. Run time error 462
  593. Dynamic vlookup from a close workbook
  594. Finding the same unique identifier in multiple worksheets
  595. counting excel files in a folder
  596. How to get the value from a variable
  597. Using a Combo Box text selection to find text on another worksheet
  598. name of file folder
  599. xl2007 data validation drop-down box
  600. Can you sort one cell or a string in vba?
  601. Find last occurrence of the value Yes
  602. Connecting to SCCM Report
  603. counting excel files
  604. Attach file to e-mail using excel macro
  605. VB.net to replace unstable excel add-in
  606. how do you delete controls on a form
  607. Ungrouping sheet tabs with a Macro
  608. Excel Cursor
  609. Validate Year
  610. Easy way to extract data and put into Excel?
  611. Inserting variable outputs into different ranges
  612. UDF Frustration - Won't Update
  613. Exporting from excel to word: issue with data displayed in word do
  614. Input Box labeling
  615. Set Date to Last Day of Month
  616. Scale and Aspect Ratios diffferent
  617. Macro for Full Screen
  618. Incrementing Column Values
  619. Macro to Sort
  620. Code Execution Inexplicably Stops & Excel Soon Crashes
  621. How to add Date Stamp to SaveAs "file name" within VBA for Excel?
  622. How to CheckIn a checked out file in VBA?
  623. Count totals for the same accounts
  624. Reverse name order
  625. ADD LISTBOX, COMBOBOX, LABEL IN THE SAME USERFORM
  626. Is there an equivalent function?
  627. Error location in VBA
  628. populate word from excel: On clickin "Export" button in excel
  629. Run macro brfore close
  630. "Project is unviewable"
  631. Userform problem with "obj doesn't support this property or method"error message.
  632. TextBox Change/Exit problem
  633. HELP WITH SUMPRODUCT FORMULA USING YEAR() and MONTH() FUNCTIONS
  634. Range row Address.
  635. Set CopyRange Error
  636. Can't find project or library
  637. Open another workbook if condition met
  638. Rename Multiple File Names in Windows XP Professional 5.1
  639. Creating a Calculated Field in a Pivot Table for same field
  640. Formula to calculate exact months and days between two dates
  641. export certain cells from excel to word
  642. Index on another worksheet
  643. How to Show 12 months dates on the basis of from today's date in
  644. Something wrong with my vba code!!!
  645. COMBOBOX SEL. / LISTBOX SHOW (VLookUp)
  646. Capitals
  647. "/r/n" CSV file In Excel
  648. Excel interacting with another program, continued from 8/9/09 thre
  649. Macro for Message Box
  650. last day of month in prior month
  651. Double vs. Currency
  652. Chapters???
  653. New Q to old Post: Stuck at Trying to Extract Data from a Website using JSP
  654. Combo box change event triggered from another file
  655. fill range
  656. setup.exe
  657. Compare word document in excel
  658. run macro on cell entry
  659. Copying and pasting a worksheet to a different excel workbook
  660. How to detect changin filename & to hv more than 2 autofilter crit
  661. Problem when trying to set axis properties of a chart by VBA
  662. Adding new name to Names collection
  663. How to Inserting rows above specified cell
  664. Help with Hyperlinks
  665. How to get the count of filtered rows after applying autofilter?
  666. Excel 2007 connection via oledbconnection
  667. loop through and update
  668. Type ahead in data validation list
  669. Page Break Problem
  670. Change from Text to Value
  671. Multiple entries put into string
  672. Minimum width of UserForm
  673. Query then pivot table
  674. Unprotect workbooks
  675. Connecting to Oracle through Excel VBA
  676. Hide rows issue
  677. subtotaling a column based on three others
  678. finding a specific value on a master file
  679. Trouble referring to a (dynamic) named range on another Excel shee
  680. How do I store my VBA UDF?
  681. Open, Update, and Close files automatically
  682. I need a formula that delete first character and adds another
  683. Run Time Error
  684. Excel 2007 macro recording feature no longer works for inserting p
  685. Increment a range location
  686. Can a worksheet (tab) be renamed via a cell's value?
  687. Re: Need formula to create a value in a single cell by searching a range
  688. selecting cells and getting their content into a string?
  689. Excel 2007 Condition Formatting - Dates
  690. Macro formula array return limits?
  691. Obtain an objects current location
  692. Please have a look at this ....
  693. certain day of month
  694. Exce small program
  695. error displayed on rs.open when using late binding
  696. Opening Macro Files
  697. Couldn'nt unload a form
  698. RE: Open Dialog..! in vb code..!
  699. Addin Security
  700. Listbox Auto Column Width
  701. HELP - Retrieving cells from another workbook
  702. VLOOKUP Insert & Copy
  703. Criteria
  704. Deleting Rows across Several Worksheets if Value = 0
  705. Split function - assign to array
  706. Checking characters
  707. Unable to view variable
  708. Always creates the new range which is not needed in the macro
  709. Lost VBA project
  710. Locate and change font color
  711. Extract auto-calc % scale so as to construct a macro to addcontrolled Page Breaks
  712. Complex Copy
  713. 2002 excel isn't playing well with 2007
  714. Macro works on some but not for all
  715. Copy List of Files using Excel
  716. Can this be done "Open Input Box"
  717. macro to select reference in tools-->references
  718. on error resume next
  719. How do I create screen tips?
  720. Access Object Library Reference issue!
  721. Access Object Library Reference issue!
  722. Access Object Library Reference issue!
  723. 2 dimension summing (sumifs with 2 axis?)
  724. Code Name of Worksheet in a Formula
  725. Shared Workbook
  726. vba coding question
  727. Using variables across userforms
  728. VBA SQL Server Stored Procedure creating a Pivot Table
  729. Macro that deletes and pastes filterd rows and then some
  730. adding a cell in a text string
  731. TextBox change issue
  732. index/match type issue
  733. Excel macro in Access module
  734. CurrentRegion.Address
  735. Multiple Worksheets, Date
  736. Protection in code?
  737. Can VBA Programs Run on a Locked PC
  738. BUG: print command from command button in userform causes double c
  739. date based question
  740. Multiple Website Import
  741. formula referring to total
  742. calculation
  743. Environ("USERNAME")
  744. How to handle persistent properties in Excel VBA 2003
  745. Autosum
  746. copying cells from one file to another file
  747. Best way using Macros
  748. Merging cells with same parent.
  749. Merging cells with same parent.
  750. Merging cells with same parent.