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: custom menu disappears when I File, Exit, Cancel
  2. Copying and Renaming New Sheet
  3. Find a cell based on current month
  4. Page print margin
  5. ThisWorkbook Problem
  6. Select method of range class failed
  7. Disable Worksheet_SelectionChange macros
  8. Data search and extraction from multiple text files query
  9. Copy after autofilter if range is not empty
  10. Can I get Excel to import XML like Access?
  11. Prevent the user from Edition / Erase / Format
  12. WorkbookBeforClose -> Cancel = True still closes excel
  13. Moving rows with grey background color to bottom (2003)
  14. Error with currunc
  15. Create DLL
  16. Filter a protected shared worksheet
  17. changing tabs from a cell from a difference sheet
  18. Limits of Excel
  19. Accessing another instance of Excel in vba.
  20. Not a 2nd print from the preview
  21. Sorting triplets...
  22. 1004 error when saving as CSV
  23. Is there any efficent method for searching in a large excel sheet
  24. update all hyperlinks to another drive
  25. Format Text & Numbers
  26. Iteration funtion
  27. Deleting rows that meet criteria
  28. If and vlookup in macro
  29. Write to Webpage
  30. No Prompt for Read Only
  31. reading range of data from excel sheet in C or C++
  32. Set Cell.Value = text & dynamic value
  33. Creating an Array from A Sql Statement
  34. Trouble with arrays (transferring values between two arrays)
  35. Code that sort of works
  36. DataForm Fields
  37. Copy non-contiguous cells from all workbooks in folder
  38. Constants Tied to Arguments in Methods
  39. Saving worksheet as CSV with correct usedrange...
  40. Excel 2007 User defined fucntion, cannot paste in mutiple cells
  41. Delete sheet on a condition: debug error
  42. Cell Format
  43. Exit from Excel edit mode using IDispatch
  44. Scaling problem with userform labels
  45. How to reset Used Range property of worksheet
  46. Excel Developer Version Solutions - are there any?
  47. Shell Problem
  48. Open MS Project From Excel & read Task Properties List
  49. selecting worksheet by its index.
  50. Controls Array
  51. If then else
  52. "Sort" macro in late bound code
  53. Please, help!!! How to keep userform from being moved?
  54. Save data entered into UserForm to be Edited later
  55. Error Adding to Spreadsheet Please help!!! Complex ?
  56. Pivot table refresh automatically when data changes
  57. Pivot table refresh automatically when data changes
  58. Converting Excel files to MS Project
  59. Stop Multiple Macros
  60. Run Macro When Specific Sheet Selected
  61. Caling fortran from excel
  62. copying worksheet to another workbook with a macro more than once
  63. Bordering Groups of Data
  64. Comparing 2 cells using vlookup
  65. Persistent classes
  66. How to select a range and save it as a picture (.gif, jpg, bmp, ..
  67. Searching for first 3 characters
  68. Multiple Printing
  69. Run time Error '1004'
  70. Copy from one box to another on a user form
  71. run stored proc from excel with a parameter
  72. Button Question
  73. copy and paste
  74. Page setup VBA help please
  75. FilterMode does not work? Excel 2003/XML
  76. Conditional Locked Cells
  77. How do I create a string from a range (Excel VBA)?
  78. choosing from drop down list
  79. Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order)
  80. In relation to coding
  81. best lotro gold ,wow,mmo,how can i buy the cheapest gold
  82. best lotro gold ,wow,mmo,how can i buy the cheapest gold
  83. word processing within Excel
  84. Seperate massive data within 1 cell into individual columns
  85. Find range differens between two ranges/areas?
  86. WinDBPro. Ver 2.0
  87. How to create a setup of excel application with macros in it
  88. how to select a single column when this column cross a merged cell
  89. Reference different versions of Access
  90. Deleting a macro using a macro
  91. Formula for S-Curves?
  92. add new chart in 2007
  93. sql issue
  94. performance question
  95. WairForInputIdle
  96. Cell Value to String?
  97. Searching cell values...
  98. Custom Menus With Excel 2007
  99. how do I combine multiple excel files into one?
  100. Is this even possible with VBA?
  101. Filling an array with ranges
  102. copy and paste
  103. Inserting chr(10) from script
  104. Statistical function problems
  105. Excel application level control for Excel 2003
  106. macro to change tab name to file name
  107. Accessing data-subtotal via VB
  108. hyperlink address
  109. HELP!!! Promelem with InStr(1, c, Sheets("TEG").Cells(i, 18), 1) >
  110. get values and colors back in a cell
  111. How to know which pivotFields was changed through Private Sub Worksheet_PivotTableUpdate
  112. Is there anyway to retrieve Registry Values from VBA???
  113. Need macro to go to next blank row, copy formulas into next row
  114. Object Module Constants Scope
  115. Formating
  116. Sum based on ranges pivot table?
  117. Auto Close Yes no button
  118. Inserting 2 rows above a certain cell
  119. Naming a cell according to its contents
  120. Query SQL Data in Excel with a function?
  121. TextBox Accessing Contents
  122. 2007 UK Excel Conference - Nov 29 - Dec 1, Cambridge, England
  123. Application.Match on an range defined to a variant array
  124. Can this Code be Condensed
  125. Graph on a form
  126. finding values and put them in a listbox on visual basic form
  127. validation
  128. Help - Create a range that will update automatically to be used in formula
  129. mail merge
  130. Overwriting existing files
  131. Keep Change History For
  132. can someone please tell me what i did wrong with this if statement?
  133. Conditional Formating
  134. Pause a macro for user input
  135. Add value if date is in an interval... tricky?!
  136. Booking sheet
  137. lookup formula or a macro?
  138. Problems with a Combo Box
  139. visual basic - select/activate but don't show sheets
  140. Programmatically setting Conditional Formatting to a range of cells
  141. How manipulate a picture with recording macros?
  142. solver problems
  143. Initial position of floating toolbar
  144. Macro Recording Excel 2007
  145. Clear check box problem
  146. validation if a string is a proper function's name
  147. Call back a Dim variable
  148. Office xp
  149. Add leading zeros fill space
  150. Using Worksheet_Change(ByVal Target As Range)
  151. How to copy and paste row as a text within workbook including numbers
  152. KeyPress: how to delete last character
  153. run macro whenever any cell is changed
  154. Breaking a row into multiple rows
  155. Using SumProduct in Code
  156. Excel - Passwords
  157. Calculate the number of days between two dates
  158. Text formatting
  159. number formatting
  160. Create Outlook Contact Error 13
  161. Problems evaluating defined names in VBA
  162. multiple sheets
  163. list worksheets in a workbook.
  164. copy previous row down 5 rows
  165. End sub routine, move to next
  166. Change Cell focus base on value in first Cell
  167. Average data and delete a row-need help
  168. Making 5 Minute Wind Averages
  169. Code to change code in a sheet and workbook module
  170. CommandBarComboBox : AddItem - procedure to attach routine.
  171. Store strings in a Define Name
  172. Find a picture on a worksheet
  173. SUM function Help Please
  174. Using VBA to print a range
  175. Scattered Cell entries into one Column
  176. From Column A get Text from Colum B
  177. Can Excel 2003 VBA module be renamed
  178. Help wanted
  179. Variable in Message Box Q
  180. Need help with Visual Script Code
  181. Digitally signing VBA Project
  182. Dynamic formula creation and p;acement
  183. compile error, need to simplify/shorten
  184. Some Comments un-editable - not sharing, not protected
  185. Pass named range to user defined function returns #value!
  186. Calling a variable from one subroutine to another
  187. Spreadsheet to access
  188. Help!!! Formula doesnt work.
  189. Re: Delete entire rows
  190. Delete entire rows
  191. wild card - cash deposit
  192. Please help me simplify the given code
  193. Vlookup Using VBA (without using VLOOKUP function)
  194. Copy formula to cells on the basis of value in row 1
  195. Code Execution Has Been Interupted
  196. Chip Pearson's code to modify code
  197. How to move down in a formula?
  198. Open MS Access from Excel
  199. 2 Lists but different time frames.
  200. 2 Lists but different time frames.
  201. Re: select specific sheet and cell
  202. Automatically Pressing OK on a MSG Bog
  203. Cell Value doesn't change
  204. Need help cleaning up a macro that "copies" data from another work
  205. Emailing disjoint cells
  206. Start Macro, pause for Row/Cell selection, then continue...
  207. Subscript out of Range Error if Null
  208. Is there a way of finding if the user is a system administrator?
  209. Range Next
  210. Seelcting specific sheet and cell on startup
  211. Delete rows
  212. Wild Card in button caption
  213. Recording a Macro
  214. How to offset a row
  215. vaRecipient = multiple names
  216. Benchmarking Range to Variant times
  217. Error 1004 Display Alerts
  218. Coring on calling VBA6 dll
  219. Rename Modules
  220. New to Excel programming
  221. Run loop until
  222. remove "+" from =+ABCD.
  223. Capture Forms button caption
  224. dsum evaluating only the beginning of a string?
  225. how to separate sets of text and numbers in a line with a macro co
  226. Workbook.Open() Fails in Vista
  227. Macro to Add Comments to Cells
  228. Closing file with Macro
  229. Excel 2002 has encountered a problem and needs to close /Code Clea
  230. Cant Digitally Sign Excel VBA Project
  231. roto13
  232. CONDITIONAL SUM WIZARD.
  233. wild card *
  234. Calling Functions
  235. How Can I Loop through all the range names in a workbook in VBA?
  236. PrintOut problem
  237. Open excel file and reffer to specific worksheet
  238. Using Mappath
  239. Excel wants to save an open file to another filename in VBA script
  240. cannot autofill 2 cells info at the same time
  241. Object instead of passing arguments
  242. Digital certificates
  243. recursive or loopless combinations
  244. Aplication.Worksheetfunction.MAX() Stopped Working
  245. command button
  246. find cell address of last active cell in range
  247. Sumif - Non Contiguous Columns - Syntax please
  248. How to change textbox caption in Active sheet from UserForm
  249. Setting Range Name using R1C1
  250. Apparently not possible?
  251. Command Bars
  252. Validation List
  253. Removing an addin from the available addins list
  254. Is there a way to change columns index with Excel 2007,or is it a
  255. Group and ungroup
  256. Splitting strings, error subscript out of range
  257. Possible bug with clipboard data? - Need Advice
  258. Drop Down Box - Deleting Items but it repeats what is left
  259. limiting rows
  260. Find Certain Cell Value and Print that Page Number
  261. Writing a Macro to Find & Delete Target Rows in a Range
  262. Make file drop dead on close
  263. Manipulating Arrays
  264. Textbox control
  265. No need to register assembly of DLL written in C#
  266. AUTO/MANUAL Calculate in Excel when opening *.slk files
  267. Pivot Table - I can't delete unused values in selection drop-downs
  268. Pasting info from another sheet
  269. Loading an Excel User Form
  270. Messed up references when copying sheets from one workbook to anot
  271. Copy Sheet
  272. Macro to remove word from text in a cell
  273. Printing move my camera picture
  274. Using a named range as a source for a combobox on a userform
  275. passing a parameter to an excel macro from a form control
  276. If Folder Does Exit Create
  277. Clearing the Contents of a range of cells
  278. Printing macro code
  279. Copy row to next empty line
  280. Excel charting options using VBScript
  281. Calling a function
  282. Copy and Paste
  283. Error Message Box
  284. RTD cannot return an empty value
  285. If Null Set Value to Zero
  286. evaluate a year expression
  287. Response to Userform Problems?
  288. FOR LOOP
  289. Trouble reading to object
  290. Select Multiple Ranges with Certain Data to Print
  291. Userform problem?
  292. Establishing a default on dependent data validation lists
  293. Control names on userform
  294. Search cell for string
  295. Excel 2007 AND Retrieving Data from Stored Procedure on SQL Exp 20
  296. Open another program (VNC Viewer) and insert an address
  297. Simple Macro... i guess
  298. Open excel workbook within macro
  299. Solver programming in VBA
  300. What Name for GetIDsOfName() ?
  301. HELP!!!!!!!!
  302. Userform with Unicode strings
  303. Query - Formula (Test for string)
  304. If X = Array?
  305. imput box
  306. do we have constants for maxRow (65536 in excel 2003) and maxColum
  307. sending active sheet by mail without macro (from Ron's page)
  308. Move cursor out of sight
  309. excel file properties question
  310. Combo Box_Change
  311. Nesting Collections
  312. How to make Class Module universal
  313. Work book event code help (re Bob Phillips)
  314. UserForm Window size setting
  315. Delete a Pivot Table
  316. Convert string to date problem
  317. System Errors Occurs Enable Macros
  318. vlook up formula help
  319. Export 1-dimensional array values to a two-dimensional table?
  320. How to save OLEObject to hard drive?
  321. "Or" statement not working
  322. Macro
  323. open outlook and add email address
  324. Circular Reference Notice
  325. Excluding one page in a macro
  326. Multiple printing of cell data onto new worksheet
  327. help Compare string to Combo box!!!
  328. Relative reference to current cell?
  329. Old question new twist?
  330. How do I macro sort with a varaible range (differing last cell)?
  331. convert a range of text into numbers
  332. Sorting
  333. Advanced Filter Advice
  334. Help with programmingBorders
  335. error when opening a workbook
  336. Run-time error '-2147418113 (8000ffff)':
  337. Camera Tool
  338. Disable Security Warnings Screen
  339. Cells not calculated
  340. Not getting the values
  341. Summarsing Variable Pivot Table Data
  342. Dynamic Conditional formatting
  343. Consolidation
  344. Automatically Execute Excel Macro at 6:00 am
  345. Auto Filter-VB
  346. same than end(xldown) but stops on hidden cells if not empty
  347. Selection.Copy on Temporarily unhidden excel sheet - possible bug?
  348. Fill Down to Stop at Last Row
  349. UDF Prompts in XL2003
  350. Linest in VBA problem
  351. Copy values in a range to memory
  352. Set Range of Visible Cells
  353. Can I learn VBA quickly and how?
  354. web query
  355. How to do the filter when applying formula to a pivot table
  356. getting file path
  357. send o outlook graph in html format
  358. ArrayFunctions: How do I... ?
  359. import data from excel under Mac OS
  360. Need help with Excel Macro for searching
  361. for each in range gives variant array
  362. range or string or long type
  363. How to use Decimal data type?
  364. convert text to number
  365. Data inside Cell Seperated by comma
  366. Upper case in textbox
  367. Copy Excel Ranges to PP in Office 2007
  368. Replacing information
  369. Sort by more than 3 criteria
  370. Remove non-printing characters
  371. Do Until Inputbox = loop count
  372. Help with Date Format
  373. u mann whitney
  374. xls to csv conversion
  375. help - how to list all excel files in a folder
  376. Export from Access damages my Excel-Workbook
  377. Passing a value to another macro
  378. Compile error in Userform macro
  379. Can I create custom symbols library?
  380. Can I create a custom symbols library?
  381. Excel Open error
  382. How to check date format in display cell value
  383. Access vba to Excel
  384. do not increment variables in excel
  385. Creating a Copy/Paste Loop
  386. Macro closing Excel file without saving changes
  387. export excel entries into a calender format such as Outlook
  388. Opening and processing all files in a folder
  389. Copy ranges into email - HTLM and Text format
  390. Button with hyperlink and asigne macro
  391. Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data
  392. formula not working
  393. Conditional Formatting - Range
  394. Counting macro
  395. Macro misteriously crashes Excel 2007 - but not 2003
  396. Validation code not working with pasted data
  397. Formatting and Ignore error
  398. change column fill color
  399. Data Selection and Averaging
  400. If a cell equals then macro
  401. Excel AddNew QueryTable '1004' problem
  402. What does the compile debug option do?
  403. Problems seraching newsgroups with Google groups..
  404. Excel Automation
  405. How to paste data into sheet?
  406. Trim the entire range
  407. Nested IF's
  408. Conditional Formatting - Color row based on one cell value
  409. Disable inserting or deleting row in selection of rows
  410. Excel 2003 VBScript
  411. Hide Headings / Group
  412. Technically, can anyone explain to me why Cells.Find() is so much faster than a loop?
  413. PasteSpecial Excel Chart in Powerpoint
  414. Disable Dropdownlist (Combobox - "Form Control")
  415. Help with creating code??
  416. select multiple cells
  417. Use VBA macro to populate formula result in 'next blank cell'
  418. Loop through SpinButtons on a Worksheet
  419. Help to improve UDF please
  420. Search column
  421. difficulties using vba to save to the desktop
  422. Copy Data From Worksheet to Another Worksheet
  423. data validation defaults
  424. Events are not disabled
  425. VBA is Mangling a Query
  426. Defined Name Formula
  427. Can I Write A Macro That Will Execute Fomula In The First Empty Ce
  428. CommandBarButton with toggle property (up & down)
  429. Picture question
  430. Enter login details on a web page using macro
  431. Data mining
  432. Load TextBox With Search Result Cell From a PAge
  433. Loop through column(s) to check values, perform action based on check
  434. USERFORM X BUTTON
  435. Ditributing ComAddin's & ActiveX-dll's in Vista
  436. function with a range as a parameter
  437. Using FSO
  438. Copy row 21 from all sheets to a new sheet except " summary"
  439. How to manually regist the com add-in for excel2007
  440. mininum with referance
  441. Error loading type library/DLL for MSFlex Grid
  442. Progress box
  443. How do you do a file search in XL2007
  444. Full hyperlink issue, please help - end of my tether lol
  445. Macro to run an Existing Microsoft Access Macro
  446. Complex SUMIF
  447. separating data from imported txt file into cells
  448. Code is changing date format
  449. Re : Excel CheckBoxes to be activated by VBA
  450. No Out put from UDF
  451. Adevance filter using VBA not show the requested data
  452. How to return column number
  453. Character Month from Date Data type
  454. Custom help attached to CommandButton
  455. Game?
  456. Average the sum of numbers in a list or table
  457. Data Recovery
  458. VB code for Excel sheet
  459. Inserting Many Images
  460. Question on Web Query .iqy Control Variables
  461. Working with Excel files on FTP server.
  462. Automation error?
  463. print multiple sheets with page 1 of 2 type
  464. Paste formula in a specified number of columns to the right
  465. Excel Conversion in Progress dialog
  466. Want to find/read excel files in SharePoint
  467. another autofilter question
  468. automating linking icons to different hyperlinks
  469. Excel automation: how to disconnect correctly?
  470. Join two tables
  471. Break Up A Spreadsheet
  472. Excel DocumentProperties
  473. Excel VBA - Max Function - Syntax Error
  474. VBA chart problem
  475. Excel date conversion in .NET
  476. update validation when change source
  477. Looking for VBA sub to Invert and Multiply matrices
  478. Automated .PivotItems boolean value
  479. PivotChart Formatting and screen updating
  480. Trying to create a Popup Commandbar
  481. event failing
  482. UDF to find end of range
  483. Calendar Control for Excel 2007
  484. Adding the values of a sorted column if some cells contain #N/A
  485. Print spreadsheet replacing recipient name
  486. Error 91 Object Variable not set
  487. Merge multiple worksheets into one worksheet.
  488. macro to compare data in column A of sheet 1 with data in column A of sheet 2
  489. Macro to add three seperate groups
  490. Vadlidation code not working
  491. Breakdown Excel 2007 worksheet to 65,000 worksheets for Excel 2003
  492. Run-time error 9 when trying to copy a worksheet
  493. Countdown Timer - not stopwatch
  494. Create rows from existing rows
  495. How to instantiate Excel 2003 when both 2003 and 2007 are installe
  496. downloading, opening and parsing a csv file
  497. FaceID for CSV-file (Icon)
  498. An easy question
  499. Office 2003 Buttons Invisable on a seperate computer
  500. Use Access VBA functions from Excel
  501. Change Negative Numbers to 0
  502. execute formula
  503. Find and Replace Dates in VBA
  504. Spilt data into two columns
  505. Workbook_SheetSelectionChange in an Addin
  506. Selecting non intersect
  507. Function Error, Returns 0
  508. Select limited character of a cell
  509. char to numeric value
  510. Com Addin Issue
  511. How to cancel midway?
  512. Year Date Format
  513. How to run VBA code at low priority?
  514. Year date format
  515. PrintTitle using macro
  516. Somekind of lookup?
  517. excel file size problems
  518. Dialog Box and mouse selection
  519. Name of SMTP server
  520. Using Now with microseconds Excel 2003
  521. range.comment.Text(...)
  522. Function prototypes in Excel VBA
  523. The excel calling msquery question throught DDE
  524. the excel calling msquery question throught DDE
  525. Autofilter on non-active sheet
  526. Checkbox from control toolbar macro
  527. VBA - identifying which worksheet is active
  528. VBA - identifying which worksheet is active
  529. Non-zero cells returning zero
  530. Print on worksheet
  531. Loop and variable type
  532. Sending e-mail with Excel
  533. best approach for overcoming Input box errors & code optimisation?
  534. Re : Excel VBA Array to be expressed as a variation of Partial Dimension
  535. How add password to ZIP folder?
  536. Excel Automation
  537. Easy Loop question (with delete row)
  538. Can I create a macro to adjust the height of the cell according t.
  539. Pro Football formula automation
  540. Ribbon events???
  541. Using Autoshapes as macro buttons
  542. Help with applying code
  543. accessing data in backend workbook over vpn, is it possible?
  544. Macro to enter week day dates only
  545. Enable or Disable Forms Button on a worksheet from code
  546. Inserting Pictures Based On File name
  547. Why does ControlSource in Excel return a US-formatted date
  548. Problem with Excel 2000 automation
  549. Compare Sheet1 value to values in Sheet2 Column A
  550. Pictures not displaying
  551. RE: Help with code issues
  552. Having data source and query code issues....
  553. Repost: Update querytable connections and refresh data
  554. Comparing two columns in two different worksheet.
  555. Macro to enter week day dates only
  556. How to test Excel 2003 & 2007 macro security level
  557. Date format on opening a csv file in Excel 2007
  558. Help with code issues
  559. Unable to Read file
  560. Str function does not work
  561. Sheet change or sheet calculate?
  562. Easy question for excel expert
  563. Question on VBA : how to detect "idle" condition
  564. Macro
  565. Number of Columns
  566. Increment Letter in a String
  567. combobox population question
  568. Charting from a different range location
  569. Can anyone recommend a good book on xls query and pivots
  570. TECHNICS U EVER DREAMED OF ....
  571. Speed Up this Macro? Part 2
  572. How to use the name for an array by using a variable?
  573. Event Macro - On Cell Activate - Change Cell Format
  574. Code stops after column "L"
  575. Code to delete shapes each time a sheet is deactivated
  576. Avoid Scientific Notation
  577. Unable to read file
  578. change attach workbook code to worksheet
  579. Combobox questions
  580. Auto row insert
  581. compare contents between sheets and identify matching values
  582. Unable to read file
  583. Pls help me in finding duplicate entries in a column range
  584. need macro to save HTML pages as PDF docs
  585. Close Buttom
  586. VB CODE REQUIRED..........HELP PLEASE
  587. Aiuto programmino con array
  588. please help
  589. Changing a macro from a specific worksheet to any worksheet
  590. How can I refference then search text in a worksheet text box
  591. Named Ranges in Functions
  592. Starting a Macro where the cursor is
  593. type 13 error
  594. Excel 97 - Excel 2003 Macros
  595. Speed Up this macro?
  596. Move and size a object on the sheet
  597. Moved cell & Ref
  598. Use SUMPRODUCT and avoid rows with #REF!
  599. Using an Input Box To Define a Range
  600. filter duplicates
  601. Excel Formula or Macro
  602. ActiveChart.SeriesCollection(1).Points(3).Select ERROR
  603. Centralized event handler
  604. Data Validation based on first, second or third data validation li
  605. Limit the input in a cell to a single character
  606. Using ActiveSheet to Disable Multipage1
  607. Excel 10.0 Object Library ---> which Excel version is it?
  608. how to select cells from a non active worksheet
  609. Inserting rows
  610. Creating a Check Box that produce true or false statement
  611. If Font.ColorIndex = 3, Copy Entire Row and Paste to New Sheet
  612. Help with code repair
  613. Formula in a macro
  614. sub won't fill down via code
  615. Iteration
  616. Using "Like" to match strings
  617. ActiveWorkbook.SaveAs question(s)
  618. Open and Enable xla file from vba code?
  619. Update querytable connections and refresh data
  620. Wildcard in workbooks open code
  621. Calling a public Macro from a Private Macro
  622. type mismatch and/or obj req error from inputbox
  623. Filiter and Limit selection in Combo box / List Box in the UserFor
  624. Make Variable Range in VBA
  625. Excel PID process casting
  626. Run a Word Macro from Excel VBA
  627. Worksheet_Change Event
  628. convert workbook to html
  629. What is going on during a workbook opening?
  630. Copy Validation to next row
  631. Check Box Macro
  632. Listbox in excel data
  633. Problem with Pivot Table Fields In Field List Not in Source Data
  634. A problem worth gurus, I'd say ...
  635. Risk and Decision Analysis @Risk, Evolver, Decisiontools, Roy Kelly FloorTrader Tools 8.3, AmiBroker 5.0, MultiCharts 2.1, NinjaTrader 6, OwnData 2.6, VantagePoint 7.0.11.2, other ...
  636. dynamicaly fill dropdown using LISTFILLRANGE
  637. Lookup last value
  638. Make ArrayOne = ArrayTwo
  639. Programming Excel to send emails
  640. Problem with dBase
  641. Changing the ActiveSheet
  642. Using VBA to open Excel , Auto_Open Procedure not running
  643. Check Box macro
  644. Access to the value of a merged cell in a formula
  645. Formatting a Pivot Table
  646. Hi, I am Starter in Excel Programming
  647. How determine if directory exists
  648. Reference of Range in another file with VB
  649. Itreration
  650. Update existing data or Insert new problem
  651. Receive Error File Not Found
  652. Sort by unique values and sum
  653. packing slip
  654. protect workbook
  655. Database summary
  656. Tool Tips on a new
  657. On change event for specific cells
  658. prompt for parameter/criteria
  659. Database Functions
  660. Delete Rows that fit a certain criteria
  661. cant see the macro
  662. VBA finding language versions
  663. Type Mismatch error
  664. Re-setting Forms Spinners or Combo-Boxes
  665. How to declare the active worksheet?
  666. Do indiv. sheets (or cells) have "TextToColumns" properties?
  667. Excel sort formulas
  668. validate and offset
  669. formula refresh problem
  670. date range
  671. Relative Range Selection
  672. Edit Links
  673. Allowing user to locate and select a file and save results in stri
  674. Slow Code
  675. listbox selection to load to new form
  676. find names of routine in modules in many workbooks
  677. Save range to text file.
  678. Programally add a Macro to Multiple Sheets
  679. How do I display time in gmt when my system clock is set to local
  680. Macro to slightly modify the subroutine
  681. Why my workbook suddenly open slower than before?
  682. Exporting Excel to Word
  683. autocreating hyperlinks in excel? ie 500 cells to 500 hyperlinks?
  684. Get data from another worksheet in same workbook
  685. splitting cells programmatically
  686. Open a specific sheet with VBA
  687. Excel 2003 - Code to print and/or delete
  688. Controling Matlab from Excel
  689. How to make this work??
  690. How to get Excel results into Word
  691. Combobox and spinbutton causing object disconnected error
  692. Run an HTA as an embedded object in a sheet for help
  693. VLOOKUP with 2 criteria
  694. Copy non contigious data from another sheet that meet criteria
  695. Print Macro
  696. Chart Placement incorrect in macro due to differant screen resolutions
  697. Run Macro based on IF
  698. Resubmit of Macro needed to search 2 columns
  699. A negative to using Application.Onkey
  700. Getting own workbook
  701. Can't remove problem reference
  702. Import Access 2007 report to Excel
  703. Serious help
  704. input box - user selects range with mouse?
  705. Error running GetVersionExA
  706. Sorting cells in Shared Workbook...
  707. Choosing what information to filter from SQL in VBA
  708. filtering he data is not always correct
  709. Problems with long text
  710. Error LineStyle property of Border Class
  711. Insertting multiple rows
  712. insert images/pictures
  713. run macro on a CommandButton from another sheet
  714. sheet names displayed in first workbook sheet help
  715. Decimal Point Placement
  716. Hide WindowsMediaPlayer1 Media Control Bar?
  717. Graph series collection
  718. Enter in a workbook and copy to another automatically
  719. lookup from one document to another and paste in adjacent cell
  720. Create a Macro to Delete All Rows that meet a certain criteria
  721. Copy and Paste LAST ROW of data: non-contiguous Row, contiguous Column
  722. Getting excel process id
  723. Turning off/on protection in a macro
  724. Variables Name
  725. Trim content of a column
  726. Attaching a function
  727. removing leading and trailing spaces
  728. How do I create a picklist macro?
  729. Can I Delete A Module On Exit?
  730. Adding to A Collection
  731. Update two cells by changing another
  732. Change size of font if cell value is greater than 0
  733. Macro to check data from excel list against access query and return value back to excel
  734. ActiveSheet not in ActiveWorkbook?
  735. Picture pasting where it should but also in alot of cells it shouldn't
  736. Selecting rows and columns up to a certain point
  737. Workbook_Open event fails to fire
  738. Creating COM Objects or Add-Ins from VBA
  739. Opening a Shared File
  740. Update txtbox from combobox
  741. How to select program to open Hyperlink?
  742. Macro needed to search 2 columns
  743. Date Calculation - Continuation
  744. Return values from multidimentsional array
  745. insert page break at each change in column B
  746. Code question
  747. Link spreadsheet control and Excel worksheet
  748. Find source WS from Chart
  749. subscript out of range (help)
  750. Create WB, create new Sht, paste data. (Macro not working)