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. uncheck a checkbox with a macro
  2. Excel 2003 Add-in with C# and VSTO 2005 doesn't show custom menu
  3. Stop the macro at the end of a certain column #2
  4. Saving Add-in in Excel 2007 (Global Macros)
  5. Calculating Age In VBA (Chip Pearson)
  6. Value in column
  7. find / findnext question
  8. Copy selected sheets to new book
  9. If a cell in a worksheet is less than Q...
  10. creating number sequence
  11. NEED MACRO TO GET BALANCE
  12. Autofilter - delete filtered selection
  13. How to paste clipboard into textbox sheet?
  14. Loop Help
  15. Faster way to read data from old file to new
  16. Help with passing data
  17. Trim Workbook Path?
  18. Find Executable Path with Excel
  19. Re: Min If function by Part number
  20. Re: DataBase worksheet function
  21. Find specific values in three columns of a ws
  22. RE: DisplayFullScreen=False not working
  23. Copy logo from sheet1 to new sheet3-10
  24. Open PDF located in excel with macro
  25. Update Link Continue prompt
  26. Need help with IF
  27. Date in formula
  28. Printing last entered values
  29. Re: WorksheetFunction.Match applied on an Array
  30. Re: WorksheetFunction.Match applied on an Array
  31. Re: Problem copying from a hidden worksheet (data is copied, but alsoadditional sheet info)
  32. VBA code with and / or statement
  33. Converting Excel to TIFF
  34. Re: Problem copying from a hidden worksheet (data is copied, but alsoadditional sheet info)
  35. Excel 2007 Range.ServerActions Property displays read-only data
  36. Protect sheet and still copy
  37. Range Name
  38. Re: DisplayFullScreen=False not working
  39. Re: Difference Between Range("SelectedRange").Value and ActiveCell.Val
  40. Re: Image Loading
  41. Copy values only
  42. Re: Code to find specific number and calculate
  43. Re: DataBase worksheet function
  44. find max value in one field, return values in other fields in same row
  45. Can I create a file to send to other's that updates module 1?
  46. Hiding "modules"
  47. NEED MACRO OR FORMULA
  48. timing sensetive code?
  49. Passing ParamArray to another function converts it to TWO dimensions.
  50. AVERAGE FORMULA PROBLEM
  51. return the number of rows
  52. excel to sql server (frequently)
  53. Run-Time Error (8000500d) - The directory property cannot be found
  54. Using parts of a defined range for UDF
  55. How to "Quit"....Input Box
  56. Add sheet
  57. hide worksheet tabs
  58. Macro to select files and then run different macro on selected file
  59. Select Method of Range Class Failed
  60. MACRO OR FORMULA NEEDED FOR CALCULATION
  61. Mouse Wheel Control with Combo Box
  62. Calling Excel using DCOM
  63. Quicker Counting
  64. Can't Display Userform
  65. Need help with handling localized currency formatting.
  66. How to keep a formula from being over written?
  67. Why does this macro fail (1004)
  68. Change a field and delete row
  69. Gauge/Dashboard Charts
  70. Macros deleted from an Excel,but I keep getting security warning
  71. Code for Error handling using F5 from debug mode
  72. Is it possible to send a "variable" to a userform text box?
  73. please help! Replacing blank cells from a userform textbox
  74. Pole value of Option buttons
  75. Template Question
  76. Combo Box
  77. find and replace name of links
  78. Macro or Formula for Calulation
  79. Click to show value in active cell
  80. Show which entries in Search Table duplicates or triplicets
  81. cell update includes original text
  82. Update excel
  83. excel update graph
  84. User form programming help needed?
  85. How to write data in array to range on worksheet
  86. Bypassing Excel's FTP login/password dialog
  87. Sharing/Exporting a custom tool bar
  88. Programming the Command button
  89. Fixed or floating command buttons
  90. Hide sheet
  91. hide sheet
  92. Custom CommandBar visible dependent on active sheet
  93. cell value from different worksheet
  94. ComparingColumns
  95. "can't enter break mode at this time" message when adding a projectreference
  96. Copy & paste...if
  97. Need assistance with simple Excel macro or code
  98. c.column returns a number - I need an "A" or "B" or...
  99. Probably too easy...change range to be one row down.
  100. Incentive Spreadsheet Problem
  101. Insert Autoshapes in excel
  102. Validation list functionality disappered
  103. Macro to export data to fixed width not saving right justifcation
  104. Select sheet based on cell value
  105. no empty values in inputbox
  106. Deleting a textbox
  107. Formatting a textbox
  108. Code not working correctly
  109. Request for Responders to Posts
  110. Dynamically load data into a pivot table
  111. VBE question
  112. LOCK THE CELLS
  113. copy cells contents to access form
  114. Reference to free-form textboxes
  115. Looking for Help in modifying a code
  116. Importing from Excel sheet with unknown name
  117. Adding a macro to copy worksheets
  118. Execute a Macro from one excel Application to another Application
  119. Copying of consecutive Rows, one at a time and pasting it in onelocation
  120. How to count number of different cell formats
  121. count of dishes that contain specific ingredients
  122. Ribbon UI onAction causes macro to run twice, with warning
  123. Hide Column without data
  124. Looping question
  125. tabs
  126. custom error messages
  127. what is wrong with my fun ,thanks
  128. Help needed with Error Handling
  129. Macro links to other workbooks
  130. Msgbox freezing in beforeprint module
  131. Essbase Add-in
  132. Issues with Combo Box change event
  133. SheetChangeEventHandler Problem
  134. scroll records with distinct value in column
  135. Inser row with the format from the row above.
  136. Please need your help
  137. Macro help needed
  138. Excel sheet protection
  139. limit on the delimited list for Data Validation.
  140. VBA Coding Question
  141. Copy Sheet into another workbook
  142. Sheets.Add Function
  143. cut and paste into cisco device (equivalent to pasting into notepa
  144. Create a report page???
  145. PivotTable: Need to detect when user selects new value for dropdow
  146. Excel spreadsheet to talk to mainframe
  147. Cost Sheet
  148. Excel and Visual Basic
  149. disable "unprotect sheet" in tools menu bar with VB
  150. issue when opening a workbook through a macro shortcut
  151. Macro to delete rows with matching Credits and Debits
  152. VBA Mod, Excel Floor, etc.
  153. Macro work - but don't think it is very efficient
  154. A Two-Level SOLVER ??
  155. Determining the number of open workbooks
  156. Accessing Outlooks address book via VBA embedded in Excel
  157. Options for replacing toolbars in XL 2007
  158. editing data in a database from a Userform Textbox.
  159. Calendar on userform is blank
  160. .IQY loop in VBA?
  161. udvidelse tabelmatrix
  162. vlookup or index match
  163. VBCompononts.Name...
  164. Stop baby eating in CHINA
  165. Cell Auto Fill from Range of Cells
  166. Error, Excel 2000 & 2003
  167. csv file convert to excel file
  168. Trouble opening file
  169. formula for vlookup 2 cells
  170. BeforeRightClick
  171. Check last two characters of a string.
  172. Color rows by "group"
  173. Macro ends early without error message
  174. Trying to delete existing unwanted horizontal page breaks
  175. need Macro
  176. Macro appears 5 times
  177. using named ranges in vba
  178. cells not registering as blank
  179. Specific use of INDIRECT inside VLOOKUP...
  180. Min IF Function Needed
  181. Need some help with this code:
  182. Hide all Sheets in Workbook then Close Workbook
  183. creating a macro to print PDF
  184. excel2k FormatConditions question
  185. Problem with code - Help
  186. How to clear Immediate Window programmatically within a procedure?
  187. Macro Properties Password Popup.
  188. How to see value of UDT variable while single-stepping?
  189. RE: macro does not work inside Excel 2007 #2
  190. COM Addin function
  191. Migration Project
  192. Help with Error
  193. "Object required" error
  194. Rosh Hashanah and Yom Kippur Holiday Dates Revisited
  195. sorting in multiple sheets
  196. Listbox finding the adress of the item
  197. convert hyperlink to email address
  198. Txtbox set focus
  199. creating a macro to add text to existing data already in cell
  200. Value not shown on selected ActiveCell
  201. Iterate over a Range of data - create arrays or ranges
  202. How to prevent Excel to paste data in separate cells
  203. substring check
  204. Using range names in SQL query
  205. protection not working
  206. Info onto Web page
  207. MACRO
  208. Looping Paste Special Value Transpose
  209. Receiving 'Error 1004' with VBA program
  210. Block Of Numbers Repeating in a Formula
  211. Status & Formula Bar Disabling Prevention Among Other Opened Workb
  212. don't allow excel event kill
  213. Hyperlink to TIF File - Not Trusted
  214. 2003 vs 2007
  215. Alternative to ShellExecute
  216. Creating task in outlook from a particular row in excel
  217. Range Selection help (Formatting)
  218. Sorting Question
  219. Use Code for Demo
  220. Protecting worksheet
  221. UDF returns #VALUE! when regional language setting not English!?
  222. Input Box Default Value
  223. Dimming Toggle Button
  224. Code To Send Mass Email
  225. Multiple Goal Seek
  226. Setting up a per unit bonus formula
  227. MIN IF Function
  228. Tools Menu disappeared??
  229. Autofiltering and copying selection to anotherworkbook
  230. command button invisible upon opening file
  231. Re: Updating Properties of a Control on a Worksheet - THANK YOU DAVEPETERSON!
  232. Prevent "Add-Ins" from appearing in Ribbon
  233. LookUp?
  234. Cell name
  235. Saving a single worksheet
  236. Creating multiple emails from one Excel file.
  237. How to make this fire at every page break??
  238. Stop the macro at the end of a certain column
  239. How to create a list of dates (not including weekends)?
  240. Userform TabStrip questions
  241. is it possible to pass a reference to a function as an argument
  242. checkbox property
  243. indirect address offset in array formula
  244. IS there a way???
  245. find a value in a column, if it matched, highlight that column
  246. Cursor Position After Sort Operation
  247. XLL programming for Mac.
  248. Exists similar function to the PROC but that it returns the super
  249. Write text data to text file without quotes
  250. Existe uma função parecida Ã* PROC mas que devolva o valor superior
  251. Command button "selected"
  252. Drawing a Circle
  253. User selection from a chart
  254. Copying from one cell to another cell
  255. Copy + paste macro
  256. Updating Properties of a Control on a Worksheet
  257. Excel 2007 - Drill-through action called via VBA locks the workshe
  258. Min If
  259. Need help in Excel Programming
  260. MS Query and Integer fields
  261. Update links & calculations upon command
  262. Problem copying between worksheets
  263. Create muliple event procedures via VBA
  264. want help
  265. How to copy this to another cell exactly?
  266. Find a textstring in a "Range" - and then return a value iftextstring is found.
  267. Auto complete cell from a list of choices
  268. How can I send file by different email address (to; cc and bcc)
  269. What is planned to replace VBA?
  270. Insert Row without affecting page breaks
  271. How do I create an alert in excel programme
  272. Searching and adding in a closed file
  273. Naming modules
  274. Macro for copying and pasting values based on criteria
  275. Make global Macro/Add-in for all active Workbooks/Sheets
  276. checkbox1 linked to sheet1 a1
  277. time elapse on userform label caption
  278. Find number - where did I go wrong?
  279. Macro If Then Question
  280. Losing Module Level ENums in Excel 2003
  281. FileSearch to locate the latest (last saved) file
  282. capturing current range of cells
  283. Special effect on User form
  284. Custom Worksheet Collection
  285. For What kind of computer was Excel created?
  286. Drag picture
  287. Anyone know how to program transfer of CSV data to web page form fields?
  288. Displaying published htm file from remote share
  289. Sum after every blank cell
  290. Pivot Table Refresh Updating all to same data
  291. Case Statment in Err trapping
  292. display userform4 for 30sec's
  293. Macro
  294. Displaying question
  295. Range VBA: double entry table
  296. Range vba: double entry table
  297. Function to find last value in a column
  298. function to find last value in a column
  299. GetValue from closed workbook
  300. tutorial needed
  301. Two short questions
  302. Type Mismatch
  303. link checkbox to cell
  304. Renaming individual columns
  305. Please HELP me!!
  306. Zoom in/Zoom out picture
  307. if internet on then ... else ...
  308. stop command does not trigger
  309. Workbooks.Open oddity
  310. Print user form and add menu bar to the form
  311. UserForm ComboBox
  312. Range as Variable
  313. Excel data types
  314. addition to a remote cell
  315. Make PivotCaches.Add(SourceType:=xlExternal) from VBScript code
  316. Autofilter Check
  317. Format a number field as text
  318. Turn of Autofilter Arrows?
  319. PivotTable with all row label visible
  320. problem with Excel file created programmatically
  321. Stop Recording Macro
  322. Summary based on field indentifier?
  323. Update check box from cell
  324. range and variant
  325. Prevent Copy action Q
  326. Allowing xlBook.SaveAs in Access code to overwrite existing workbook?
  327. named cells
  328. VB code is not shown when recording drawing objects
  329. Update from Excel 97 to 2007
  330. Type mismatch error only on the first run
  331. calculating working hours between 2 dates
  332. How to suppress XML import error message
  333. Image (Picture) from Excel Cell Data?
  334. Define Print Area using Variables
  335. security Level settings in Excel
  336. Placing a formula in a cell of an unconstant row location
  337. Context sensitive hekp
  338. can't undo Full View with macro
  339. Performing a Macro within a range
  340. Before Print Problem
  341. Discontiguous Chart Source
  342. SQL.REQUEST in Excel 2002 not supported in 2007. What is new func
  343. making listbox without horizontal scrollbar
  344. Process a range from bottom to top
  345. launch excel, auto-open second excel file
  346. Different Macro behavior when called from Immediate Window vs. She
  347. retrieve data from web
  348. Another Excel Problem
  349. Feed Multiple Comb Boxe with same list
  350. Hiding a PivotField
  351. Hide or delete "Add-Ins" in ribbon
  352. Call to Sub Routine which exists in seperate workbook
  353. Code Help Needed
  354. how to test if range object target deleted
  355. Macro Enable after Disabled
  356. Force cell to have Accounting Formate
  357. Keeping whole formula constant to new workbook
  358. Progress Bar
  359. replace string
  360. Problem with locked file
  361. confine cells to two digits
  362. vacation.pto calendar
  363. Excel 2007 VBA - Run-time error 1004
  364. still having trouble
  365. Odd Save As behavior
  366. Row number of cell containing specific text
  367. Need to move last number in a column
  368. vba Cancel Save As
  369. VBA Sum returns Wrong Format
  370. Select a Range By color
  371. The name ... either conflicts with a valid range reference or isinvalid for Excel.
  372. Excel 2003 Dates - Strange behaviour
  373. Excel 2003 Dates - Strange behaviour
  374. Alphanumeric Recognition
  375. Find Text, Add Border 6 Columns to Right
  376. Add Item to Recenly-Open Files
  377. Locked for editing problem
  378. Build a Worksheet that pulls info from other Worksheets
  379. Excel to Schedule Task in Outlook
  380. Closing temp worksheet without saving
  381. Shell Out Failing
  382. Need Class Module examples...
  383. Persistent Storage for Add-Ins ?
  384. Starting Excel and doing "stuff"...
  385. Power API
  386. Variable File Name Activation
  387. XL2002 - trigger sheet event BEFORE deactivating
  388. saving open workbook to text string in cell
  389. Excel 2007; OutlineLevel-Problem
  390. Run macro in background
  391. Remove a line from a text file
  392. Delete defined text in a column
  393. Chart sizing
  394. Master's please help me with my code; Doing a loop to copy valuesfrom a series Sheets of another workbook..
  395. Avoid displayalert message while opening file
  396. No double space
  397. "End" Button for Error Messages
  398. combobox change fires on workbook close when textcol <>1 or -1
  399. Teaching Excel
  400. Add Userform Image from Cell Picture Address
  401. Find a string within a string
  402. Set EnableAutoRecover to False
  403. Display alert if data exists
  404. totaling criteria
  405. Re: How to make a selected row visible in the Window?
  406. offsets - using ranges
  407. Selecting range of cells to copy using a variable
  408. IsEmpty - what's the opposite?
  409. Lookup in VBA
  410. Last Used Cell
  411. Rosh Hashanah and Yom Kippur
  412. Variable causing subscript out of range error
  413. Delete Sheet without Warning
  414. SP3 and RefEdit Control
  415. Create header/footer txt file and link to Excel worksheets
  416. Macro copy of variable ranges in one sheet to table in another she
  417. defining a variable containing quotation marks
  418. formula
  419. Adding a WHERE statement
  420. Named ranges and links
  421. Selection.Copy used in a variable.
  422. Function used in conditionnal formating not using good language...
  423. Dba query filter taken from Excel
  424. userform
  425. Custom Save As
  426. group (add) numbers without exceeding 168
  427. SaveAs produces subscript error
  428. Hide Buttons When a Cell is False
  429. Delete Last 10 Rows in Worksheet
  430. Check if workbook open (Not working)
  431. Excel Problem
  432. Selecting a dynamic name
  433. Isolate group of names from Drop down list
  434. Custom Save As
  435. Using Variables in R1C1 formulas
  436. VBA solution required?
  437. Capture Excel close
  438. Sheet Tab Color, Excel 2000 & 2003
  439. vlookup in VBA - 30 sheet lookup
  440. using a formula in a program
  441. How to update Shape pictures
  442. List objects and Buttons
  443. date function
  444. Type mismatch passing arrays via COM
  445. Excel Shapes selection problem
  446. Before Close Event Hide all Worksheets then Close Application
  447. The Great Gatsby- Importing multiple external data files
  448. force a selection from a list of words
  449. SQL Problem
  450. vbMsgBoxSetForeground
  451. Unable to loop on Excel collections. Error 451.
  452. AxInterop.OWC11.dll license question
  453. 2007 cannot enable macros?
  454. manipulating arrows
  455. Re: How to make a selected row visible in the Window?
  456. sheet selection via user click (yez)
  457. Double Click Event Error on Worksheet
  458. Selecting only some characters, using "characters property"
  459. Excel Add in - VSTO on Pocket PC/Windows CE
  460. security warning
  461. Opening/Closing Large Files
  462. Lock a named range
  463. INSERT ROWS
  464. Help Fixing a Macro
  465. Combine several macros
  466. GetOpenFilename and filter "*."
  467. How to make a selected row visible in the Window?
  468. Export comments to document
  469. How do I link Excel to a dynamically column named access table?
  470. Macro does not work inside Excel 2007
  471. Cannot Edit Active-X Control
  472. Code to check errors in excel 2002
  473. Calculation/Number Bug in .xls? Any ideas?
  474. Re: Seeking advice for complex charting algorithm (16K attachment)
  475. Opening Word Docs from Excel VBA With full path and name > 255 chars
  476. Handling Errors When Opening Word Docs From Excel VBA
  477. Code seems to have not copied fully
  478. Importing data seems to interfere with auto-scheduled macro
  479. Issue removing leading and lagging spaces
  480. Sort by changing number
  481. Set CommandBars Dropdown value
  482. duel criteria seach
  483. duel criteria search
  484. 2 parrameters to filter
  485. Create named ranges in Column on worksheet
  486. RE: Programming a macro to draw info from a list of links
  487. Excel ScrollBar - Don't Move or Size with Cells ...
  488. Can't create workbook with VS.NET 2005
  489. How to add the same cell in multiple worksheets (with VBA)?
  490. checking a range for at least one
  491. Can you copy a worksheet from a workbook wothout opening it?
  492. CutCopyMode -- What workbook was copied?
  493. Passing Null Value to Range Property
  494. Re: Copy specified columns to another sheet
  495. Can't get the macro to continue through a range
  496. RE: Updating Cells after comparing two worksheets
  497. Vba Vbe export
  498. Help with macro comparing data in worksheets
  499. Re: Enter the result of a formula using VBA
  500. Determine if Carriage Return or Tab key is used
  501. editing data in database from Userform textbox
  502. active workbook/sheet
  503. Custom Header
  504. Copy/paste new worksheet to master worksheet
  505. mail sheet as body from userform
  506. Math headache
  507. RANGE MACRO
  508. New funny recruitment video for Microsoft..
  509. Schedule downloads in VBA
  510. RE: Form not found
  511. RE: Form not found
  512. InputBox buttons
  513. Find checkboxes and then check them
  514. workbook_open() sub does not work
  515. Connecting to Access
  516. Re: PC and Mac
  517. Macro Fault on Custom Ribbon
  518. Error Msg when opening Excel 2007
  519. Selecting a range after activating a worksheet
  520. Code loops to death every time I attempt to add a string to a cell
  521. RE: PC and Mac
  522. Create a user-defined function
  523. xlDialogImportTextFile txt file name
  524. Macro to format text
  525. having trouble disabling "save", "save as" (2003)
  526. add names
  527. RE: Date Format
  528. Formula to VBA function (if and lookup)
  529. RE: loading automation add-in for an instance of Excel
  530. Taking info from all sheets and compiling it without spaces
  531. Copy/Paste Charts; Define Destination of Charts in PowerPoint
  532. Groups in Option buttons
  533. RE: Using autofit on cells which include ASCII 10 (LF) character
  534. RE: Examples of "Front Office" usage of Excel
  535. Next Worksheet in code
  536. Determining if Button on worksheet is hidden
  537. macro comparing values from 2 worksheets
  538. E-mailing from Excel Q
  539. disable shortcut key from menu control
  540. insert rows programmatically with formula change
  541. Vlookup to VBA
  542. Entering text in Excel cell
  543. Vlookup syntax format
  544. problem uninstalling an add-in
  545. Unable to access any Programming capability
  546. How to start Office application in Automation mode via Office itself?
  547. Why does this code not work for me?
  548. moving excel 2003 data to sql server
  549. Copy from cell above
  550. error opening a workbook
  551. Using macros to condense a template
  552. Sum Visible Cells Only
  553. record the maximum value in a cell
  554. Folder Contents to Excell
  555. Error '' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
  556. Placeing data from sheet1 to sheet2 via a form button
  557. Placeing data from sheet1 to sheet2 via a form button
  558. Placeing data from sheet1 to sheet2 via a form button
  559. Excel 2007 XmlMap.ExportXml producing empty string
  560. Macro for copy
  561. Are we back on line?
  562. Data Fill in Visual Basic
  563. Please HELP me!!
  564. Auto Start Macro in Excel
  565. Programming Outline Expand(+) / Collapse(-) Functionality
  566. Copy IF condition exists
  567. Inserting a row
  568. Paste Special MS Excel Worksheet range selection into Outlook Task
  569. Interior.Color from a function yields Error 1004
  570. Insert a row
  571. Create a task from a userform
  572. Excel/SQL Problem
  573. Need to get value of last number in a column
  574. Macro works but is there a better way
  575. XML Mapping - Update Schema
  576. DsoFramer and Excel
  577. finding charcters for UDF
  578. CHRW
  579. Export To Xml
  580. select the data and copy in another sheet
  581. Insert new column and paste formula
  582. disable a menu control short key
  583. How to Diagnose Why "Code Execution has been interrupted"
  584. Referencing a named range in another workbook
  585. Using the name in a cell to open/activate a workbook
  586. VBA and Password Protection
  587. Need value of last number in a column
  588. check if excel sheet in manual calc mode
  589. check if excel sheet in manual calc mode
  590. Excel files linked
  591. Disable all toolbars apart from custom toobar
  592. Moving Spreadsheets with formulas attached, between workbooks.
  593. Type Mismatch error
  594. Check cell address for double alpha characters
  595. create outlook task from excel
  596. uninstall-add in
  597. SQL and Excel problem
  598. Code for running macro on save
  599. uninstall add in
  600. Alpha/Numeric help
  601. search column and display results in msgbox
  602. uninstall an add-in
  603. Find String in Cell then Paste Sum in Offset Cell
  604. vb code for data transfer
  605. Date Picker Behaviour
  606. paste special excel worksheet range into outlook task body
  607. Copying a range to a separate excel database
  608. Number format
  609. Search from bottom of column up column and delete to top
  610. Code to run macro on save
  611. Form keeps the focus unable to get to code - HELP!
  612. Nested If's
  613. vlookup on changing range
  614. selecting target sheet as an input
  615. data arranging
  616. Visual Basic Form
  617. Files linked to one specific file.
  618. about data copting
  619. question on scope of a global variable
  620. range as listbox column
  621. Chartspace Data Source and Connection String Problem
  622. Schedule Downloads
  623. Schedule downloads
  624. importing more than 65536 rows from .csv file
  625. Schedule downloads
  626. Changing cell color based on a value in another cell
  627. Given Address, find named ranges that contain it
  628. Alpha Numeric help
  629. clearing duplicate values in Column A
  630. Finding Maximum of Two Numbers in Array
  631. touch screen with excel
  632. Need help to have macro populate a column with formula to end ofcolumn.
  633. If data exists in column J, put formula in column K
  634. Select Case
  635. Excel Controls
  636. Calculating column based on formula
  637. CAN ANYONE PLEASE SOLVE MY PROBLEM
  638. formula
  639. vlookup working in one instance, but not another
  640. Copy Chart and Insert in new Sheet as picture over the same location
  641. Paste special function in macros fail if we disable application cellDrap Drop
  642. Understanding and comparing stock market figures
  643. Exception when adding a array formula
  644. CORRECTION NEEDED
  645. Text upside down!
  646. Strnage bug when pasting charts
  647. Running a Macro from another Macro
  648. Value NOT placed in 2 sheets, but in ALL others
  649. Everything You Need To Know About Printed Lanyards
  650. Speeding up slow code
  651. Next Without For Error
  652. creating sheets macro crashes after 26th sheet
  653. Multiple IF Statements
  654. Excel 2003 / VS 2005 Automation Add-In
  655. Changing cell color based on value in another cell
  656. SheetSelectionChange when modal form is shown
  657. macro that identify the newest file in a folder and open it.
  658. Programming SendKeys
  659. Query SQL Server with concatenated text from Excel
  660. Help Number formatting of actual data not just the view
  661. Vlookup to VBA
  662. setting a list in a combox doens't from a range
  663. cell color condition
  664. Data Retrieval from spreadsheet
  665. Pivot table help
  666. Find Text the Insert Sum
  667. Cascading Combo Box & Content Filtering
  668. Find Text the Apply a SubTotal Next to Text Address
  669. Excel Chart Macro Issue
  670. Digital clock that continuously updates from NOW()
  671. Add line in existing macro to use template
  672. Right Click menu doesn't appear in Page Break View
  673. Query Update from Access: Re Ordering Columns
  674. Excel 2003 vs Excel 2007?
  675. show Comment using INDEX
  676. Numberformat applied but does not change data
  677. Defining a variable range
  678. setting variable direction in visual basic
  679. Capturing Undo Values
  680. Adding and removing extra pages
  681. Automate Data Entry from .xls to IE
  682. Run Time Error 1004
  683. Reading Values Between Sheets Based On The Condition
  684. Code for export
  685. Insert Symbol in VBA
  686. How to capture the cell above
  687. automatically input data into SAP R3 from Excel
  688. find own user posts
  689. Reset values in a combobox
  690. take user clik as an input
  691. Set array of objects to nothing
  692. Macro to copy/paste
  693. Copy to datasheet -Message for Ron De Bruin
  694. Exiting a Sub when called from another Sub
  695. Serial Order
  696. Macro with vlookup with variable sheet
  697. user can't use workbook when already open
  698. Check/Option box from Excel list
  699. Building a COM add-in...
  700. Macro stops for no reason
  701. Logical tests
  702. Error: If Range("AZ" & intCounter).Text = "" Then
  703. Data from Excel to Word bookmarks
  704. Compare Two Rows Directly
  705. close file -> open and save
  706. 2008->2003 incompatibility
  707. EMPLOYEE WEEKLY SCHEDULE
  708. zoom in &zoom out in VBA User Form
  709. print each row in the list in the combo bos
  710. Disabling the "Design Mode"
  711. Select an empty cell
  712. PasteSpecial issue
  713. Code to get Max Value in a perticular cell in ALL Sheets
  714. Userform problem
  715. Tools/Customize question - toggle Show/Hide Comments without a macro
  716. Shade cell if No value in offset cell
  717. hiding rows with merged cells using macros
  718. Using formula in a macro?
  719. change event
  720. using rowsource to fill a combobox
  721. Day of Week
  722. Control Number - A better way
  723. Cell Update on Paste
  724. Shortcut Key Assigned to Imported Macro (i.e. in personal.xls) Does Not Work
  725. Should TD be HTMLTableCell?
  726. getting the entire range before be filtered
  727. Loop through table of columns and rows
  728. additem removeitem
  729. Macro to schedule downloads
  730. Help me to first row matching First date and last row matching lastrow
  731. Excel workbook save behavior using VB6 very confusing
  732. Delete Specific Sheets
  733. How to Place a Drawing Object on a Worksheet as a Control?
  734. Macro Copy Excel Chart Sheet to PowePoint - Mod of Jon Peltier code
  735. DialogActiveCellFont
  736. Need to paste/update info to correct row.
  737. Return Control to Userform
  738. List Box Highlight Selection from Sheet
  739. How to populate web page forms from Excel or DB? Is this possible?
  740. Match function not wokring on 2D array
  741. automatically create list of the worksheets
  742. Issue with marco for entire workbook
  743. find error
  744. How to install missing DBNamespace 1.0 Type Library
  745. Find first empty row in a range
  746. automating (alt & f11)
  747. Automatic Toolbar
  748. Stripping HTML tags from excel
  749. Set message subject here ...
  750. Excel has encountered a problem and needs...
  751. macro to return value of worksheets
  752. writing a text file in the same folder as my program
  753. referencing to external name range that would update automatically
  754. Sorting problem
  755. Linked file Excel 2007
  756. Excel file linking
  757. Excel tables vs. system tables
  758. Running macro in one workbook that refers to variable in another
  759. Delete Row Select Case
  760. I have the slowness problem also
  761. match function - date and time
  762. Subroutine Summing and Outlining
  763. Getting a range using row & col numbers?
  764. Retrieve selected data from Network file
  765. Error Handling Help
  766. Re: Need Help Converting Date & Time Stored as Text
  767. alt & f11 via macro
  768. too much space
  769. User Form
  770. Cannot hide columns/rows
  771. combobox dropdown
  772. how to identify a shape as a picture in excel from VB
  773. error 70 permission denied in excel
  774. prefix in text box
  775. E-Mailing macro font options
  776. Formula for day of the week to relate to corresponding date cell
  777. Checking Web Queries
  778. add total from 6 textboxes and put in label
  779. last cell as label caption
  780. show userform/hide workbook
  781. Naming Ranges with code
  782. Displaying programatically worksheet errors messages in a cell
  783. Insert Row & format as per other rows, above/below
  784. manipulating Query data 'on the fly'Question
  785. lastcell
  786. "Toggle Switch" help needed
  787. force text/numbers in text box
  788. range value as label caption
  789. Addins - number of columns & rows in running version of Excel
  790. Re: lable caption
  791. Triggering macro
  792. Select a series of cells
  793. Searching for a value for and then replacing when found.
  794. Concert number to time
  795. Ok what's the trick to do this?
  796. How to extract aggregate values from PivotTable
  797. Cancel Button on file save
  798. test
  799. recently used file
  800. Saving multiple worksheets to a master file
  801. Excel Macro: Selecting items from another worksheet withoutactivating it
  802. loop help
  803. Loop help
  804. Add dimesion to Array already populated
  805. Sort Data auto on cell range when updated
  806. Help! Refrence a userform element from a textbox?
  807. Help with code
  808. Help! Refrence a userform element from a textbox?
  809. Create VBA function that returns many values
  810. Shell Command Fails (sometimes)
  811. Atofill Questions
  812. Passing result of multiple split function results to 1 Array
  813. sheets
  814. How to copy from each sheet and paste to a summary sheet
  815. Prevent a Worksheet from being deleted
  816. Get Save Prompt when closing workbook immediately after savingworkbook
  817. how to save a file and overwrite existing file
  818. Date and Time
  819. MS Excel 2007. ActiveChart.ApplyCustomType
  820. Restore "Delete..." and "Insert..." shortcuts
  821. Using Excel Interop via VS.NET 2005 to create and save a new Excelworksheet.. please help!
  822. "Call" Commandbutton1()
  823. Excel 2007 VB function call return value syntax question
  824. Office 2007 VBA Compatibility??
  825. Filter and count hidden cells problem
  826. Set position of non frooze rows when panes are frooze
  827. Extracting Text between 2nd and 3rddelimiter
  828. Multipage Tab vs Regular Userform
  829. how would i wrtie this formula
  830. VBA for Exporting to Text file
  831. Opening workbook in same directory
  832. passing an argument
  833. Show Time Stamp in Cell when Command Button Clicked
  834. dynamic source range change in pivot table
  835. Copying across values based on criteria
  836. every fifth line
  837. Macro triggered by date
  838. error
  839. Connection problem using DAO
  840. Using Outlook Express for this Newsgroup
  841. Delete Row if value <>
  842. Delete a workbook...
  843. Excel Addin Install via Registry
  844. Leading Zero in .csv format
  845. copy cell until data doesnt exitst anymore
  846. can I copy "2" different Ranges from closed workbook (VBA)
  847. Open, print, close multiple pdf's from macro
  848. If JobNumber = Val(field(7)) Then Query
  849. Userform Programming
  850. hyperlink to sheet with name in cell
  851. Change event for several Textboxes on UserForm
  852. Advanced Filter Error 1004
  853. Search a column to match textbox value from a form
  854. Macro to merge text and delete rows
  855. Combobox drops down blank row
  856. Zero values in Pivot Tables
  857. PivotTable Show Properties in Report - stange behaviour
  858. Macro for export
  859. Updating workbook from protected workbooks...
  860. Input box
  861. ListBox
  862. Force CAPITAL LETTERS
  863. Problems printing Webbrowser Control with a worksheet.
  864. Print To WorkSheet
  865. Excel Macros sending attachments to multiple e-mail addressescontained in one cell.
  866. Automating excel though outlook
  867. re : Copying a range from WB01 and pasting to WB02
  868. date and time
  869. How do I GetCurrentDirectory in Excel?
  870. Count Sum Problem
  871. Re: UDF that returns a date
  872. RE: Worksheet Change from Add-In
  873. how to add
  874. Re: How do I create a Graphical Report from Survey responses in Excel
  875. Re: Worksheet Change from Add-In
  876. Microsoft Office 2003 Web Services Toolkit 2.01
  877. Worksheet Change from Add-In
  878. format cells so they do not resize
  879. Re: default fill color
  880. Re: UDF that returns a date
  881. RE: default fill color
  882. UDF that returns a date
  883. Send parameters in worksheet button > 255 characters
  884. default fill color
  885. How do I create a Graphical Report from Survey responses in Excel
  886. cell is merged and contains "something"
  887. How to create .HLP for my VBA project
  888. Excel Macros: Sort which is not Worksheet Specific
  889. Rows & Columns Disaggregation Help
  890. Making code global in workbook
  891. Excel file open in memory?
  892. How come VBA if clause fails?
  893. New user and need help
  894. consolidating workbooks(not sheets)
  895. Linking rows on multiple worksheets
  896. Check column for a value and if not there execute series of functi
  897. Pasting while in edit mode
  898. Protection on a sheet type thats new to me!
  899. Is Active Cell in a Range?
  900. UDF and dynamic range
  901. select and delete all pictures in a given range
  902. Skipping empty cells for a Range object?
  903. Indirect.ext Function Isn't Working for me
  904. How to create msg box if a cell contains value < 0
  905. Run procedure from worksheet change event
  906. Can a For statement work in reverse (from 40 to 1)
  907. multiple if then statements
  908. Analysis of 2 groups?
  909. Digital Certificate Question - Help
  910. Running total of Found Substrings in MainString in Big Loop
  911. Copy data from Microsoft Word form into Excel
  912. cell data
  913. Re: Prevent Text to Integer conversion
  914. Can't save any more in Excel 2007 Compatibility Mode
  915. VBA code executes fine, but compiler throws error. Huh?
  916. perform the same calculation in several spreadsheets
  917. Comment Automargins property
  918. User form
  919. Print causes crash
  920. F9 not working with SumByColor
  921. Run Time Error '91'
  922. Newbie floundering in the VBA code
  923. Another runtime 1004 error
  924. InserPictureInRange method for excel VBA
  925. Blatt-Schutz und Zellen formatieren
  926. find a string in one cells
  927. events
  928. DAO Syntax Problem
  929. VBA to delete leading space
  930. Disappearing Userform Label
  931. Help with VBA runtime error
  932. Activate an variable located workbook and copy 2 ranges?
  933. GETPIVOTDATA with date in referenced cell
  934. Email .From
  935. ComboBox search for variable...
  936. Logical functions AND,OR in array formulas work ?
  937. Creating Outlook Task from Excel
  938. Executing a macro
  939. how to display cell value in formula
  940. searching for shapes
  941. On Cell click, start macro
  942. On Cell click, start macro
  943. .NET and Python Programming with Resolver One Spreadsheet
  944. VLookup if criteria matched
  945. How to concatenate in macro across sheets
  946. Pivot Table Deconstruction
  947. Protect part of Insert comment
  948. Pay Reconciliation
  949. ask user to select a target sheet as an input for a macro
  950. vlookup - table array in cell
  951. 'Moving cells'
  952. Scroll function in VBA
  953. Retain focus of IE using DocumentComplete
  954. Is there a fancy way to open a workbook in a minimized window stat
  955. trouble loading a range into a comboBox
  956. Reading data from PPT and purge data to Excel and image
  957. still get runtime error 424
  958. Is Pivot table the way to go?
  959. Dumb newbie Q re. passing cell addresses to a UDF.
  960. Access Fields in Lotus Notes DB Forms
  961. run time error 424 object required - how to load control on Userfo
  962. Open "Insert Hyperlink" popup window with VBA?
  963. Prevent rows from being selected
  964. Delete Rows based on cell value
  965. Excel spread sheets do not close from vb.net
  966. Pivot tables - how to hide the total row?
  967. multidimensional array
  968. Excel Macro Help for Charts
  969. Fill down a row
  970. Excel Macro for Charts
  971. getting Runtime Error 1004
  972. Cell Content
  973. How can I see assembly code for VBA routine?
  974. Custom Cell Format Question
  975. Simple Code but slow
  976. Looping through a range
  977. Using Case and referencing a cell instead of a value
  978. Covert Columns to rows Macro
  979. Unwanted recalculation of UDF while running a Replace-statement
  980. Conditional Formatting in a For Each Worksheet Loop
  981. DAO connection problem
  982. Dynsmic Charts
  983. Macro Help - ASAP - Please!
  984. How do I change Date Format ??
  985. Autoformat screws up with FormatConditions?
  986. VBA to create button on sheet after copy and to change the caption
  987. is blank
  988. Re: How to tell spaces between values in saved text file from theorig
  989. VBA code to find macros associated with command buttons in an s/s
  990. conditional formatting
  991. Combo box help
  992. Track Changes Data
  993. copy a dynamic column range in macro?
  994. Lookup in numerous sheets
  995. Re: Autofilter Question
  996. Find end of number and copy/paste 5 columns
  997. Coping Range from another Excel file
  998. Excel automation on server
  999. Macro codes automatically opens when opening a excel file
  1000. assign value to cell on different sheet