PDA

View Full Version : 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 | 

  1. Change Link Source
  2. search in define name window
  3. RE: Slow sheet data entry?
  4. back to previous sheet
  5. RE: Code not work Take same action on all wkshts or selected works
  6. Change cell value based on other cell value
  7. If Yes then...
  8. Adding right click menu item to insert a blank row
  9. VBA code for inactivating button
  10. How to protect a range of cells but permit highlight
  11. How do you set up a month of supply formula?
  12. Re: Delete duplicate data based on date of data
  13. Solver: Can't add constraints when they are above/below certain va
  14. RE: Forms always on top
  15. add a letter to contents in a cell in excel
  16. Re: Nested Forms & SendKeys
  17. Select dynamic range
  18. ComboBox "Not In List" Warning
  19. Re: Print all (except one or two)
  20. Macro for sequential numbering
  21. Re: SHOW Userform
  22. VBA, Yahoo ichart csv file
  23. Delete Blank Columns
  24. Re: Worksheet_Change event
  25. Search and replace on the worksheet
  26. Extract data from Pivot table with VBA
  27. Re: Slow sheet data entry?
  28. Excel to TTwin
  29. pasting changing data to a new worksheet
  30. VBA Inserted Data Validation Fails
  31. Re: how can i record how long a workbook is open?
  32. Re: Do Until Loop not functioning properly
  33. Index/Match/IF
  34. Something Wrong With Posting?
  35. Re: Sum row using variable
  36. Needed - Collaboration with VBA programmer.
  37. Re: Putting a value in specifc Excel cell from Visual Basic
  38. Re: Using Code to Change Password for Protected Sheets
  39. Re: Array handling error
  40. Search for formulas in cells and apply to new record--no data form.
  41. Seeking some VB code help.
  42. Formating textbox's on a userform
  43. updating caption of added control
  44. Filling ListBox another excel file
  45. Re: HELP!
  46. Re: Get Query String from Access
  47. Re: insert today's static date dependant on a condition
  48. Default Folder for Import/Export Module
  49. Capture a number from a cell containing numbers and letters
  50. code to intercept 'printscreen' key?
  51. Executing two statements in a for loop
  52. Excel VBA Help
  53. Excel VBA Help
  54. Two questions on worksheet protection and hiding formulae/ functions
  55. Adding all numbers in a given range
  56. Re: Change Event
  57. Work-around for exporting sheet contents and removing code
  58. Re: Change Event
  59. Adding a C# method as an Excel function
  60. Transpose Function
  61. Re: Macro fundamentals
  62. Changing a Macro to fit new use
  63. Can links created in a text box be conditional?
  64. Re: Macro fundamentals
  65. free programming resources.
  66. distinguishing between cell formula, and the resulting text in cell
  67. User Defined formula
  68. Delete the contents of a cell if (REVISED)
  69. Macro with an option to attach emails or not
  70. Link to specific record
  71. Why does this code not get updated
  72. Re: chart text position
  73. Re: CustomDocumentProperties disappear after save
  74. Merging Cells
  75. Reading sheet names in closed workbooks - Is it possible?
  76. Re: Copying and Pasting in a Loop
  77. Re: Print all (except one or two)
  78. range names
  79. CommandButton to Exit a Macro?
  80. Copy/paste number as text
  81. Excel(2007) crashes on quering for DrawingObjects selection
  82. Re: ALT-keys in User Forms
  83. Re: Adding Worksheets without Switching to it
  84. Image control with PNG support
  85. How do I add commandbutton in spreadsheet using Visual Basic
  86. Code for sending mail from Excel
  87. Calling DLL function
  88. Re: Searching csv files for particular string
  89. Why does this code not work across all designated sheets now ?
  90. help making code more effecient
  91. adding tabs and naming them automatically
  92. Sheet Calcuation Issue
  93. Simple question
  94. Excel keyboard shortcuts
  95. Re: Countif on non adjacent rows
  96. Re: Macros in Excel
  97. Format an Excel Column in the window's short date format.
  98. Lookup and Mean
  99. Locate a word and add the next (below) cell value to the totals
  100. Clipboard Question?
  101. How to simply export a single sheet to a new .csv file?
  102. Email Error
  103. Re: Change text in rectangle shape
  104. I need your help Dear Vba Guru's..."Creating range in a variable data.."
  105. Re: VBA Code to automatically reset the Freeze Panes settings
  106. RE: Change text in rectangle shape
  107. Finding a date rather than text
  108. Re: Working with geographic coordinates
  109. Error putting a formula in a cell with vba
  110. Re: Working with named ranges
  111. Re: Change text in rectangle shape
  112. Re: changing the way buttons look
  113. print macro base don tab color
  114. Regular Expressions
  115. Calculation woes....
  116. Excel Lists - Resetting Filters
  117. Excel Macro Security Problem - Trusted macros not running for users (but do run for domain admins)
  118. ensuring at least one checkbox is checked from a group
  119. SaveAs no question...
  120. Menu problem in Excel
  121. VBA or VB math function
  122. Help with some code that Martin wrote
  123. make table to row column
  124. ? VBA to insert formula if a column is blank or not ?
  125. Re: Working with geographic coordinates
  126. export chart method error - excel2003
  127. Re: Sumif not equal to
  128. how to make a table to row column
  129. Re: SQL string
  130. Creating auto-update ability
  131. PrintQuality in Excel using VC++
  132. I need a Macro
  133. Retain cell formatting?
  134. Re: Open File then Set as
  135. Re: Adding blank rows every 3rd row
  136. Help with recurse subdirectories code in excel file index sheet
  137. Delete the contents of a cell under multiple conditions
  138. Pass object by value not working...
  139. Inserting Code within ThisWorkbook via Code Q
  140. Automatically keeping cells together when printed.
  141. DynamicSum with counters??
  142. Code not working
  143. Re: Codename conflict
  144. Iterative creation of Image objects?
  145. Sort Column Script
  146. Copy between spreadsheets
  147. Re: Count visible windows
  148. Excel 2000 -Revise Dim
  149. Excel 2000 -Simplify macro
  150. Excel 2003 - Combobox.AddItem type mismatch
  151. Values of non-contiguous cells
  152. Re: Moving for selected cells
  153. After running Find, need to goto column A of that row
  154. Re: Working with named ranges
  155. Re: Working with named ranges
  156. Saving data as *.txt file
  157. Re: Working with named ranges
  158. Text to Display
  159. Differrence bewteen Rows(X) and Rows(X).EntireRow
  160. Simple Export of worksheet contents to text-file.
  161. Re: Logic problem
  162. know row index via Cell
  163. Excel 2000 -Range
  164. RE: Dates
  165. SORT not working
  166. Userforms: I want one form to lead to another, using a next button
  167. Re: Dates
  168. Re: Dates
  169. I want a special Sum function but I need help with that
  170. Searching csv files for particular string
  171. Select a drop-down box
  172. Replace Hyperlink Addresses Help 'Dim OldStr As String, NewStr As String
  173. RE: delete dynamically created combo box
  174. Delivery number for all dates in delivery period
  175. Complex comparison of Columns of Data: Extracting unique records after comparison on 4 levels
  176. Concatenate Text Statements
  177. ActiveSheet.Next with hidden sheets
  178. More complex macro can anyone help
  179. Easter day formula
  180. delete entire row based on conditional test of column A
  181. Re: ADO connection Steps
  182. Load Object
  183. Compare 2 Columns in 2 Sheets that are Not Ordered the Same
  184. enable/disable checkboxes based on other data
  185. Add 1 to cell when another cell changes
  186. autofilter
  187. PHP Excel generation libraries
  188. finding records
  189. Excel VBA tech interview
  190. Range name problem for DA
  191. A Little Favor for a Friend
  192. Data validation and lists
  193. Function not completely volatile help
  194. syntax qustion
  195. Filling Textboxes from Combobox selection
  196. Calculating Standard Deviation while ignoring Zeros
  197. RE: For Ron Bruin Please
  198. Will not copy to City-Panmure
  199. Excel-g ?
  200. How to know the windows language
  201. Re: Call up form calendar form VBA
  202. Connecting lines
  203. if Cell B1 = "Day1" show chart
  204. Parse data from string
  205. How to stop a macro at a Shell line.
  206. Hi,
  207. Argument
  208. Insert row after last (filled row)
  209. modify size of calendar control
  210. Need help on generating non-duplicated result
  211. formulas for conditional formatting
  212. paste - skipping cell
  213. summ aumont with interesec two index....
  214. Copying cells- the cell references don't update
  215. Index function in VBA - on Multiple cells
  216. summ aumont with interesection with two index....
  217. =VLOOKUP validity
  218. I need help using the Assistant.NewBalloon feature.
  219. Matching Value placed in next column
  220. Re: Page Break Preview sliders not working
  221. Re: Send to function
  222. Stop the _Change event? Is there EnableEvents for Forms?
  223. Re: Excel and "send to" function
  224. Having issues with .SetFocus after msgbox...
  225. Re: how do I get a visio pic on my worksheet on a form?
  226. Excel Timesheet Counting problem
  227. Selecting Next Worksheet
  228. Select Data by Date Range, Delete Rest
  229. Re: Better way to delete rows wiht #N/A?
  230. .PageSetup on multiple sheets in workbook
  231. User-defined formula (VBA) that can convert a text value into MD5
  232. Call Add-In Macro from VBA
  233. Re: Reading Chart Coordinates with Mouse Events
  234. Re: link chart axis title to cell?
  235. calling macro from another instance of excel
  236. Re: Counting Formula
  237. Macro - Loop/automatization problem
  238. Add-in
  239. RE: Excel Worksheet Select (Activate ?) in VBS
  240. If statement to move data from one column to another
  241. Re: array
  242. Change color of Shape based on condition - Macro?
  243. Simple Print Macros
  244. think i need sumproduct help
  245. grouping large pivot table columns
  246. grouping large pivot table columns
  247. Disable Workbooks_Open() Macro when opening from VBA
  248. How do I convert text to numbers in excel?
  249. combine change event codes
  250. or operator
  251. Userform Q
  252. summ aumont with interesec two index....
  253. Save as DBF in 2007
  254. Missing VBA Code in Excel 2007
  255. for next question
  256. CSV file has ,,,,,below last data row
  257. RE: AutoFitMergedCellRowHeight
  258. RE: How to invoke a user form from a custom button on the menu bar
  259. Re: User Form Input mask
  260. Re: EASY QUESTION: Formula to add filename to cell
  261. Re: Report on missing numbers
  262. Dynamically populating a 14-column listbox
  263. Put CommandButton1 code in Module1
  264. Programatically Delete command button and code.
  265. RE: Error 1004, Looping Error?
  266. Passing variable to worksheet function
  267. Re: Appending Filename in Macro
  268. RE: Error 1004, Looping Error?
  269. RE: Error 1004, Looping Error?
  270. VBA, Reading File As Binary
  271. Increase in the size of Excel Workbook.
  272. Increasing a cell value by 1 each day from date in another cell
  273. Standard PivotTable report selection format
  274. Re: Office 2007 + VSTA
  275. Re: active offset
  276. Re: Better way to delete rows wiht #N/A?
  277. Re: Email with Notes
  278. Re: Office 2007 + VSTA
  279. Scrollbars
  280. Macro to Perform Same Function Across Selected Sheets
  281. Excel component references in .Net
  282. Putting cursor in cell A1 for each worksheet
  283. Putting
  284. Macro to rename Excel files in a folder
  285. Re: Help needed - populating comboboxes from list??
  286. Where does excel store the pictures of a userform's 'Picture' property?
  287. Determining Variable Declaration
  288. Excel references in .Net
  289. Textbox on user form type mismatch
  290. Textbox on user form type mismatch
  291. cell locking problem
  292. Clearing Comments?
  293. added a range of data
  294. Count the number of characters created by string text
  295. RE: array
  296. Display a value in a column
  297. Error 1004 : function returning a Worksheet
  298. Getting Column *Letters* From Range Objects
  299. 2 questions, one difficult.
  300. Hide rows based on colour
  301. VBA get ColumnName
  302. Re: Changing Transparency of User Form or Splash Screen
  303. Re: Macro not allowing inserting cells/colums/rows
  304. Please help debug this macro.
  305. Insert Bullet in E-Mail text
  306. listbox events
  307. Pressing a CommandButton on a Userform via Code
  308. conditional formatting formula
  309. Re: Data overrun
  310. Re: Help needed - populating comboboxes from list??
  311. Re: De-concatenate but maintain relationship/record structure
  312. entering new data thru combobox
  313. formating cells with procedure
  314. RE: Convert text to hyperlinks
  315. Modify language options from control panel using VBA
  316. Re: Using Printout with Adobe PDF as the printer
  317. Reverse Frequency
  318. Re: Excel 2003: Control tab in "Format Control" doesn't show up.
  319. VBA Passing information from one worksheet to many others
  320. Re: Excel cannot complete this taks with available resources... why?
  321. Help with colums
  322. Re: Using Printout with Adobe PDF as the printer
  323. Re: How to sum 2 +2 = 22 in Excel?
  324. Re: How to sum 2 +2 = 22 in Excel?
  325. Find/Replace in VBE takes focus off window Excel 2003
  326. Help with code
  327. Combine cell contents into a text box
  328. Re: Save worksheet to a unique filename after worksheet is printed
  329. Excel 2003 Suppressing Errors
  330. Re: Simple "If" statement ?
  331. Excel ODBC Data Connection
  332. Re: Calling? Invoke Public Function
  333. Parsing data into seperate sheets
  334. Need help comparing & flagging email lists in separate worksheets
  335. Re: Create personalized toolbars in Excel 2007
  336. Re: Excel 2003: Control tab in "Format Control" doesn't show up.
  337. Re: For Ron Bruin Please
  338. Log-in Screen
  339. Re: Can I make a cell into a macro button?
  340. Copy Formula without changing cell refence
  341. check if name object exists
  342. Values of Variable after Project has Run
  343. Running macro with different references
  344. Hiding Unused Rows
  345. Re: setting a file with variables
  346. Excel will not open
  347. Increment a variable?
  348. Increment a variable?
  349. Run bat file from excel macro
  350. Re: locating carriage return within cells
  351. Re: locating carriage return within cells
  352. Re: Control which sheets get Recalc?
  353. Re: Replacing Sheet references within formulas with VB
  354. Part Time Job Opening At Purdue Campus
  355. Re: vba error
  356. Delete Function:
  357. I just want to select the first word...
  358. Password/UserName
  359. Re: setting a file with variables
  360. Help on Dictionary datatype??
  361. Re: Hide ribbon or menu bar in Excel 2007
  362. problems with a localconnection to a cub file
  363. Re: find
  364. Re: find
  365. Inserting a Static Date and Time thru a Macro
  366. Use module, not thisworkbook
  367. Re: print hidden range
  368. msgBox after update cell
  369. msgBox after sum values
  370. Command Button Request
  371. Apply Formula to Selected cells
  372. Cannot load Excel 2000 Addin from Word (and that's so weird!)
  373. Command Button
  374. Copying sheet containing GetPivotData, new sheet references old workbook!
  375. Display WorkSheet data Size
  376. Excel format Cell
  377. Re: Need ComboBox Help
  378. Can't get PageSetup to work
  379. Re: Position the shape
  380. Re: Macro - Issue with cut and paste if a column is blank
  381. RE: No Worksheet Range Object in VSTO?
  382. Re: ControlSource Property Throwing Errors After Changing Regional Settings
  383. Dynamic Creation of list box on excel sheet and handling events
  384. Subject out of range
  385. Userform formats time incorrectly
  386. ADO get data from Oracle by SQL field type missmatch
  387. Re: Storing XML In Workbook
  388. paste special all and column widths
  389. Re: database calls
  390. Re: Macro - Issue with cut and paste if a column is blank
  391. Re: No Worksheet Range Object in VSTO?
  392. VB in Excel 2007
  393. Number Matching, one to many
  394. Import Module to New Workbook
  395. Excel COM application hangs on Workbooks.Open
  396. Worksheet excluded doesn't exclude
  397. Re: Public?
  398. Object doesn't support...
  399. Macro to sum sheets in a folder
  400. Re: Importing into Access from Excel
  401. Excel Looping Question on multiple ranges...
  402. Log data from timecard into table in separate worksheet
  403. Do not let user save template if it has been been modified
  404. Programming Outlines (expand/collapse rows) in Excel
  405. Re: For Loop
  406. Help with UDF
  407. Help creating an Excel Add-in using VS205 in either VB.NET or C#
  408. Re : Date to be placed into Column "C" with matching value in Column "B" in same row
  409. Extracting Cell Data Based on Input Mask
  410. Extract Numbers From String
  411. Re: Range Selected.
  412. A macro that can delete the contents of a cell after a delayed interval
  413. Re: Converting a string of numbers to decimal
  414. Excel Application.Quit problem
  415. Re: Converting a string of numbers to decimal
  416. Run time error 1004 When running in 2003
  417. User Specified Grouping
  418. userform, StartUpPosition
  419. Ignoring End Statement
  420. Application.CalculateFull
  421. Re: help with code
  422. Hiding unused rows
  423. Adding Several Rows at a time and Asking for User Input
  424. add worksheet checkbox and change parameters
  425. Re: database calls
  426. Excel VBA question...Need help..
  427. Re: ActiveX Option buttons
  428. Re: ActiveX Option buttons
  429. Re: ActiveX Option buttons
  430. Trying to hide all rows where no data is in columns AQ-AV
  431. Re: problems when moving code from Macro to Command button on sheet
  432. Re: help with code
  433. thanks 2 everybody here who asks questions & answers them!
  434. Re: After Paste Value and Replace
  435. Re: "Application.ScreenUpdating = False" on the intranet
  436. Re: Macro to run everyday???
  437. User Name/Password
  438. Re: Return column numbers where word appears on row
  439. Re: Compare two lists and producing a third list
  440. find text delete row
  441. Sheet name = cell value
  442. Re: Change cut/paste operation to cut/insert operation
  443. Merge data from one sheet to another and print
  444. Re: Can I make a cell into a macro button?
  445. VBA: How can I check if an array is declaired with a dimension?
  446. Asking for better logic to avoid multiple if's.
  447. Re: Can I make a cell into a macro button?
  448. Re: Dead screen for a periode ???
  449. macro runs when workbook is saved, but only with vba change...
  450. Re: Data validation when pasting data
  451. Re: Daylight Saving Time (DST) and calculating time difference.
  452. pasting excel range into a Word doc
  453. Re: Temporary borders appear
  454. Save as single file webpage
  455. Stop Loop
  456. Date to be placed into Column "C" with matching value in Column "B" in same row
  457. SendKeys Help
  458. Disable Select Cells Q
  459. Extract Info From All Files in a Directory Q
  460. Search Excel and copy result into word
  461. VBA randomize vs. srand
  462. go over all the rows in data of autofilter
  463. Hyperlink Screentips
  464. How do I make this happen?
  465. Random Tab Color on sheet creation.
  466. Split last word into new cell
  467. Stop for input
  468. Re: xlExcel9795 Not Supported in 2007? 2003?
  469. Enabling a list autofilter in a protected worksheet - Excel 2003
  470. Copy Headers based on id# and data
  471. Cannot open PivotTable source file error fix
  472. Re: VBA Project Question
  473. copy method of worksheet class failed
  474. Re: Code not working
  475. RE: VBA Project Question
  476. Change the formatting of row by select a single cell & Editing should be working
  477. Too much nesting in if statement
  478. Add-in stopped working
  479. differrent fonts on parts of text
  480. Re: Find first unused cell in row
  481. Extremely slow macro
  482. Protecting Data Validation List from being modified in the formulabar
  483. Re: automate cut/insert tasks
  484. Change Cell Value when autofiltered
  485. Re: Hyperlink Macro
  486. Re: xlExcel9795 Not Supported in 2007? 2003?
  487. Menus using VBA?
  488. Rounding up to nearest 10 when "Enter" is pressed or user has clickedoff the cell
  489. Re: How do I program a macro to unlock and relock an excel worksheet
  490. Re: How do I program a macro to unlock and relock an excel worksheet
  491. Re: Excel report which excludes the blank rows?
  492. Re: need code to run when user changes value in cell
  493. Hide Macro's
  494. Re: need code to run when user changes value in cell
  495. Re: saving data in notepad
  496. Re: saving data in notepad
  497. COPYING A CHART!
  498. Always have cells add up to 100
  499. Re: Checkbox detection in macro
  500. Re: Daylight Saving Time (DST) and calculating time difference.
  501. Re: charts with calculated cells
  502. Re: Module question
  503. Re: Declare RegExp from Vbscript.dll
  504. Re: POWERPOINT IN EXCEL
  505. change of date format in footer
  506. Limit data entry to one of four cells in a row
  507. Menu for favorite macros in Excel 2007
  508. Workbook.Open fail in 2003, good in XP
  509. Define Names in Workbook through Code
  510. Re: Another Multipage question
  511. 'ThisWorkbook' Macro Question
  512. Deleting specific rows after an autofilter
  513. Creating a list of workbook users
  514. Re: Help with worksheet protection
  515. Re: Form Checkbox Updating
  516. Cancel Printing Except Q
  517. Textbox on user form in Excel VBA
  518. VBCRLF not doing anything
  519. jamping to another file excel2003
  520. Delete all code in VBA module - error?
  521. Dynamic Optionbutton Captions
  522. Delete all Range Names Except for 1 Q
  523. Searching Phone Numbers Online
  524. updating external references to cells, sheets etc.
  525. Hyperlink
  526. Re: VBA Project Question
  527. Select OR Activate ? Which when and Why?
  528. Convert date like string to serial number
  529. Handling Database connection error
  530. Need to buy a book
  531. listboxes
  532. Re: operation macro by clicking on cell
  533. Need code to convert files
  534. Issue on Close Q
  535. Problem finding pagebreaks
  536. Can Excel 2003 VBA work in Excel 2002?
  537. Create a function that sums based on two or more criteria
  538. Re: Play sub by clicking on cell
  539. Excel 2007: annoying pop-up msgbox titled "Name Conflict"
  540. Populate ThisWorkbook Q
  541. run macros local and on the web
  542. Checking for File/Directory Permissions
  543. reference to FileSystemObject
  544. Excel2003 in WindowsXP only 20% performance of Excel2K in Windows2
  545. Msgbox in worksheet activate event if design mode is turned off
  546. Automatization routine
  547. CustomTaskPanes and VSTO SE In Excel 2003... Where Is It!?
  548. Look Up Functions
  549. Change event --> cell colors change
  550. RE: Copied function is not working
  551. userform textboxes saving numerical data as text in worksheet
  552. write data to two excel sheets
  553. Quit Excel if ONLY Workbook Open else Close Excel instead
  554. Now() to be placed in Next Column ?
  555. Range Reference
  556. Drop down list of Macros
  557. Still Stumped
  558. Using Excel VBA to control Word (open document)
  559. Re: Never tried this location in excel
  560. Re: POWERPOINT IN EXCEL
  561. Re: Module question
  562. Re: problem with moving controls
  563. Update "button" references automatically
  564. Restore users Text to Columns settings -HELP!
  565. Numbers Only in input box
  566. RE: If found Then move to new sheet
  567. e-mail from Excel to outlook
  568. Re: VB macros & "relative positioning"
  569. RE: POWERPOINT IN EXCEL
  570. Automating Excel Visual Basic to Schedule Outlook Events
  571. Delete comments in the workbook except few cells: CODE given
  572. Need assistance to populate sheet from Userform data
  573. Pivot Table Code in a For loop
  574. Importing data from Access to Excel 2003 for Invoicing
  575. Importing data from Access to Excel 2003 for Invoicing
  576. I can't figure out the correct syntax for referencing a workbook.
  577. Re: Never tried this location in excel
  578. Re: Changing cell colors in a row IF...
  579. Re: Semiautomated Saving of workbook
  580. Newly created Get Function is not working when I copied the syntax from a working function
  581. Re: Changing cell colors in a row IF...
  582. This should be so simple but it's not working, please help
  583. Automatization of data entry (and return of data)
  584. Adding a Name Crashes Excel
  585. Re: Nested If
  586. Re: 3d range names/references
  587. delete module
  588. using a workbook to open more workbooks with filenames stored in cells
  589. Re: Macro for printer selection
  590. AddFromString Code -> Excel crashes ... Why ?
  591. data ranges
  592. vba code to insert an range of Excel cells into a Word document
  593. Macro to autofill formula in every row
  594. Dim as Point
  595. Re: Line up graphs
  596. Change Font Colour in VB Q
  597. Problem with counting characters VBA
  598. Re: SkipBlanks doen't
  599. Re: Email message from Excel with Hyperlink to the file
  600. File and Don't save changes - Read Only File
  601. Re: every quarter
  602. Re: Characters in Strings
  603. CMS script into Excel
  604. is hyperlink valid ?
  605. VBA Code for deleting rows with specific value
  606. Re: array lenghts
  607. Jumping bar at bottom of screen
  608. Copy / Paste between workbooks into a specific worksheet query?!
  609. Question re random addition
  610. Protect via Code Q
  611. Re: every quarter
  612. Application.Visible = True and focus
  613. Nothing, Empty and Null
  614. Totals across increasing number of Workbooks
  615. Totals across increasing number of worksheets
  616. Summarizing the files in 1 folder to one file
  617. Stupid logic is messing up again... < = > Statements crapping out...
  618. Using dcount function within user-defined worksheet function
  619. macro code to find last record in excel
  620. stop for input
  621. Error in code
  622. Custom Menus, Toolbars, etc
  623. Determine if Excel App is shutting down w/VBA
  624. Multiple Selection of Non-Contiguous Data
  625. TextBox9.Text = Range("J:J") --- New line for each cell with a value?
  626. Excel VBA Class Objects - Parent & Successor Objects
  627. Format Pivot Table Row Where ...
  628. How do I getting data from another worksheet?
  629. RE: Calculate manual spread sheet
  630. Help needed with multi-sheet routine
  631. import csv
  632. If statements, conditions and cell display
  633. Conditional Formula
  634. Run on Opening Workbook Q
  635. Handling grouped groups
  636. Day-planer
  637. Create a new file, name it and overwrite an existing name without confimation
  638. Any good books?
  639. Taking 10 lefthand characters in a cell
  640. Change Password from an Array
  641. Changing the Zoom Property of a WorkBook without using an Array
  642. Copy Range / Including Adjacent Cells - into Existing Worksheet.
  643. links to word
  644. Setting range for the VALUES obtained from formula
  645. 2 lists - extract from one all matches, edit in a new list then re
  646. Activating macro by leaving a spreadsheet
  647. Re: Keep Custom Toolbar with Worksheet
  648. getting data from another workbook
  649. Excel VBA Code Modules
  650. PasteSpecial problem
  651. how to send message to multable recipients
  652. Re: Finding first blank worksheet
  653. Using command buttons change the value in a form text box.
  654. Populate ThisWorkbook via Code
  655. Populating worksheet from userform combobox
  656. DDE links not updating after stepping into VBA code
  657. Re: Can I update vbaproject.bin in a package?
  658. Import Oracle Dbase over 65k rows
  659. Opening filenames from a list in a spreadsheet
  660. Re: Object variable or with block variable not set - what's going on??
  661. Re: Drop-down menu referencing another drop-down menu?
  662. Is it Possible to Deny Access except to specified
  663. Re: Addin Locking Excel
  664. sheetname value
  665. Do 3 Tasks on Opening File Q
  666. Is it possible to have different pop up messages to appear
  667. Name Range
  668. E-Mailing a File but property set as Read Only
  669. ComboBox – Used to Score
  670. Subtotal Report: Creating new sheet(tab) for each group?
  671. Please help! This problem is driving me crazy! Workbook sample provided!
  672. Drop Down Menu on tool bar
  673. Copy and paste to corporate sheet
  674. font color of partial cell contents
  675. Re: Addin Locking Excel
  676. delete rows where value of cell "starts with" something
  677. Excel VB User Form Using Vlookup?
  678. Take all unique values in sheet and place in 1 column
  679. Trying to delete rows and it's not working
  680. Re: Error Handling in Macros
  681. Replace font of one character in a string
  682. Re: Tough one; determine if an Access file is open
  683. Search/replace returns Formula too long
  684. could someone look at my code please and tell me what's wrong? tha
  685. Could someone look at my code
  686. Able to preserve value of variable after closing excel?
  687. Copy internet page excel
  688. RE: Need Help with Macro
  689. Email is a wonderful thing?
  690. Email is a wonderful thing?
  691. Excel crashes with a WebBrowser in it
  692. How do you do this? Uncrosstab
  693. RE: Referencing worksheet just by its name
  694. RE: moved vba code from macro to command button, now won't work
  695. MsgBox cancels "Step Into" Mode!
  696. Timer Event
  697. Link Excel 2003 named range to Access 2003 Table
  698. Re: Excel checkbox date question
  699. a simple date match?? |:(
  700. Re: formula for aquiring a gestational age
  701. RE: formula for aquiring a gestational age
  702. question on horizontal tab
  703. Re: Delete All Sheets Except "X" and "Y"
  704. copy all text files one by one and run a code.
  705. Re: Control on worksheet
  706. enable or disable a workseet control
  707. Re: Drop-down menu referencing another drop-down menu?
  708. Sorting
  709. Re: deleting empty rows within a range
  710. Re: turn off pastespecial warnings
  711. Trying to set a pivot field to a subset of values listed in range of cells
  712. Trying to set a pivot field to a subset of values listed in range of cells
  713. Using the Now() function but I dont want it to update every time the spread sheed is recalculated.
  714. Re: Have Excel file close itself
  715. Transferring Large Amount of Data from Excel 2003 to Access 2003
  716. Querying and Updating SQL Database Using Excel
  717. Re: Phantom VBA Projects (again)
  718. Re: macro to crack passwords
  719. Getting rid of "#VALUE!"
  720. Re: How can I pick up a two digit Month?
  721. Whats Wrong With This
  722. calling a method on a object that you know the string name for.
  723. calling a method on an object created in a different addin
  724. Re: Send Chart report by mail using VBA
  725. detect all printers in networks
  726. Re: Lookup or maybe Vlookup
  727. Re: Send email to multiple recipients using VBA
  728. Re: Fixed Text-Private Sub Worksheet_Change(ByVal Target As Excel.Rang
  729. Is it an IF statement?
  730. how can the necessary information be extracted?
  731. Re: Phantom VBA Projects (again)
  732. Re: copying worksheets
  733. Re: Object variable or with block variable not set - what's going on??
  734. Re: Run time error 91 ??
  735. Adding data from Form to empty rows in spreadsheet.
  736. Re: Object variable or with block variable not set - what's going on??
  737. Copy from here to there
  738. Transpose from Col to row
  739. About Save Workspaces
  740. Re: turn off pastespecial warnings
  741. Re: macro to crack passwords
  742. signed project drops signature when a macro creates a new sheet.
  743. Why did this code stop working ?
  744. Issue when accessing the property/method of a Calender control
  745. Problem with calendar planner date ranges
  746. Re: Macro written with VB in Alphacam. How do I put that in Excel?
  747. Re: Disabling Macros
  748. Re: Excel and Class, Function Structue for .NET
  749. Update MS SQL 2000 from Excel
  750. Re: Problems deplying a fix to a C# Excel add-in
  751. input
  752. Updating 0s in front of the number values in the column
  753. Wierd Bug with Format Date VBA???
  754. Count occurences of string in cell
  755. RE: How to hide/show a textbox depending on cell value
  756. RE: Command Button
  757. Finding MAX Value of Part of Cell Contents
  758. field names
  759. Re: Set Variable equal to........
  760. .PrintPreview ONLY Page 1
  761. Need help extracting data....
  762. Issue saving file in excel 97 SR2
  763. Re: Help Needed! VB Code to "Save As..."
  764. Find Selected value to .Offset from
  765. Re: Help Needed! VB Code to "Save As..."
  766. Dropdown List Syntax
  767. re: Worksheet events...Why doesn't this work?!?! So confused!!
  768. Using worksheet templates with named ranges
  769. Re: Array of UDT
  770. Re: Extracting text before a known character
  771. userform to remove from view
  772. Spin button timing
  773. Deleting Rows based on multiple criteria
  774. Problems running Excel under IE
  775. Is it possible to change the behavior of "paste" control in Excel?
  776. error 438 on ActiveSheet.Columns(16).Hide?
  777. Re: Problems caused during/after printing
  778. Re: Tough One - search for string and BOLD it.
  779. Procedure for SPECTRUM ANALYSIS of FFT coefficients???
  780. Re: If..Elseif...Else...EndIf
  781. Re: Automatically Update Tab Names
  782. Re: Workbook_BeforeClose in Personal.xls
  783. Re: EXCEL WEB QUERY PROBLEM
  784. Re: VLookup behaving strangely..
  785. Custom function acting weird
  786. Re: Testing if Directory has read/write access
  787. Error Auto Fill Method of Range Class Failed
  788. Re: Finding elements in a collection
  789. Re: Finding elements in a collection
  790. Re: Looping
  791. Re: Quality Control Macro -- Formula Anamolies
  792. Re: passing a cells content into a macro
  793. Resize Listbox Colums to match array fileds
  794. Protection Properties on WorkSheets
  795. Re: IF Formula
  796. If Active Sheet on Opening is X then do Y
  797. Re: Is there an ActiveForm command?
  798. Etiquette for borrowing code from a post by Harald Staff
  799. Hyperlink
  800. Re: Programmatic access to visual basic project via Visual FoxPro
  801. Re: Array of UDT
  802. Re: Array of UDT
  803. Re: Saving as a worksheet as a CSV file
  804. Re: Creating a macro where values are copied and pasted into a sheet
  805. Re: Macro references
  806. SelectRegion Loop
  807. Automatically have Named Ranges recognize New Data by way of Headings
  808. Re: Menu Bar Problems
  809. Dataform opening on startup, and validation list in form?
  810. Is there any easier way ?
  811. how to list calls to macros?
  812. Textbox macro - update problem
  813. Re: Delete cell names
  814. Delete cell names
  815. Button Visibility / Selectionchange Problem
  816. automatically updation of the excelsheet if i add new files in a .
  817. Modify code to Add ComboBoxes instaed of Textbox values on Userform ?
  818. CODE given: Please help to rectify the error
  819. hide ,unhide columns on protected worksheet
  820. Excel to have User Name and Password?
  821. is there a way to program my Excel file to do a loop?
  822. RE: Formatting Loop
  823. Re: Cell access within Selection.Areas
  824. find doc
  825. Re: Creating a macro where values are copied and pasted into a sheet
  826. Re: refresh calculations and external data
  827. open web page by clicking label1 of the form1
  828. Re: CASE STATEMENTS
  829. RE: hide one column skip two column and unhide one of 11
  830. Re: Copy cell contents?
  831. Re: auto-resizing UserForm window
  832. Re: Data Validation List Sort
  833. creating a spreadsheet function program
  834. Re: delete extra lines within same cell
  835. I am seek for powerful program for SEO!!!
  836. RE: Excel 2007 Functions
  837. Re: code for dragdown, minus one
  838. What is "my" cell?
  839. The date ??
  840. Re: consolidation of tables
  841. Re: Converting cells from text to number format
  842. Re: How do I save an XLS without saving my macro with it?
  843. Use real time clock within a spreadsheet?
  844. Re: Can you check the coding here please?
  845. Re: passing a cells content into a macro
  846. evaluate and variables and loop...
  847. Re: Find and move base on value
  848. Re: Application.Run correct syntax
  849. Function Help Please
  850. Making email button work after email
  851. replacing range of cells with text
  852. Excel Macro / VBA to pull up the protect sheet command
  853. Name range visability
  854. Recognizing Smart Tags in formulas
  855. Transfering Info Stop When Null
  856. Fonts and Userform and VBA
  857. Re: Programmatically Name a Range
  858. Re: Deleting cell value
  859. Re: I'm not sure it can be done but....
  860. Xcelsius Resource Needed
  861. programaticly filling a cell with a formula
  862. Re: Set of varibles produces one output. Need series of output.
  863. popluating a list box without having duplicates
  864. Re: Vertical PageBreak not Working
  865. formula determinate problem
  866. Re: formula help needed for averages
  867. Re: formula help needed for averages
  868. Re: formula help needed for averages
  869. Use variable to reference a range?
  870. Re: delete extra lines within same cell
  871. List Outlook tasks from another person's shared task list
  872. Re: simple addition
  873. Re: Why does my file say it has macros, but I can't find them?
  874. Help with Macro (networkdays function especially)
  875. Re: Why does my file say it has macros, but I can't find them?
  876. Re: auto-resizing UserForm window
  877. Cells with Values Edit
  878. randomizer
  879. Hide columns and rows then separate the spreadsheet into different files
  880. Re: Why does my file say it has macros, but I can't find them?
  881. Populating Comboboxes
  882. Macro Button reference
  883. Running totals from timesheets
  884. Weighting Costs Across Multiple Months
  885. Re: Unprotecting (with password) the activeworkbook
  886. Re: Nudge graphics down and right
  887. time stamp based on action in column.
  888. Re: Error '7' Run out of memory while filling in a cell with a formula
  889. HELP WITH LOOPS!!!!
  890. Test Cell for Alignment
  891. password userform
  892. How can I check if a pop-up menu exists...
  893. Re: Begins with
  894. non-expanding range, and also a VBA Sort error
  895. Why does Last Cell Reset to last cell available?
  896. Changing the name of a variable using code
  897. password as ********
  898. Re: Begins with
  899. Re: Begins with
  900. Pasting from Excel to Outlook with VBA code
  901. Inserting rows from "unstable" csv
  902. Re: Removing Comma's
  903. Using vb to paste records from 1 sheet, to related records in another
  904. Methods .Save and .SaveAs throw run-time error '-2147467259 (80004005)'
  905. RE: Find duplicate and append
  906. Re: Removing Comma's
  907. Automatically Append New Data in Unknown Addresses into Existing Ranges
  908. Worksheet Change - Help!
  909. RE: Conditional format via VBA
  910. Can I enforce Goal Seek to perform one iteration only?
  911. The Print # command print not all rows from excel sheet to file
  912. Hyperlinks
  913. Excel 2007
  914. Insert picture based on cell value (unlimited)
  915. Run macro by day --- but only once per day
  916. Re: Prompt user to select a printer using a checkbox within a user
  917. Enter data and press enter to move to specific cell
  918. Re: Controlling Visio from within Excel
  919. After entering data, press enter to move to a specific cell
  920. Customise Button on toolbar
  921. vb code help needed
  922. Paste area Error on my macro
  923. Re: temperature reader
  924. Refrencing Diffrent Tab.
  925. Refrencing Diffrent Tab.
  926. Cell variable name
  927. Re: xlPolynomial trendline
  928. Weighting Costs Across Multiple Months
  929. Add a live clock to Excel and change values accordingly
  930. Using Find or search for Cells with <3 Characters?
  931. How do I have Excel Macro write a open ended formula?
  932. xlPolynomial trendline
  933. test
  934. Re: Check to see icon exist in command bar
  935. Compare data from different sheets and total how many times it appears
  936. Bug in a built-in VBA date function?
  937. Re: Can Excel automatically shade a subtotal row?
  938. Excel and Outlook linking
  939. Syntax for Application.Ontime incl Variable Parameter
  940. What is the output of this code (CODE given)
  941. Re: Tiered Pricing
  942. Excel4 PAGE.SETUP?
  943. Re: How Do you Sort Worksheets in a Workbook, Alphabetically
  944. Printer/Driver
  945. Re: Create invoice from excel worksheet data
  946. Re: Formula in a Macro
  947. Arial pt. 8 ONLY
  948. Re: Assigning Macro by using code
  949. Re: Need a code to print and save file as
  950. Re: Macro How To
  951. Re: Importing file envelope infomation
  952. Re: Deleting a range
  953. remove name of addin in Tools menu: "Document Project"
  954. how do i delete a macro
  955. Re: Deleting a range
  956. Re: Removed digit from excel spreed sheet
  957. Re: Removed digit from excel spreed sheet
  958. Saving question
  959. Re: Follow up to unselecting cells question
  960. Functions that return a Range
  961. Replacement for Dsum - calling countif from aVBA
  962. Having different Y-axis
  963. Conditional Formatting using VBA Case...
  964. Macros the same but not acting the same
  965. delete modules and sheets
  966. Re: dynamic worksheet select
  967. help References in a User Function
  968. RE: copying by formula....
  969. Re: copying by formula....
  970. FileDateTime help
  971. What's up with VBA (?)
  972. Dynamic Graph
  973. Change Validation list in the adjecent cell on the Basis of Value in the Current Cell
  974. Re: Varying length records to be sorted
  975. This should be easy
  976. Creating listbox
  977. Deploying templates
  978. Disable the 'Send' button in Excel 2007
  979. Help required with VBA program to automatically enter data from a validation list.
  980. Transfer the colorindex of a cell to another, without using paste or pastespecial
  981. VBA for Excel
  982. Macro Issue with loop
  983. Keep value after deleting original information
  984. Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's)
  985. Getting RSS feed from Excel file
  986. How do I have Excel VB write a open ended formula?
  987. Sum the remaining rows and place the result in the row below the last
  988. how to make macro to combine text from 2 cells?
  989. Re: worksheet change
  990. Moving Complete Folder
  991. VBA code for message box and focus on a sheet
  992. unselecting or uncopying or whatever in VBA
  993. Omit Date from Blank Cell
  994. Why does the date change from "January 07" to a numercial value of "39038 "
  995. help with defining column only from range of cells
  996. Odd date parsing issue
  997. using a variable for MOD Statement
  998. Input Box
  999. Re: Increment number on command
  1000. Corey.....certain cell protection.....