PDA

View Full Version : Microsoft Excel Programming


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 [14] 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236

  1. MDX Statement to an SQL Server Analysis Services with ADO
  2. Hide column if it contains text
  3. Show Fridays date on monday
  4. HELP: get a block of data to access by clicking a button in excel
  5. empty buffer for new iteration
  6. Possible? Dynamic copy/paste source AND destination?
  7. Write data CD using Excel Macro
  8. parameter format
  9. Recent File List
  10. Removing pasword-protected macro
  11. Copy rows from other Excel-file
  12. Macro autofills formula when a cell value is changed
  13. Macro Test for Value
  14. Best way to get data from Access 2003 to Excel 2003
  15. using an Outlook template (oft) as the body
  16. Detect String Frequency on dynamic entries
  17. Distribution of production to different production sites
  18. Stop code if cell C8 is selected.
  19. Save a file on a particular location Forcefully.
  20. Deprecated [...]
  21. How to locate a cell with dynamic column value
  22. Line Draw VERY Slow (lots of lines)
  23. Unloading all open and hidden UserForms
  24. How to detect which menu item user click on
  25. get no pages in pdf using excel
  26. can a questionnaire be used to produce a formed letter
  27. excel not working
  28. excel to word header
  29. easy script for deleting blank columns
  30. Defining a Range with Cells(r,c)
  31. If then else problem
  32. Web page Login Process:
  33. Web page Login Process:
  34. when hyperlink pressed can I copy and past the followed cell coten
  35. Call Subroutine in Excel
  36. change the command button backcolor in Excel 2007?
  37. IF?
  38. Workbook_Open
  39. Use variable for a range in WITH block
  40. Wierd Date listbox behaviour
  41. Showing the Differences
  42. Range to find matches to copy values
  43. getting data from web app
  44. Range to find matches to copy values
  45. Countif with Named Range
  46. VBA code to ungroup multiple groupings
  47. Macro to hide colums with value of zero or blank
  48. Excel - Creating Tabbed Delimited Text File - Need help with blankcell output
  49. CurrentArray broken in xl2003? xl2007?
  50. formatting a variable with vba
  51. VBA Macro to retrieve information from xml file
  52. HELP PLEASE: Populate multiple excel rows in access at the same ti
  53. Copy Data from Sheet 1 to Empty Cell in Sheet 2
  54. Reformat dates
  55. Macro to delete sheets
  56. Excel forms - hiding a group of controls
  57. Hide rows using VBA based on cell value
  58. Error 1004 - Cannot change part of a merged cell.
  59. page break automatic macro
  60. Searching across multiple workbooks in Excel 2003
  61. Copy code failing
  62. I want to use the solver in a macro. Can this be done?
  63. HELP PLEASE: getting multiple rows into access database in a new r
  64. HELP PLEASE: getting multiple rows into access database in a new r
  65. Copy sheet and rename
  66. a string to an integer
  67. Posted to wrong list
  68. Help prompt
  69. Text to date
  70. Macro help
  71. Re: Reference Command Button
  72. Re: Reference Cmd Button
  73. Excel Userform??
  74. Array VLOOKUPs take 6 times longer than worksheet range VLOOKUPs
  75. Special sort add-in for excel???
  76. Array takes 6x longer to process VLOOKUP than worksheet table does
  77. Detecting selection before click
  78. Passing a variable from a macro in a separate workbook to the call
  79. Re: Reference Cmd Button
  80. Macro Portability Problem
  81. macro to find a value and return another value on another workbook
  82. autocopy workbook
  83. Query Table Performance
  84. VBA - making an exception for certain cells
  85. a better way to query?
  86. Autofilter of List box Rowsource
  87. Developer Tab - Insert button
  88. Formula to get number of days within a period excluding Fridays
  89. macro to select a range of cells following an offset?
  90. why does cell.replace work with byrows and not with bycolumns
  91. Populate sheet names in a listbox
  92. Shape.TextEffect.HorizontalAlignment throws error
  93. How do I compare two excel worksheets to generate an exception re.
  94. Load Userform from Array using a Loop
  95. two cell accumulator
  96. Search thru sheets to match cell contents then pick up data Phew!
  97. Add-In Menu Handling
  98. Executing English-based macros on other language versions of Excel
  99. Help with backwards compatibility
  100. help with workbook
  101. With with replacing part of a string with another string
  102. Rename file within a directory using creating date
  103. List box: Hide Certain colums
  104. Static Web Query
  105. Speeding up a delete rows Macro
  106. Pivot table automation
  107. Cant seem to get this to work
  108. add-in / dll import function
  109. trying to learn... cannot figure this out, please help!
  110. split cell on 2th and 3th space
  111. Function tooltip helptext
  112. personal macro won't open
  113. Replacing "error msg" in VBa
  114. Form Unload?
  115. Excel 2007 changes graphic size in print preview
  116. Hiding rows based on cell content
  117. CommandText with string variable
  118. User enters data in one cell, want to block entry into another cel
  119. Row Hieght/Coulmn Width
  120. How to use active X Control
  121. Change paste to paste special
  122. Formatting a cell
  123. Excel 2003 AddIn in 2007
  124. Simple custom function
  125. Multipage forms
  126. bmp from scratch
  127. Multipage (wizard)
  128. split cell in number-cell and letter-cell
  129. Lotus noter email alert
  130. adjust zoom according to sheet
  131. Upload Excel Workbook On SharePoint
  132. Upload Excel Workbook On SharePoint
  133. Multipage??
  134. Formatting text
  135. Macro Stops without reason
  136. combobox.ListFillRangeTrouble in VBA
  137. multiple qualifiers for If statements
  138. Help replace string within another string
  139. Sorting rows by time-zone
  140. MsgBox in Userfrom?
  141. email via userfrom?
  142. Pasting formula in every nth row
  143. RE: Certificate gets removed from shared workbook
  144. Kindly Requesting Help with Excel VBA
  145. RE: Certificate gets removed from shared workbook
  146. copyfile method path not found
  147. different formulas based on different inputs
  148. Transpose data macro
  149. Re: Assigning macro to a Command button
  150. Assigning macro to a Command button
  151. Re: Display BOLD and Colored text in outlook body
  152. Email to include a saved signature from outlook.
  153. Display BOLD and Colored text in outlook body
  154. Display File path as hyperlink in outlook
  155. Lookup data in multiple tables
  156. Copy VBA MODULE from ACCESS to EXCEL
  157. Radio Buttons on Sheets
  158. remove text after character
  159. Problem in Vista
  160. Macro to save file
  161. conditional formatting?
  162. Calculating time without using military time
  163. using Excel vba to open Access query in DesignView
  164. Marcro to copy and paste a formula
  165. Display missing numbers from a sequence
  166. add Rounding function to this formula
  167. HELP: email file path as a hyperlink in outlook body
  168. VBA mid() function
  169. Windows Script Host in Excel VBA
  170. Using 32 bit VBA in Excel 2007
  171. Code Difference from 2003 to 2007
  172. Copying data from Sheet1 which is on multiple rows for each customerto Sheet2 on single row.
  173. Cant find VLookup property
  174. Showing Spreadsheet creation date from a template.
  175. Conditional Disable ActiveX button on Userform
  176. Formula incorrecting showing 0 as result
  177. Re: Workbooks.Open fails in scheduled job
  178. Find a variable cell within a worksheet using a macro.
  179. conditional formatting for wrongly entered 9 digit numbers
  180. How to access/open address book
  181. Can i set the subtotal by myself?
  182. Bubblesort
  183. Reference / Binding Addin.xlam
  184. RE: Workbooks.Open fails in scheduled job
  185. Counting Duplicates on two sheets
  186. Need Help with Print Out of Userform
  187. Compile Error?
  188. Column, Row and Sheet tab are gone
  189. correl covar for two dimensional table
  190. code problem not working HELP
  191. Conditional format
  192. Matching with respect to another column?
  193. Browse for folder (but with shortcuts)
  194. Macro on a timer
  195. disable "save" and "save as" when macros are disabled
  196. Alternative to Application.Caller in array functions to avoid wrong results?
  197. New PC and my code doesn't run...
  198. Mileage Calculator by post code / zip code
  199. clear contents of cell
  200. VB.NET Inserted Picture Ends Up in Wrong Cell
  201. Array code ?
  202. Lost view of Application
  203. Sort by header
  204. Web page Log in Page
  205. How to select all unlocked cells on a sheet?
  206. code for vba excel
  207. export value-copy to Mac excel
  208. highlight consecutive series of four numbers vba
  209. Searching for empty cells and changing values
  210. error message on populating combobox
  211. How to create a dialog box to input information to worksheet?
  212. Additional Code for Mr. Pearsons MergeDistinct Code
  213. Re: protect macro
  214. Join two functions to one column
  215. currentregion property not working properly
  216. VLOOKUP not working in VBA
  217. Formula for CF
  218. Copied Pivot Tables with same data source
  219. Re: Option Explicit is ignored
  220. Re: Option Explicit is ignored
  221. Re: Option Explicit is ignored
  222. Speed up macro
  223. Item Count vs Item Cost
  224. how to verify a sheet.visible = true?
  225. Creating Loops and counters
  226. Converting a students grade & credit hours to current GPA
  227. One column determins what formula to use
  228. add ranges
  229. HOW TO PRODUCE LIGHT {Noor(Divine Energy)} IN YOUR HEART.
  230. Finding Smallest Date in Non Contiguous Range
  231. Copied Pivot Tables Take Up Too Much Memory
  232. Macro - text box - conditions
  233. Moving data to another sheet
  234. Error msg
  235. How do I reset all variables without doing it one at a time?
  236. Send mail with data & picture (Graph's)
  237. Loading UserForm Controls (with a twist!)
  238. Force "Enable" Macros on Userform
  239. Macro - dialog boxes - conditions
  240. Excel formula to convert decimals to time
  241. MsgBox Displays Twice
  242. Lock different ranges after inserting data
  243. Page set up for all worksheets
  244. TIP: persisting cell data - ie keep track
  245. send command line to the RUN BOX
  246. Choose box, put cell contents, update
  247. Text within a Cell
  248. Trouble with ActiveX Control - Combo Box
  249. Help with Traping (I believe) a no-Find() error throuh the us of a seemingly unrelated functiom
  250. Iteration Level
  251. How to print numbers invariably using dots as decimal symbol?
  252. How to print numbers with dots, regardless of locale
  253. Conditional enabling of menu items
  254. Numberformat
  255. Web Demo/Trial Application
  256. How to program print preferences
  257. Help with Excel VBA QUOTIENT
  258. Who clear the MS Macro sheet content?
  259. Need help interpreting a code line
  260. Error 1004 when cell set to a value
  261. Sheet Row Heights
  262. Adding spaces between ranges with save as macro
  263. Drill Down to a Data Entry Web Form
  264. Send Email: Once priority is changed
  265. RE: Loop Copy
  266. HELP: saving a file with specific name
  267. works on XP but not on vista
  268. count subfolders
  269. Opening Notepad from Excel
  270. previous.copy
  271. is there a formula/macro/script that recognizes formatting?
  272. Tweaking a Lookup Formula
  273. Macro and Pivot tables using a CUBE as data source
  274. Can VBA hook onto function keys???
  275. Twips syntax to place a report date line on a graph ?
  276. How dark is a color
  277. Spaces in folder name and file name
  278. Changing PivotTable Source programmatically
  279. Follow Hyperlink strange behaviour
  280. Macro for Auto Fill
  281. Suggest a file name OnSave
  282. Excel values to Website, HTML extraction back to Excel. PLEASEHelp!!!
  283. not able to see any sheets!
  284. Need to have a dot used as decimal symbol, regardless of locale
  285. Accessing Excel 2007 from Visual studio 2005 on Windows 7 machine
  286. Suggest file name from worksheet and notify user
  287. RE: ADO MS Access Fields Error
  288. HELP: Application.Visible issue - only hide workbook that has user
  289. full screen
  290. Get calling workbook path?
  291. Re: Horizontally challenged...
  292. R/T error 1004 - But WHY?
  293. Sorting the sheets in a workbook ?
  294. Code based on opening Read Only or not
  295. VBA code to replace Past Special
  296. Range within a Range
  297. Excel > Outlook Calendar code works.... 1 question
  298. Insert Word field code using VBA from Excel
  299. Change toolbar icon in VBA
  300. Matrix manipulation in VBA without printing out the worksheet
  301. Special modeless "Userform" object....
  302. Sorting Data
  303. Take picture out from excel comment
  304. Email a range xls files in a folder to recipients listed in worksheet
  305. Hyperlink from HTML to a specific Excel Worksheet
  306. Best way to create Excel 2007 document
  307. Ribbon Tab
  308. Protection occurring automatically after first cell entry
  309. Macro to sum columns in all sheets in a workbook
  310. populating monthly costs in excel sheets...
  311. String variables
  312. Fixing Excel 2003 VBA that appears broken in Excel 2007
  313. Prompt saveas location in Word from Excel
  314. Re: Call Public constants from other project
  315. Code Problem
  316. Spreadsheet cleanup help
  317. grouping and outliining
  318. How to re-enable events after a VB error in Excel?
  319. RE: LIST WITH FACILITY TO ADD TO THIS
  320. Range PasteSpecial error
  321. Read-only, write-on-demand access to an XLA?
  322. Custom function to find ranked subtotals
  323. Operations on union of ranges
  324. Reformat data from rows to columns
  325. Filter dates in a listbox
  326. Identify which List Box was used
  327. Problem using CONTROLSOURCE... only works when sheet5 is active
  328. Column Match function to replace
  329. Select upto last available Row
  330. Unexpected issue with VBA code received
  331. Extract Name from Text
  332. macro error when formatting columns
  333. 3 option boxes to linked cell-linked cell to be 1,2,3.
  334. Text box not working
  335. Importing from Web
  336. match sheet names
  337. HELP copy non-continous range
  338. Change link-source on file after copy the sheet into new a newworkbook
  339. Macro for Page Setup - Fit to one page
  340. Text boxes which can float outside the Excel application!
  341. Excel, StrConv, and an HTML Form
  342. Arguments problem repost
  343. question regarding unzipping a file
  344. Log in userform
  345. Printing Userform Part2?
  346. Arguments problem
  347. VBA to move WS from 1workbook to another based on critieria
  348. Macro apply on all the file in same directory
  349. How to detect the cell's value change?
  350. Format as Table
  351. Trying to use Vlookup but it wont work
  352. Calling routines from different sheets
  353. Application.FileDialog .Filters.Add method not working as expected
  354. PasteSpecial Values
  355. Macro coding
  356. Save Spreadsheet As 2 or 3 cell values
  357. Not sure what to call this
  358. pause vba code until user pastes values in spreadsheet
  359. Worksheet CLOSE related macros
  360. Show emails in listbox?!!
  361. How to utilize "COUNTIFS" to return a count of unique values
  362. Haw to count ";" in a string
  363. Re: Macro/function that keeps in a cell a given number of characters
  364. Excel sheet names with spaces
  365. Macro for value matching the cell
  366. Auto-populate other cells based on dates
  367. Auto-populate other cells based on dates
  368. Auto-populate other cells based on dates
  369. Sorting a list according to other list
  370. Procedure Call
  371. Auto-populate cells based on dates
  372. replace last character in string
  373. range problem
  374. Set ws = ActiveSheet Compile error Can't find project or Library
  375. Find distance between two postcodes
  376. Comment Box Size = 125% Fill Picture Size
  377. single colour system for textboxes
  378. IS it possible to add Hyperlink to a commandbutton on a Userform
  379. Olap SSAS Cube SQL Server2005/2008 single data point by UDF to exc
  380. ShowWindow problem
  381. RE: template
  382. RE: How to return an array to a macro sheet
  383. Can I stop the change event being triggered?
  384. Changing references in a batch of files?
  385. Re: row insertion before/after
  386. inputbox date format
  387. Function Last Row()
  388. Username generator function
  389. Macro Debug on Pivot Table
  390. CheckBox to tick other CheckBoxes
  391. RE: button labelling
  392. Copy the value in the Inputbox
  393. Programming "Shape" objects
  394. Color pallet
  395. Switching between two charts based on check / control box
  396. send output from inputbox to user selected workshett
  397. Filter data based on Cell Value - ">" Syntax required
  398. SetFocus Issue
  399. Active X Message on UserForm
  400. variable declaration for more than one worsheet
  401. Userform and Text Box Date
  402. IS there a fix for DLL not referencing from VBA.. IF not get one p
  403. Referencing dll from VBA ,... JPG photo metadata edit.. Picasa
  404. Calling Subroutines from sub-routine
  405. "Object not set"?
  406. erasing empty spaces
  407. Conditional Formatting in 2007
  408. Is it possible to hide a workbook while pulling data from it
  409. open file with macros disable
  410. Programm Auto filter for overdue time
  411. Help: Error when opening a password protected workbook
  412. Possible scoping problem
  413. Name Conflict using Ron De Bruin's RDB_Merge_Data_Browse
  414. HELP PLEASE: Populate certain userform fields from access database
  415. open file macros inactive
  416. Save failing
  417. Referencing
  418. Organize the worksheets in numerical order
  419. Copying a macro to use in another workbook
  420. Conditional formating Run-time error '5'
  421. save file using information from a cell
  422. Page Setup on all sheets very slow
  423. Excel IP lookup
  424. problem building Function with worksheet name and range
  425. Copying one work sheet to another
  426. sorting one column, move some duplicates to bottom of sort
  427. General approach/platform question
  428. Query SELECT
  429. Refresh an Access Query using VBA code in Excel
  430. CODE in Access running excel will NOT set PrintTitleRows correctly
  431. Sum based on value between two cells
  432. Emailing multi messages from one excel file
  433. Macro - Find Function not working
  434. Command works from debug but not normally
  435. Finding comments
  436. Find the first non 0 cell in a column
  437. Emailing multi messages from one excel file
  438. Run time error 1004 file not found
  439. How To Determine Length Of Variable-Font Text?
  440. Copy and Save in specific way
  441. compile error
  442. Windows7 Default path problem
  443. trigger outlook macro from excell.
  444. How to access table in text box?
  445. Find & copy values below dates
  446. Lookup second duplicate value location.
  447. Floating, unprintable objects in Excel???
  448. VBA macros files mixed up
  449. Validata a variable
  450. ACCESS/EXCEL Cell Update Help
  451. ACCESS/EXCEL CELL ADDRESS AUTOUPDATE
  452. open file validation
  453. Calculating Textboxes
  454. Popup Calendar?
  455. Re: Make a Sub/Function global to ALL WorkBooks?
  456. Assign a cell value (from another file) to a varieble
  457. getting back a cell adress into a range variable
  458. Parsing a text field to retrieve numeric values
  459. How do I stop a message from appearing when deleting using VB?
  460. Font Color in Pull Down Menu
  461. Userform without title or border...
  462. Re: Macro that splits content from cell if given character is found
  463. Dynamic Input Timer
  464. Using Solver Thru VBA
  465. How Do I
  466. How to only show modules in VBE project explorer?
  467. Mail Merge source Access Database using Excel VBA... Pls Anyone
  468. Can "print area" cover entire page???
  469. How to enable "Links" when copy a worksheet (with buttons on it) to anew book
  470. Function for Date setting in specific format
  471. looping required
  472. Parsing a text string in Col. A to extract 2 values and return theirproduct in Col. B
  473. Formatte issue
  474. Need someone to look at this code line for me
  475. How to modigy the reference in a named range?
  476. Help with selecting all cells in a sheet -- Error 1004
  477. Macro that delets empty cells between cells with text
  478. download & extract information
  479. Mail Merge source Access Database using Excel VBA
  480. finding duplicates and deleting based on another column
  481. countblank sintax
  482. Append worksheet to another inside a directory
  483. MSCOMM Control in Excel 2003 / 2007
  484. Macro to delete "unpinned" recent files
  485. Macro of exact cell value
  486. comment copy
  487. Printing a long spreadsheet on 1 page only??
  488. Excel Macro Question
  489. How to set PrintSetup?
  490. Check cell value exactly
  491. another Vlookup question
  492. Run-time error '1004'???
  493. My VBA Help is in Japanese!
  494. chart series: displaying the source range
  495. hyperlink copy paste
  496. Trying to Learn Code to Copy Charts
  497. Text Box Dates in Userform?
  498. ActiveChart location
  499. MsgBox to display [hh]:mm
  500. 2 problems with copying cells to sheets in same workbook
  501. Excel.Application is not defined error in asp.net application
  502. Server Connection Error
  503. Web Query Update
  504. HELP: Populate form fields (intranet) from a workbook(network driv
  505. vb code to clearcontents of a merged cell
  506. Static Vlookup
  507. autofill down until reach variable range
  508. Simple Concatenation
  509. AutoFilter Slow problem
  510. Learning VBA for Excel
  511. Drop down list using macros in a personal macros workbook
  512. will countif work for this?
  513. macro on share files
  514. GoTo problem.
  515. Evaluate Dates then fill in slots for scheduling
  516. ModifyCellText
  517. Excel 2003 - Button moves along with the cell selection
  518. Re: VBA Big Brother Style Procedure
  519. get_End question
  520. extracting chars from strings (Visual Basic)
  521. Automatic replace of VBA code for multiple files
  522. set cursor position after cell is populated??
  523. Save Embedded Files
  524. Automatic replace of VBE code for multiple files
  525. Locking cells
  526. Problem while copying JTable contents into Excel with line breaksincluded
  527. Date on UserForm?
  528. "For each w in workbooks "can't find ".dat" open excel sheets,
  529. Re: How to enable "Trust access to the VBA project object model" during VSTO add-in setup?
  530. Windows api code pack DLL
  531. Ribbon and toolbar, program control
  532. assign variable to a range
  533. Separate Macro from Workbook
  534. How to get Col and Row returned in an hLookup?
  535. Combo box multi-select
  536. Select Case syntax for multiple conditions ("and")?
  537. Linking Formats (color) Between Cells in Diff Wsheets
  538. How can I fill a cell with "+" based on a percent value?
  539. Shell command ignores variable
  540. Re: VBA Big Brother Style Procedure
  541. RE: VBA Big Brother Style Procedure
  542. Displaying data in a VBA User Form
  543. Finding cells using a style
  544. Drop downs and look up
  545. Filter Access query results based on selected information
  546. Macro not to check compatibility when saving this workbook
  547. Frame captions aren't printing when the userform is printed
  548. Web Service in Excel 2000
  549. Copy (“A2:A26”) paste, offset one cell, do it again. Loop 256 tim
  550. Refresh Queries in Order
  551. Help to hyperlink cells
  552. Listbox to change value in cell
  553. Re: How to enable "Trust access to the VBA project object model" duringVSTO add-in setup?
  554. Print from multiple closed files in a folder
  555. Taking lines from multiple files into one sheet
  556. Dates
  557. Re: How to enable "Trust access to the VBA project object model" during VSTO add-in setup?
  558. Trying to Hide Rows with :30
  559. User defined functions that are array functions
  560. Code to see if mapped drive exists
  561. Macro not to check compatibility when saving this workbook
  562. matching cells
  563. Difficulty analysing Journey Planner result
  564. Forcing Macros to Run
  565. Running Excel spreadsheet with macro code using Excel services
  566. Find products in cells against a table of products
  567. Palindromes and repeats
  568. How to break into a running code
  569. Macro "not to check compatibility when saving this workbook"
  570. Re: How to enable "Trust access to the VBA project object model" duringVSTO add-in setup?
  571. Re: How to enable "Trust access to the VBA project object model" during VSTO add-in setup?
  572. RE: How to enable "Trust access to the VBA project object model" durin
  573. excel 2007 add-ins -Help
  574. Emailing rows to each different address listed.
  575. Make the same titles repeated in multiple sheets of a workbook
  576. Make the changes to the Parent applicable to all copied files
  577. Copying just the summarized data
  578. Macro independant of workbook
  579. Macro Help
  580. VBA - Importing Sheets
  581. Frequency distribution and descriptive statististics
  582. Macro with a memory
  583. VBA time calculation
  584. Excle 2003 working with mainframe
  585. sumproduct problem
  586. Suggestion for the Excel Development Team
  587. Macro Help
  588. Creative graphics
  589. Cells not refreshing...
  590. Chart DataLabel Placement Error
  591. Code For Copy Copies Twice
  592. move from column f and g to column b, if filled
  593. Find and Replace Within a Range Versus Workbook - Suggestion
  594. Selectively Moving Data to a Summary Sheet
  595. returning comments propery of a closed file
  596. Code Snippet - Forms from Control Box toolbar
  597. Combine 2 columns using VBA
  598. How to create a logic statement that changes the formatting of a c
  599. Excel 2003 Macros and Variables
  600. Hiding an item in the taskbar
  601. Compare 2 sheets
  602. VBA function to check if a string has valid spelling
  603. Accurately reading the contents of another spreadsheet
  604. Setting Bar Width in a Bar Chart
  605. MVP ngs
  606. Title of PowerPoint linked to a 'name' in an Excel file
  607. Name range down one cell
  608. screen capture
  609. How to deteremine the number of trendline in chart?
  610. Change Regional Language setting with Code?
  611. How do I copy Chart shee to other workbook without external refere
  612. Make VBA Enter Formula into cell rather than calculation
  613. RE: Returning the average of two ranges with a macro
  614. Selecting Latest Invoice from a Group of Invoices
  615. Help with selection(?)
  616. Taking the 51st Line and Multiplying by 2
  617. Help Required
  618. Userform, Calender, Problems with Todays Date
  619. Split a text using VBA
  620. Used to work now it doesnt
  621. Insert macro in a toolbar menu
  622. RE: insert a row in a work book A if a row is inserted in Workbook B
  623. Userform question
  624. Test for text boxes
  625. Splash screen properties
  626. Restrict AddIn to limited users
  627. Copy work sheet to another work book, pros and cons
  628. What is the best way to distribute the logo's for an Excel house style?
  629. Representing numbers with K, M, G sufix using a macro
  630. Loop through VBA Compenents in Excel via VB.Net
  631. Macro to copy sheets to another workbook fails after about 45 copi
  632. How can I delete all named ranges in a workbook or worksheet?
  633. Can't pass VBComponent to Sub Procedure in VB.Net
  634. Macro for fast deletion of rows that conatin certain data.
  635. Form works once only
  636. RE: Creating a stand alone program
  637. Concantenate All cells in Row left of current active cell--
  638. Code only works in Debug mode. Why?
  639. Date Stamp in Last Column in active row if any data changes in row
  640. Name Range, Variable # of Rows, Compare data, then Keep or delete
  641. trouble with countif
  642. Application EnableEvents
  643. Format even cells to the right.
  644. select different workbook in vba?
  645. Why Am I getting 2 different outcomes
  646. Recurring Day
  647. Hyperlink from webpage to specific Worksheet
  648. Close file
  649. Excel 2007: Copy from recordset not working properly
  650. Copy Code and a sort problem
  651. Excel Macro Compatibility
  652. Counting Work Days
  653. Copy Worksheets to New Book
  654. Universal Code?
  655. Sums from a cell on multiple worksheets
  656. run multiple macros from a drop down menu
  657. Advanced Excel--Want to click on Cell & Move to Other Tab
  658. =AVERAGE(b7:b20) is counting fiels that are zero
  659. Unwanted characters in a TextBox
  660. VBA Coding Using VLookup
  661. Exit two loops at once
  662. How can I let a user insert a company logo without distributing the logo file?
  663. How to send emails to recipients in EXCEL list & content in WORD
  664. Check box counting
  665. Help to DEBUG this line of code. Type mismatch error
  666. HELP: display status bar on excel userforms
  667. Macro to delete Recent Files list (except those "pinned") - Excel
  668. macro to select option button in option group
  669. Method ‘CurrentPage’ of object ‘Pivot ‘Failed “
  670. HELP: insert data in new row
  671. Applying a function to a range
  672. Range of cells from variable number of work sheets.
  673. MsgBox Format(3.767, "[hh]:mm")
  674. saving cell value for use later
  675. XML Spreadsheet and Calculation Mode
  676. .GetOpenFilename - Filter on File Name
  677. Enable groups on a protected sheet
  678. Numerical Analysis
  679. write values to WorksheetFunction.Linest
  680. VBA v1040 - miss of CopyPicture
  681. Range in Macro to change after rows inserted
  682. SAVE AS
  683. Create cell reference color coded border with square corners
  684. Can I call an Excel VBA function from within a WebBrowser control?
  685. Create Function based on cell value
  686. Coding Histogram add in tool
  687. Access Macro in a Module
  688. How to copyConditional Formats
  689. Pivot Tables - using .AutoShow
  690. Excel 2007 macro recorder weirdness
  691. Create List for ComboBoxes
  692. Visibility of newsgroup postings
  693. Run-time error 9 - Subscript out of range (again)
  694. Disabling help functions with macro
  695. Macro to Query SharePoint Site for Existing Pages Content Type
  696. Tweaking Existing Macro That Edits Long Formula with WORKDAY?
  697. VBA Code for bacground colors
  698. "ColumnOverflow" Function?
  699. Earnings based on gross commission with split levels
  700. Quickest way to find a row number a value
  701. Excel Interop: DateTime
  702. variant criteria name to filter
  703. Grouping & Outlining
  704. Type Mismatch with 2 Variables
  705. Finding a date
  706. Help with counting the number of destinct items in a column
  707. Using Excel mail-merge without Word
  708. Create a PivotTable from a VBA array - help!
  709. User-defined Type Issue
  710. Calling open workbook from another workbook
  711. Continuous page numbering when printing whole book
  712. Chart selection changed event
  713. disable from deleting rows; folders not to delete; sheets to inser
  714. Excel 2007 is slow when you hide columns on .xls
  715. Single clck ---> double click
  716. convert range of years to series
  717. Throw Exception if Clipboard is Empty
  718. run macro from anoter Excel session
  719. VBA Help
  720. Re: Code to copy data
  721. Condition BLUE
  722. Unique Value Formula
  723. Search faster using array - But it slows down
  724. unknown column length
  725. [Click the star to watch this topic] BUY CHEAP TEXTBOOKS | CollegeTextbooks | Used Textbooks | Online books
  726. Formula Problem
  727. Validate userform textbox entry with Sheet range.
  728. Warning of duplicates
  729. delete cell if part of cell contains
  730. subtotals
  731. SendKeys not sending to Cmd.exe
  732. How to retain Userform Radio Button Memory after unload
  733. run macro from onoter Excel session
  734. make workbook visible
  735. Drag and drop from a Windows Form To Excel Worksheet
  736. Find First Emoty Celin Column
  737. lock formulas in certain cells
  738. 3 most significant digits
  739. Simple question?? Nested ifs on one line
  740. How you can save fuel and the environment
  741. lock cells with values
  742. Macro for active cell
  743. Re: Why the error message?
  744. Bubble Chart
  745. LOOKUP iterations in VBA 2007
  746. Modify Vlookup
  747. Eport Excel data to closed Excel Workbook
  748. Toggle Button
  749. Print with sevral different print area's
  750. to speed up excel