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. Can I prevent a user from running a macro?
  2. afterupdate event in Excel
  3. Conditional Format to highlight differances between to sets of data
  4. Any way to add hex numbers?
  5. For each, Next - 4 worksheets
  6. Pivot table
  7. restore sheet
  8. Macro to select a cell in a table from a reference in a different
  9. Copy Up To Top 10 To New Worksheet
  10. Graphics question
  11. How do I resolve recordset overflow?
  12. Can I add data to a pivot cache?
  13. VBA for Virtual Earth
  14. Last saved by
  15. Sales Schedule
  16. raw of code..
  17. need more than just 3 conditional formatting.
  18. Create custom wildcard for searches?
  19. automatic unique value extract
  20. trying to make a simple search.....
  21. worksheets scrolling
  22. Can't change pivotfilter value1 parameter in code
  23. Get errors when updating PivotFilters
  24. Date formats change (code included)
  25. transitions in ms excel
  26. Delete data Help!!
  27. closing a workbook with a macro
  28. Save user entered value in hidden lookup table.
  29. Test for File Creation Date
  30. Processing groupbox values
  31. How do I select a range to merge cells?
  32. Recongnizing #N/A as cell contents
  33. close workbook event
  34. Kill all files in Folder, If folder exists
  35. Copy row from one workbook to another
  36. serial port
  37. Run a macro from a vbyesno Msg box response
  38. Compile error [Chr(13)]
  39. colour palette reset
  40. Disable links to other workbooks
  41. Hiding option buttons
  42. Lost from memory
  43. HOW DO I DETERMINE AN EXCEL FILE CONTAIN MACROS OR NOT WITHOUT OP.
  44. for next loops in visual basic excel
  45. Second Sunday in the month of May?
  46. Top 5 most recurrent values in range.
  47. Delete Column having specific word/value
  48. Enable / Disable Buttons
  49. Reinstall Custom toolbars
  50. Inputbox & “Processing…” window
  51. Open file for output
  52. XL2007 .CodeName bug when copying sheet
  53. Tracking training by percentage
  54. conditional format - put inside a for/next loop
  55. Setting a cell background color
  56. Programming Validation
  57. Some Error on e-mail
  58. Include "00"
  59. Converting CtrlShiftSpacebar to VBA code
  60. Creating a Custom Worksheet Object
  61. workbook code window
  62. Instruct to start in Row 5
  63. Insert data into SQL Server db - find out the record number
  64. For Loop
  65. Run Macro based on cell change
  66. Trigger Macro based on single Cell change
  67. Trim Entire Column
  68. Textbox not filling from listbox
  69. excel macro
  70. Excel 2007 ang "Group row" option
  71. truncate text in each cell in column
  72. MsgBox responce If statment
  73. Run Macro at specified time
  74. HELP: Performing multiple cell changes in a range - converting text to numeric
  75. print embedded multiple page OLE objects
  76. VBA searching through range and pasting value if no match is found
  77. Importing stored procedures into Excel with parameters
  78. UDFs and Conditional Formatting?
  79. Excel 07 vs. 03 "listrows" reference <subscript out of range>
  80. Generate data with all combinations
  81. Sending PDF with Outlook
  82. LOOKUP, MATCH MORE MATCHES IN TWO COLUMN
  83. Select only Text duplication
  84. Can Add-in determine if macros enabled in another workbook?
  85. Calling a Sub in Personal.xls
  86. XL2007: Copying worksheets between workbooks
  87. Split LastName, First Name column into 2 seperate columns
  88. How to move data from many spreadsheets to one
  89. Help with Correct Call for Ron de Bruin's "RDB_Last" to Find Last Row in a Column
  90. What code for repeatedly copy, paste values ??
  91. Changing properties of a file with VBA
  92. How to get a permanent Range address?
  93. Out of control Active Cell Indicator
  94. ChartWizard difference between Excel 2003 and 2007
  95. How to list Workbooks associated with VBA Code.
  96. Textboxes not populating from listbox
  97. Getting a "Read-Only" error
  98. wait msgbox for 3 seconds only
  99. Random Cell Value Display?
  100. Trigger VB code on user selection from Page field in Pivottable
  101. Email Workbook - Outlook object model (attachment) - runtime error
  102. auto close in Excel 2007
  103. change pivot filter through code
  104. Edit Cell with "/2"
  105. function to modify other cells
  106. 2003 vs 2007 Macros
  107. double sound alert for on-line stream
  108. Class module Question
  109. Problem with MUI and Excel Add-in
  110. Copy two sheets into new files and save to multiple locations
  111. how do I pass myfunction(A2:A4) instead of myfunction("A2:A4")
  112. Headers and Footers by VBA?
  113. Sorting a range with duplicate values
  114. Which Dialog Button? (XL95 in XL2007!)
  115. ADO Connections
  116. OR
  117. prevent doubleclick for command button
  118. How to Activate and Dropdown a Combo Box
  119. sumproduct problem
  120. macro
  121. Loop within a loop
  122. Link an IF to a Vlooup
  123. Formula Array - Syntax Error
  124. Determining if Cell has Formula
  125. Deletion of Data across multiple sheet
  126. execute a macro from a dialog box on enter
  127. Problems with mouse in Excel Automation from VC++ 6.0.
  128. strange behaviour
  129. Transfer files & change file attributes with VBA ?
  130. Workbook_BeforeSave not working.
  131. Ranges vs cells with VBA
  132. draging formula
  133. script help!
  134. IF function to get a (specific) name from a Vlookup and convert va
  135. PERSONAL CRASH
  136. Automatic Unique Values
  137. Running a macros every Monday, Wednesday, and Friday
  138. Cell specific code
  139. Validation list problem
  140. Define the Range of a drop-down list
  141. Link an IF formula with a cell containing a Vlookup formula
  142. Combo and List box combination
  143. Counting unique formats in a workbook
  144. switching between workbooks
  145. userform duplicate control not working in my code. Thank you
  146. ShowMe function works fine except I need the offset to adjustdepending on column
  147. Connecting Excel to Access Using Late Binding
  148. Counting backwards through the File System Object files collection
  149. setting ranges and vlookup in custom functions
  150. Flashing Cell for a number range
  151. Calculating Staffing on a Schedule
  152. Contiguous Ranges and 255 Char Limit Constraint
  153. array formula doesnt work from row 32737
  154. Text box macro button...need it to remain stationary.
  155. Listbox Change events triggering when i "Save As"
  156. Format Paste from nonmerged cell to merged cell
  157. Cells Within Range Failure?
  158. Improvements to code
  159. Auto Open + Disable on Final Product
  160. Populate an input box in a macro
  161. Open Access DB in Excel 2007
  162. Duplicate Group Names
  163. this newsgroup on easynews
  164. Closing multiple workbooks?
  165. Excel macros in XL2k Pro vs Std
  166. Use loop to filter, copy/paste to new sheet; run through entire li
  167. Combining Variable Sized Ranges
  168. Multipage default open
  169. search box
  170. Changing tab order of locked worksheet cells
  171. I want 'Enter' to be a line break in a text-box
  172. Sort in Office 2007
  173. Reading Comm Port in Excel
  174. Change cell colour to red
  175. How to: If autofilter is "all" then, else...
  176. changing a color based on another color change
  177. vlookup function
  178. Getting r/t 13 - Type Mismatch on this line - Why?
  179. Count all "xlsx" fromat files in a Folder
  180. Doughnut chart with VBA
  181. COM Controls in Excel
  182. Next blank cell
  183. Remove Middle Initial
  184. Delete row/s with the same elements as the above row
  185. Deleting a sheet with VBA
  186. VBA ".Clear" Error
  187. insert table into specific location
  188. Help with converting code - import > 65536 from Access
  189. Find, Copy and Paste
  190. Please Help on Object Library Invalid or contains....
  191. Sumproduct VBA
  192. comparing 2 worsheets using a macro
  193. Another Simple GoalSeek question ??
  194. What do I need to do o = New Excel.Application
  195. Code acting weird with sheets with collapsed groups
  196. Calendar Control Linked Cell
  197. linking pivot table selections
  198. How do I create a Reset Button on a form created in Excel
  199. Two problems inserting a formula
  200. Override a built-in command with a macro
  201. AutoSize a cell comment
  202. Font in MsgBox?
  203. count number of times a particular letter appears in a cell
  204. Excel Security Update 2003 (KB955466)
  205. Totals An Easier Way??
  206. Number Stored as Text Issue
  207. For each chart loop not working
  208. Excel code
  209. Translate to code
  210. Using Offset on two seperate worksheet
  211. Active Workbork Issue
  212. Delete row with the same elements as the one above
  213. Working with Linked files
  214. Calendar control (view/layout problem)
  215. If A1= yes then calculate index
  216. Delete Entire Row for duplicate values in selected column
  217. How to Select Successive Groups of Individuals for Trendlines
  218. Finding the last used column
  219. Using Query to return data from SQL database
  220. RUNTIME ERROR 1004
  221. Macro to select only cells containing values within named range
  222. change pivot table in code
  223. New VAT Rate
  224. how to wright this formula in VBA code
  225. Assign Shortcuts
  226. Importing .csv with #2000-04-06 10:15:00# date format field
  227. How to expand or stres row summaries back to row details?
  228. How do I add properties to add-in ?
  229. Marco that will run if the condition met 2
  230. Excel / SQLite
  231. Finding ways to identify last row of every printed page
  232. Open file dialog box works in XL2000 but not in XL2003
  233. Continue running macro until last line of data.
  234. Adding a right-click context menu to Excel VBA TextBoxes
  235. Macro to select data Validation List Item
  236. Conditional find and copy to different worksheet.
  237. Changing font color based on type cell it is. How to do it?
  238. code stops working after X rows.
  239. Using Ron's Sub Copy_to_Workbooks
  240. Use CASE?
  241. Alphabetical sort but includes the expanded section when it rearra
  242. Changing hour and minutes to percentage of hours
  243. Change Value of Cell in Printed Title - Print Preview Event?
  244. What is wrong with this?
  245. List out the "Find All" results list?
  246. Copy and Paste + erasing date
  247. a few adjustment for a do-loop escape
  248. sumproduct in VBA
  249. Create Object for MS Mail
  250. time formula
  251. to many e-mails
  252. Copy Row 2 from Sheet1 & Paste to Row 10 Sheet2
  253. Status Bar Message
  254. Text box last entry
  255. Start my Application in its OWN instance?
  256. Autosize
  257. copy adjacent cells also and put totals at the end (for copied cel
  258. How to enter a non-standard format hyperlink
  259. For every empty cell in a column, copy the value from the above ce
  260. conditional formating
  261. Copy data from new file in a folder
  262. Date value
  263. Change a pivot field based on another pivot field
  264. Run time error 53, cannot find file
  265. Finding/Moving Columns within Macro
  266. Assigned macro change
  267. Vlookup - Multiple Sheet HELP PLEASEEEEEEEEE
  268. Functions
  269. Reapply filter
  270. Filtering Automatically
  271. my incomplete macro to fill in 8000 rows - pls help
  272. Run code conditional on sheet visibility
  273. Close form when I press enter
  274. Change MS Access query from Excel
  275. User input - string on userform
  276. batch update excel with add-in
  277. How to change MS Query via VBA
  278. Sumif
  279. Following a web query with a macro
  280. Color cell font text based on cell type? How do it.
  281. Splitting a row of email addresses
  282. Match, then Look Left 4 Columns, then Loop to End of Range
  283. Copy picture from http to local drive?
  284. Error Message: "Can't Execute Code in Break Mode"
  285. Picture in spreadsheet to picture in userform?
  286. Multiple workbooks - NEED HELP
  287. ASP.NET 2.0 in Visual Basic Language
  288. error with chart object
  289. Match six digits and copy specified row
  290. macro to keep chart dual axis format
  291. Data filling question
  292. Excel Application Examples?
  293. How to order numbers
  294. Dynamic Userforms,
  295. looping through txt files and pasting into a excel worksheet
  296. Conflict Between Two Add-Ins
  297. List of open workbooks and their User Names from Folder X
  298. Formatting borders
  299. running change events to macros
  300. Print Access reports from Excel
  301. Naming Check Boxes
  302. Run a procedure in all the sheets of the workbook.
  303. Select item in dropdown using VBA
  304. Hiding columns with shaded headers
  305. SelectionChange Question
  306. sort alphabetically a combo box list
  307. Correction Needed in Macro
  308. Re: Workbook has [Group] at the end of teh file name when opened
  309. Special sum of texts
  310. Clearing Validations from many worksheets
  311. Re: sytokromi-c wikipediassa
  312. Marcro
  313. excel does not opens on IIS
  314. Probklem with code, when merged cells
  315. Multiple if statements in one cell
  316. Question for the Probability Mathematicians
  317. Automatic Alphabetical Sort
  318. Simple Macro to "Lookup -> Repeat"
  319. Matchv values on two different excel workbooks
  320. Input box with dropdown list of all sheets
  321. Office Assistant 2007 ?
  322. Re : Excel AutoFilter Drop-Down Window
  323. Download & Upload to Online Sheet
  324. Use a VBA function to return a factor
  325. Runtime 1004 Error Help Request
  326. Reading from a protected range in Excel
  327. Hyperlink syntax??
  328. Creating a macro
  329. Autofilter
  330. simple code
  331. Parsing a string
  332. Remove an obsolete worksheet from an addin.
  333. Macro to grab data from a chart
  334. Weibull function return an error
  335. Deleting Rows
  336. Taking Flat Data in Excel and Making it Relational in Word
  337. Excel Macro Help
  338. Problem loading an array
  339. Macro to Break into Seperate Columns
  340. Help Modifying Ron de Bruin's MergeAllWorkbooks Subroutine
  341. Range syntax help for a VBA newbie
  342. Find and Replace
  343. Cell coloring giving me fits
  344. Workbook_Open command fails and blows up all cell formulas
  345. Excel automation failure
  346. Date Computation
  347. Data Search
  348. 2 dimensional array
  349. VBA Help
  350. Print Area Range Selection
  351. Nested Do While Loops
  352. Replacing code
  353. filedialog in conjunction with printing to a text file
  354. Chart Type - numeric values
  355. Problem with list not showing after a macro running
  356. Can warning messages be suppressed in Excel?
  357. Adding values to a range
  358. Receive data from barcode reader in VBA
  359. Folder size
  360. Run-time error 9
  361. Why does the following custom function always return a "value" err
  362. Resetting Keyboard Shortcuts
  363. Need to save a range as a text file
  364. skip rows depending value of a particular cell in that row
  365. GammaDist function error in error
  366. Help with deleting rows
  367. Get Data from One sheet to Other
  368. Launch IE with Table
  369. Leading zeros in IP address?
  370. Method 'Height' of object 'ChartObject' failed
  371. Focus problem??
  372. custom function closed workbooks
  373. Finding Chart Series Problem
  374. Question on using Ron de Bruin's Excel menu sample code
  375. Open a new file and format the tool bar.
  376. Hide rows that doesn't match cell
  377. Unable to access complex arithmetic functions in VBA for Excel 200
  378. Assing a Name to a Range
  379. multi Loop efficiency
  380. Msgbox Close with vba
  381. Combo Box font Change
  382. Reading the characters in a cell
  383. I need help with VB code
  384. vba run-time error between 2 difference releases of excel/access 2
  385. how to display 2 lines depending on one cell
  386. Formula with MID() not working
  387. Condensing working code
  388. Autofit / Remove formats VBA Code
  389. Copying and Pasting a picture from one sheet to another
  390. Object required error
  391. Macro to remove rows
  392. 2 columns processing
  393. Extracting the Time from a Date/Time Stamp
  394. Replacing via macro
  395. Reset a User Defined Types Values
  396. Macro that opens an xls file then saves it with another name
  397. Find the minimum and maximum date in a list
  398. Problem with Lifeboat Hang error and DDE
  399. Macro for removing error values in cells.
  400. What reference is needed to select the progress bar control?
  401. Data Validation - Do not want to allow pasting into the cell
  402. pick calendar date and day
  403. Inserting cells using VBA
  404. Formula in Excel to get additional column values associated with M
  405. Deleting Duplicate with a Msg box which displays no of duplicates
  406. How to save current filter of Table(ListObject) and to apply it la
  407. Using VB, remove a certain section from ThisWorkbook
  408. Lotus Notes CreateObject
  409. Turn off read only attribute on shortcut
  410. RE: Formatting a Chart Based On What Values Are Displayed
  411. RE: Formatting a Chart Based On What Values Are Displayed
  412. ignore error
  413. Duplicate Detection with Message Box
  414. Vlookup in a Macro
  415. Access command from Excel
  416. xlValue et al.
  417. Incorrect name on pivot table
  418. Automatic formula entry, file save and cell blanking
  419. Pasting Selections from Multiple Sheets along with their Sheet's Name
  420. Poor Performance on LARGE Excel workbooks containing formulas
  421. fill weekdays with date
  422. Hyperlinking to a hidden workbook
  423. sumifs to other workbooks
  424. RE: Copy data from range
  425. A Question on Ron de Bruin's "Copy a range from closed workbook" function
  426. Time issue
  427. Select range
  428. How can you change cell attributes in a function??
  429. convert US date format to Excel readable
  430. Programmatically modifying code using VBE in a protected project
  431. drop first row in range and return a new range object
  432. Custom NumberFormat - international version
  433. dropdown box item to display a message
  434. How to set LastCell?
  435. Events for CheckBox inside Excel using ExcelAddIn project
  436. Last cell in column
  437. Inserting Dashes
  438. Any body to crack it ?: Print Week Category based on range for mon
  439. Marco that will run if the condition met
  440. Labell Height
  441. How to calculate time difference in hrs
  442. Print specific ranges in several sheets
  443. last row in column
  444. Hello:
  445. range.createnames method
  446. how can i count multiple variables in multiple columns?
  447. macro- keep value in cell and add value for adjacent cell
  448. Date selector combobox
  449. Enlcosing code inside if- then no longer works
  450. Match 1 cell of record and Transpose 2 cells to another sheet.
  451. delete the non blank rows
  452. Edit cell value
  453. Function to retrieve embedded URL link?
  454. Why this "error 9"?
  455. code to automatically compress photos
  456. Edit Column Letters
  457. Sorry for this: How do I stop receiving all the emails about newposts?
  458. VBA Code for Custom Date Filter
  459. Resize problem
  460. Constant execution of ListBox.Click
  461. How to generate on a chart or spreadsheet a date line marker
  462. How to control if a cell references versus list box or another cel
  463. trying to create a form that will stop you if you leave a cell bla
  464. Filter Records based on the value selected from a drop-down list b
  465. Problems with repeated call of userform
  466. VBA Expected end of statement ERROR
  467. Help with macro
  468. Formula... like text
  469. Dates between two sheets...
  470. Macro to take latest data
  471. Excel not recognizing module.
  472. Re: Print all Sheet2 of all Workbooks in Folder
  473. Execute code on a range of cells, then move down and do again?
  474. Help Modifying Macro - Merge multiple sheets based on a condition
  475. Re: Macro Adjust Based on Dataset?
  476. Adding MAcros using C#
  477. Sheet Protection Properties lost
  478. Macro Adjust Based on Dataset?
  479. This clever code ain't doing nothin, why?
  480. Trying to create err msg if cell is left blank
  481. slow (and wrong?) For...Next loop
  482. Excel/Access Question
  483. How to write Excel GUIs with VS2008 Express
  484. Excel selects multiple cells with mouse click - how to stop this
  485. comparing rows in a range with another row in a nother range
  486. Excel Matrix problem
  487. XL2002 - ActiveWindow.Zoom = TRUE (to selection)
  488. How to bind events for formsControls inside Excel
  489. Print all Sheet2 of all Workbooks in Folder
  490. sending excel worksheets by email
  491. After Running AddIn - continued
  492. After running AddIn, application needs to be re-drawn
  493. Open file with custom button
  494. Want delete rows if A have value and O not
  495. Zoom problem with shapes in Excel 2007
  496. Copying Chuns - A part of the whole Field - from Access to Excel
  497. Use macro to delete worksheet without specific name Eg:Sheet 1
  498. Code pause when disconnecting from Terminal Services.
  499. Opening word from within xls
  500. FollowHyperlink causes error
  501. delete the non blank rows depending on Column
  502. Print Week Category based on range for month
  503. Password on forms
  504. combobox list range
  505. Problem using =HYPERLINK() formula rather than literal hyperlinks incells
  506. Pivot Table help
  507. Excel 2007: macros disabled on new Vista machine
  508. Match Entry
  509. approve email macro
  510. Data Validation List
  511. Form Location on Screen
  512. UserControl
  513. SeriesCollection object
  514. comibantion of various functions
  515. Close Projects in Project Explorer
  516. Question on Custom Views
  517. modify existing macro
  518. Turn off Autofilter but leave rows hidden.
  519. User Type vs. Variable
  520. Issue with my Loop Function
  521. Delete rows based on date input
  522. Name disappears after Application.Run
  523. How can I cut+paste formulas+formats?
  524. Tool bar to follow spreadsheet
  525. Custom Format use with MATCH function
  526. Command Button or Macro that will email a spreasheet
  527. How do I create a multiple selection list box in Excel with VBA?
  528. How do I create a multi selection list box with VBA code?
  529. Count Unique Records in Filtered List
  530. Clearing an integer variable
  531. Code to Minimize the riboon
  532. Visual Studio and Excel
  533. refer to active window when more than one window open for a file
  534. VBA Userform - Editing Controls (Similar to Dataform) (Excel 97)
  535. Search and Replace via VBA
  536. Question on copying a range
  537. Remove All White Space
  538. Converting number into words
  539. Excel Sort changing 10 to 1
  540. ActiveWorkbook.RefreshAll waiting time
  541. Reading more than 255 chars from Excel.
  542. Problem accessing Sub routines in Addin modules
  543. Use of UCase
  544. Start a macro when a vlooup formula shows a new value
  545. referring to columns by number
  546. Modify a remote cell
  547. Dictator Apps and Excel 2007
  548. Run-time error '-2147352571'
  549. Create a macro which populates a powerpoint slide from excel tabel
  550. Subscript out of range
  551. Macros from C#
  552. Copy and paste data using macro
  553. Build Array
  554. Find Yellow error code
  555. Problem with For Each loop
  556. XmlMaps "java_Map40"
  557. Extracting file from a zip file
  558. Clear frame color
  559. Swap values in userform txtboxes
  560. Macro to FIND/REPLACE
  561. Data crunching according to criteria
  562. custom function color
  563. ello:
  564. insert label in worksheet
  565. leading zero issue when converting to time format
  566. startup macro does not execute
  567. Compile error - help
  568. Reading Chunks of Excel Data
  569. Prompt for saving a saved workbook
  570. MS Access Records
  571. Renaming Worksheet
  572. onmouseover event
  573. Where (menu) find "fill color" and define/add a new color?
  574. Run-time error ‘-2147417848(8001
  575. userform size
  576. Select a sheet and return
  577. Range referencing incorrectly
  578. Change Inches to feet and Inches
  579. fibbonacci series, with time function
  580. tooltiptext on textbox
  581. With statement question
  582. Can I use worksheet data in headers?
  583. HOW DO I ADD ONE COLUMN TO A SECOND WITHOUT DELETING THAT VALUE
  584. Creating working with Class
  585. Speaking error?!?
  586. Macro in add-in runs depending on if sheet exists in workbook
  587. Copy Name Range in single Cell
  588. How to apply SQLOpen Function - Excel 2007
  589. Numbers in words
  590. Selecting a worksheet
  591. Problem with formula
  592. parsing email address into another email string
  593. Remove an inserted picture
  594. Array Code issue
  595. how to write this in vbe ???
  596. Remove shape at series point (2007)
  597. Fill Array from a Range
  598. Get the Name of the Add-In Workbook used as a Reference
  599. How to Fill a String Array
  600. Extracting Specific Numbers in a String of Text
  601. Inset a picture
  602. Hiding All Checkboxes when I open/close the workbook
  603. Text to Columns - Saving User Settings
  604. Hide/Unhide CommandButton by cell criteria
  605. Track Changes using xlt file.
  606. Creating Custom Menu in Personal.xls Workbook_Open
  607. Macros always available in Personal.xls?
  608. Userform Question
  609. Update Access 2007 Table Using Excel 2007 VBA
  610. Save As Macro
  611. Modifying a range of cells
  612. Difference between times (Answer in minutes)
  613. Set Array equal to Range
  614. Searching across columns
  615. Product of 3 Cells based on criteria
  616. How to replace the background color of all cells from light green to light blue?
  617. filter
  618. .bat file to enter password protected .xls sheet
  619. COUNTIF accross multiple worksheets issues
  620. scroll so that the upper left cell in a range moves to the upper left of the active window
  621. select cell after sorting
  622. Macro should run on a specifi time.
  623. chart range to include variables - Macro
  624. Cell = "YES" then CommandButton2 Visible
  625. Keep the track of persons how opened the sheet and made changes.
  626. How do I require data entry in a combo box in Excel?
  627. How to code "Switch Row/Column" for Excel Chart
  628. setting constant path
  629. Command Button not copying with attached macro, help
  630. How to inhibit non-interactive MsgBox display
  631. copy data
  632. refresh combobox
  633. What am I doing wrong with Ranges named within Macro...
  634. Excel 2003 & 2007 menu compatible menu by Ron de Bruin
  635. Hidden Characters
  636. Auto height adjustment to fit on a single printed page
  637. excel unique values in column
  638. isolating TaskPanes between documents
  639. Can you make Range Equal All Values in an Array?
  640. Using Excel as Interface for big SQL Server Tables?!
  641. sheet selection without knowing name
  642. Trapping errors.
  643. Put numbers in column B cells when Value Change in Column A cells
  644. Can Sendkeys be used to send a selected no. of characters in a sin
  645. Delete selected worksheets
  646. DDE automatic refresh
  647. Application.Speech.Speak
  648. Nothing selected in my list box?
  649. Interior color disappears
  650. Count Dates in a range
  651. Code to assign a macro to hundreds of option buttons at once
  652. Please help with macro
  653. Last cell in active row--I know, I'm sorry
  654. Custom Function Add-In not working
  655. RE: Last cell in active row--I know, I'm sorry
  656. :
  657. Macro Letters
  658. workbook event, only to certain sheets
  659. Populate Combo Box with Values from CSV File
  660. macro's with if function included
  661. C# Excel Named Range Cannot be Found Due to Web Service Data Delay
  662. Can Excel Link two tables on seperate sheets?
  663. cells with null or no data
  664. copy shortcut to desktop
  665. VB control's text/caption is ugly - keeps resizing
  666. Day test question
  667. vlookup few books
  668. Re: Split Print Area - One Page Print
  669. Runtime error 1004
  670. Merge Multiple Files
  671. named range
  672. VBA code does not copy and paste to next row for each zip code
  673. Capture the Source Address of copied data
  674. Average last seven if not zero
  675. Error Msg - Object variable or With Blockvariable not set
  676. If Range ("C22") <> = 0
  677. Order of Drop-Down Menus
  678. Can you Filter using names from a generated list???
  679. Where to store lookup table
  680. SENDKEYS and brackets
  681. PasteSpecial error message
  682. Find Workbook in multiple instances of Excel
  683. help Vba
  684. Blocking column insertion
  685. Automating mail merge from excel
  686. Macro for deleting rows and serialising the remaing rows
  687. Load Values from Worksheet to Userform Controls with Loop
  688. Macro
  689. Question about checkboxes
  690. Perform calculation in Excel and store in Access
  691. Date formatting
  692. Pivot Data fields - removal of all (value) fields
  693. Grouping data with VB script or function?
  694. Excel 2003 : Problem accessing childnodes in XMLDomElements
  695. Re: word wrap from shrink to fit
  696. Set a counta function result in a for loop (Macro Excel)
  697. Macro Help!!!!!!
  698. Merging cells and copy!
  699. Re: word wrap from shrink to fit
  700. Script works in forms element but doesn't in normal option button
  701. Seems a bug in setting Style.Orientation property
  702. Find & Replace with two condition in VBA
  703. How to create a Linked (text) table in xl vba to a .mdb
  704. Cell Color condition using IF... ELSE statement in Excel
  705. Calculating Average Daily Balances
  706. Does Rowfields exists?
  707. GetOpenFilename() errors
  708. I want to insert pictures from from file
  709. Bug in my code
  710. Underline and Bold 4th numeral
  711. Display data from a cell in User Form
  712. Need help on Excel 2003 Macro Visible Property
  713. Copy Column D from all worksheets in WB1 and paste in sheet1 WB2
  714. E+16 in number
  715. disable EXCEL macro runtime-error
  716. find and findnext
  717. Club membership list / database
  718. Volatile UDF not updating
  719. 3-position switch control
  720. Repeat Character in VBA
  721. Userform errors
  722. Replacing Values
  723. formula doesn't work
  724. find duped value <> 0 and change to 0
  725. Combine multiple cells into one cell.
  726. How to use Header "Text" as Sort Key
  727. re: optimization for formatting worksheets
  728. Char(10) or Char(13) in body of email
  729. Load Userform Control Values from Worksheet
  730. Edit Button image
  731. Macro stops running at an unexpected time
  732. Load Userform Values from Sheet with Array & For...Loop
  733. How to copy and paste a partial row (i.e. not the EntireRow)
  734. macro to find data from one sheet & copy in another sheet
  735. Paste values only
  736. Autochart top 20 percent
  737. Filling/referencing cells from User Form
  738. macro to send email
  739. Delete rows based on date criteria
  740. Assistance with Loop construction
  741. What's causing error message?
  742. Help with Slow Print Routine
  743. help on creating five folders
  744. VPN Connection
  745. Looping Checkboxes in Worksheet
  746. Excel 2000 and XML
  747. Macro to set an html anchor?
  748. Help! Ungrouping Excel Charts --> EMF/WMF. Can't edit objects in 2007 (Freeform issue). Steve Rindsberg?
  749. Re-driecting a pivot quarterly
  750. After getting value from a cell need to make five folders under th
  751. ActiveSheet.Shapes("Rectangle 23").Select will not work in 2007
  752. Module protection & Shell issues
  753. remove duplicates, keeping latest dated record
  754. named range
  755. Auto Check-out / Check -in
  756. How can I create five folders after this with a spacific name
  757. Check Out / Check In
  758. Loop web query & pivot table...?
  759. block printing of defined tabs
  760. Searching in excel
  761. If 80 in column A and date >= today...
  762. how can i find ' as the first characture in a cell using vba
  763. C# and Excel: how to get reference to Excel VBA form
  764. Need SUBSTRING like function
  765. Autocad & excel
  766. Alternatives to VBA for Excel programming
  767. Controling Chart Names
  768. Event Handlers: Getting a handle to the calling object
  769. Excel Date Issue
  770. C# For Excel Courses - London UK
  771. rename & hide worksheet problem
  772. Name of Pivot Table
  773. My own fiscal year
  774. Precedent arrow - link number
  775. Code will not run
  776. Get data from existing sheets in workbook
  777. How to create an 40230 error in the VBA Project?
  778. microsoft script editor
  779. MS Query
  780. Cannot open 2 projects at the same time
  781. Preventing Auto_Open() runnng on vpc -Holding "Shift" doesn't work
  782. HELP with macros
  783. Devolving code to a DLL
  784. How to disable keypress in combox?
  785. CDO and Exchange Server 2007
  786. Macro to change Userform Textbox Font attributes
  787. Can a vlookup be done on a 2 dimensional array?
  788. Zoom Q
  789. Consolidating Code
  790. RE: creating a new folder with a value of a cell on the C directory
  791. creating a new folder with a value of a cell on the C directory
  792. Inputting a formula with a Macro
  793. VB code to fill next available cell
  794. create a macro to move one cell to the right w/o specifying range
  795. Find and replace in code
  796. hep with Loop
  797. excell novice needs helps
  798. Print each column seperately in Excel
  799. error message
  800. Cell cursor neglect cellinfo.
  801. New to Visual Basic
  802. Insert Dynamic Formula
  803. vba script to logon to another application like iseries
  804. macro runs fine but error message is displayed
  805. Spreadsheet Object in VB Form (Excel 2007)
  806. Filling Zip by City
  807. How to select info based on date
  808. Shift down and then to the right
  809. How to use a pointer in an IF Statement?
  810. Invoking "cmd" from VB macro
  811. covert xls to xml
  812. r/t 2110 - Can't Move Focus to control
  813. Conditional formatting ... or VBA programming help
  814. VBA corrupting Cell A1 in CSV file
  815. How do I call up a line of code that references a cell/range in theactive workbook workbook where I am running my macro from?
  816. UserForm cancellation
  817. ActiveWorkbook.RefreshAll
  818. Backup Addin
  819. Hyperlink
  820. Can't get rid of multiple project references in VBA
  821. code to mark coloured cells in excel
  822. Insert space before CAPITAL letters
  823. Error with Selection.CurrentRegion.Rows.Count?
  824. Ole timeout
  825. Method 'Range' of object '_Worsheet' failed in Union of 3 Ranges
  826. Formatting for the whole worksheet
  827. Worksheet CodeName property
  828. Screen Update
  829. Copy from a text box
  830. Programming on excel sheet
  831. deselect one of the shapes
  832. why won't this work?
  833. ShowAllData error
  834. Is my ListBox empty?
  835. message box on cell content
  836. conditional formatting
  837. Getting r/t error
  838. Last Cell In Row
  839. search locked cells
  840. Cannot Dechiper Encoded String
  841. Can you apply a comment to a range of cells (as opposed to just one) ?
  842. look to do an Offset of something like a offset
  843. Range problem
  844. Data Consolidate duplicates data...
  845. Rename Sheet tabs from list......
  846. Code error
  847. Outlook - Pull contact from Outlook into Excel
  848. Text Box colours
  849. Input Box
  850. Concatenation of Text
  851. Auto run macro when file is saved
  852. Run-time error 9 - Subscript out of range
  853. Helps on Custom Views
  854. a problem with savaas method
  855. Macro needed to copy groups of data from one spreadsheet to anothe
  856. Can I create a link from a cell to take me to another worksheet?
  857. Retrieve result of query from Access
  858. Varioable in SQL statement
  859. Switch to Excel workbook in a separate instance of Excel
  860. Populate worksheets fro a Master List
  861. macro not found, but it is there
  862. Data Validation
  863. macro not found, but its there
  864. Programatically get to Named Ranges in Name Manager (Office 2007)
  865. file name as specified cell when save as or save is clicked
  866. worksheet to track vacation accrual by employee and cost/job cente
  867. Copy Sheet causes Combo Box change event to fire on original sheet
  868. Should I use sumproduct function?
  869. Convert Decimal to Feet and Inches
  870. Excel Date Format Macro
  871. Access Data Entry Form
  872. data validation based on cell value
  873. Stop recording toolbar
  874. Code Takes Forever to Run - Why?
  875. Simple question concerning VBA functions
  876. vba unprotect sheets with different passwords Help Thank you
  877. extract right side of string
  878. Assign value with DOWHILE (variant of TRANSPORT METHOD)
  879. VBA connected vs disconnected from network?
  880. Count Uniques in Col H, Result in Blank Cell, For Each Next Loop
  881. Copying Worksheet to New Workbook
  882. Test for files existing
  883. Looking for a shortcut
  884. Email a statement
  885. display message while code is running
  886. Text Box Value From ActiveCell
  887. Using vbYes or If statement
  888. xlVeryHidden
  889. Syntax To Update ComboBox List From TextBox
  890. Query Problem with Read-Only Workbook
  891. VBA Excel how to assign name in variable range
  892. Formatting via VBA
  893. Shift the Left Boundary of Named Ranges when Inserting Columns
  894. How can I use Shapes in 2007?
  895. Comparing Wookbooks
  896. LOOKUP PROBLEM
  897. Consolidating Ranges on different sheets using VBA
  898. VLookup error - Sub or function not defined
  899. How to sign a Macro
  900. Paste Special error in a Macro
  901. Command button color
  902. Compile error: Variable not defined
  903. rename a worksheet adding a sequential number at the end
  904. Find consecutively and copy
  905. Error when copying worksheets
  906. .pictures documentation
  907. Search and find all "$" in a string
  908. Need help with *lookup*? (or something else) for making a calendar
  909. Worksheet_BeforeDoubleClick Stops Working
  910. Get Active Object or Textbox Name to pass to sub
  911. Deleting original sheets
  912. SpecialCells(xlCellTypeVisible) driving me nuts
  913. Help to copy files names in a column from one directory to another directory VBA
  914. Excel VBA Print Command
  915. Hide Sheet when cell equals
  916. userform dragging problem
  917. Shif cells to the right and down within limits
  918. How to disable tempory an automatic Worksheet_Change Event
  919. Worksheet Change Event Triggering Multiple Times
  920. mean calculation of each column of each group
  921. Scroll bar update
  922. Scroll bar with text box
  923. Bad File name or number
  924. Unable to set the LeftHeader property of the PageSetup class
  925. Sorting data using 2 seperate columns
  926. XL 2007 GetEnabledMso("Undo") is always True
  927. how to insert microsoft equation 3.0 with vba
  928. Has AutoFiltering Been Applied?
  929. creating and saving data from a userform
  930. mark to market
  931. Re : Excel HyperLinks to WorkSheets & Chart-Sheets
  932. Array sorting
  933. Network DDE between two excel
  934. Getting the Kalendar Week within VBA
  935. Filter or Sort??
  936. VBA Source code librarian or versioning system
  937. Re: Ungrouping Excel Charts --> EMF/WMF. 2007 can't edit objects as 2003 (freeform big issue). Steve Rindsberg help!
  938. Slow code to copy a row x # of times
  939. Combobox
  940. Webpage conversion
  941. Certificate breaks when file is saved
  942. Prevent User from saving Changes to a spreadsheet
  943. Exporting Chart sheets as gifs
  944. Auto calc. the bottom 20% with a twist...
  945. External:=True
  946. How do I identify range of filtered sheet?
  947. Stop a user navigating certain sheets
  948. ribbon question
  949. Working with Range
  950. Deleting rows when cell text reads "Research"
  951. can vba look up a value in the f distribution tables?
  952. SQL Syntax
  953. Show Minimum value
  954. Worsheet selection
  955. Select entire rows if between date/time range
  956. Autofilter not working with multiple field selections
  957. Can the Text on a button form be referenced from a cell?
  958. Save ONLY 1 Sheet in a Shared Workbook
  959. drop down list in .htm format
  960. Listbox - works 1/2 time
  961. clipboard - backup and restore
  962. For/Next Text to Columns
  963. Strange formatting on one machine only
  964. Find row and delete following rows
  965. How to get the current module name and Sub in VBA?
  966. Switch to diff workbook with file name LIKE based on value in a ce
  967. Code to find the max value for a cell while looking at other cells
  968. run time error when inserting Excel sheet into word document
  969. I want to learn excel programming
  970. iterate my rows
  971. Can I make Bills of Material that deducte given QTY's fron invant
  972. Active Sheet Error Message
  973. Run Time Error '1004' General ODBC Error
  974. Putting wordpad document into cell office 2003.
  975. updatelinks method?
  976. access selective data...using query
  977. New Sheet based on condition
  978. conditional formatting Do anyone have a work around for this probl
  979. Auto Ranking
  980. Linking xlb file to xls programmatically (or other trick)?
  981. Formula to hyperlink to match
  982. VBA - Select: current cell + next 19 cells (down in column) = rang
  983. Time Range Summary - parse data
  984. pickup the amount from the workbook
  985. Save embedded object?
  986. Conflicting event procedures launching at the same time
  987. Select row in formula in excel 2007
  988. skip actions within a macro if a cell value is zero
  989. Scroll bar (Floating, Changing Sheets)
  990. Protect a shared workbook
  991. Creating Word docs from Excel with VBA
  992. Gain senders email address from an email sent to me
  993. Using Dir function to find folders
  994. Axis title text direction stacked
  995. Freeform Object Failing
  996. Automate the Tools...Reference ?
  997. Excel keeps shutting down using code
  998. Need help creating a count macro
  999. Macros
  1000. Help with a loop please.