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. Export user inputs to a template and save it as a different file
  2. Filter and copy data to other sheet
  3. Is this a bug in excel 2007 charting
  4. How can I get an email address from the GAL
  5. Where to place UDF modules for general use
  6. copy named range & paste
  7. Custom Worksheet Functions and Intellisense.
  8. Web
  9. Disable row delete in a worksheet (not all worksheets in theworkbook)
  10. Transfer variable between macros
  11. Auto-fill across multiple tabs
  12. Setting Cell BackColors From VBA
  13. Formula Bar Hidden
  14. Question on Deleting Querytables
  15. Multiple Command Buttons
  16. Mid Function with XlInsertObject Hlp!
  17. Deletes Current Names and then adds New Names
  18. Macro Trigger
  19. Macros
  20. filter file extension on remote pc for file open
  21. Looping through records
  22. AUTOMATING E-MAILS
  23. VB Data Validation check - apologies for incorrect post
  24. Copyfile
  25. Accessing Hyperlinks thru code
  26. Intimate the # of records being imported
  27. Row number and Column number
  28. macro adding rows
  29. Chart zoom
  30. Filtering information
  31. Chart SeriesCollection Names
  32. RE: To join 1st line & 2nd line of text in text in Excel VBA Code
  33. how to create a zoom butom in vba excel
  34. how to create a zoom butom in vba excel
  35. on error resume next dilemna
  36. Cut and remove last text
  37. combining text and variable in a .value
  38. How to find new UDF to edit
  39. if a checkbox is checked then...
  40. Excel just dies - XL97
  41. Immed Win: how to home down and clear?
  42. help with case
  43. Testing to find if UserForm is Loaded
  44. Reference Controls to chang attributes through Array
  45. Protect
  46. paste transpose
  47. save a range to copy for later
  48. referencing a variable from a form in a module
  49. referencing a variable from a form in a module
  50. Retrieving Archived (EAS) Outlook Attachment
  51. compound if statement
  52. auto-protect a sheet upon workbook close
  53. ADODB: duplicates -problem
  54. Difference office versions
  55. MS Excel Delete row if criteria is meet
  56. Activate each sheet in workbook with exception of...
  57. NO pivot table
  58. calling an _Exit event
  59. Creating UDF prompts (XL 2007)
  60. Excel using Word --- Object is not responding
  61. VBA Syntax for Countif condition where only 1st char in Range of each cell = "M"
  62. VBE opens automatically -- why??
  63. To hide UserForm command buttons
  64. HELP: Trying to populate form fields posted on intranet from a dat
  65. Copy Sheet to New File Without Code
  66. new template & save on first open
  67. Trying to save directly to .Doc and using save as MHTML
  68. scroll bar inside an embedded chart in Excel 2007
  69. how to preset to a network drive?
  70. Excel and Word 2007 Macro Issue
  71. Personal.xls Will Not Hide
  72. VB.NET with Excel VBA
  73. Help with Type mismatch error
  74. Restrict User to a directory
  75. Help - I'm getting desperate
  76. Importing Text
  77. Hlp - Display only file name when Insert Object As Icon
  78. What's It Doing?
  79. To create a macro to fetch data from excel sheet (2003) using a qu
  80. Referring to Excel objects in VSTO
  81. Copy each data record of a name list and place it under the onecopied
  82. Merge multiple workbooks into one.
  83. ListBox RowSource Property
  84. generic use of sheet name in user-defined function
  85. please help me, asp!!
  86. IF DATE Statement help please
  87. Selecting a column , row or cell
  88. Re: instance of class from dll, is it possible??
  89. WorkBook Deactivate Event
  90. Private Sub Question
  91. Find Autofilter Header range
  92. How to refresh an Excel workbook from VBA
  93. split 1.5/2.1 into 1.5 and 2.1
  94. Sub to carve out uniques based on col header whose position may va
  95. Range Selection - From Lowest 2 Highest Values?
  96. Softcode Path from File Open dialog
  97. graph image -how to superimpose or extra data-point by VBA
  98. Match
  99. importing tabs/sheets only from the currently open files
  100. how to superimpose chart images or extract data by vba
  101. Opening a excel file from a macro
  102. excel socket programming
  103. Re: Scrolling down a web page using VBA
  104. getting the source code of a web page
  105. please answer me, i need your helps!!!
  106. command button help
  107. Button looses Macro setting when running Macro
  108. Re: Macro copy data based on cell formatting and paste special values
  109. retrieve data from an .aspx web page
  110. numeric picture formats
  111. User select folder name
  112. Delete ALL ListObjects
  113. Using SaveAs Dialog and Changing Location
  114. Find sub not finding
  115. Menu-bar missing when launching Excel
  116. Scrolling down a web page using VBA
  117. If String starts with a * (asterik)
  118. message box
  119. vba + excel + html
  120. vbscript/excel issue
  121. Excel 2010 add in support
  122. pulling values from column g into a variable, and returning variableon spreadsheet
  123. copy pieces of different word doc s
  124. Recordset with Primary Key
  125. Creating a button in Macro
  126. vlookup woes
  127. Erro 429 Set gApp = CreateObject("AcroExch.App")
  128. Auto-Protect Sheet on Open and on Close
  129. How-To Remove Extra Spaces
  130. Re: Undefined function 'replace' in expression
  131. Formula based on another cell value
  132. Re: how can detect that setting object failed
  133. Selet Syntax
  134. Re: VBA just dies - EXCEL 97
  135. Re: how can detect that setting object failed
  136. Copy from ActiveRow, Paste to A2 in Another Sheet
  137. could anyone answer the question on how to produce a 1-d table, PL
  138. It Then Else Question
  139. VBA help
  140. Complete .PDF form in VBA
  141. How do I identify the current locale?
  142. Date comparison between 2 datetime fields
  143. how to produce this 1-d table?
  144. Auto Update Second File
  145. opening a workbook as read only
  146. Save As
  147. Count number of different entries in a column
  148. Treeview - XML editor in VBA
  149. footer text overlaps sheet text
  150. RE: Cannot call the worksheet function Weeknum
  151. RE: Cannot call the worksheet function Weeknum
  152. SQL to unprotect and protect worksheet
  153. Run Access Command
  154. Problem finding cell contents
  155. BeforeDoubleClick on Protected Sheet
  156. Testing dynamic range for values
  157. Change paragraph format in Word from Excel...
  158. Codename not set
  159. Password for a macro?
  160. very urgent!!!
  161. Filling a Cell with Yellow backgound after testing for -ve cell d
  162. Looking for Excel ODBC 64 bit driver
  163. Select range problem
  164. Rows columns to repeat while printing in a workbook
  165. auto refresh excel
  166. Re: vb script in dts throws error when operating on Excel file - helpplease!
  167. urgent +++ imp
  168. Transfer all data from one cell to another, and keep it dynamic
  169. Excel 2007 not in foreground when launched in Vista or Windows 7
  170. move data w/o blank data to another sheet
  171. Comparing Rows
  172. Running macro based on cell value
  173. highlight rows based on value of column F
  174. Making this sheet compatible for excel 2003 users (conditionl frmt
  175. Autofill Macro
  176. Problem with UDF
  177. VBA time date stamp
  178. Concatenate All Possible Combinations
  179. Opening a document in Word from Excel
  180. Suppressing Excel2007 Messages
  181. Concatenate contiguous fields on one worksheet into 1 field on ano
  182. Rename sheet with content in specific cell
  183. RE: Undefined function 'replace' in expression
  184. VBIDE helpfile
  185. Re: change text in string
  186. getObject and password protected workbook
  187. Re: Userform: Unable to setfocus from multipage
  188. Userform: Unable to setfocus from multipage
  189. Find and replace in Word from Excel
  190. change text in string
  191. Modify macro to find cells beginning with A - help needed
  192. Auto Sort
  193. Code causes a problem
  194. m=1
  195. HELP: Populate corresponding userform text fields from access data
  196. Sort Macro Compatibility
  197. Finding content of cell in visible "protected" sheets
  198. Last used cell problem
  199. XL: ping mapquest or googlemaps to get driving time + distance?
  200. Application-defined or object-defined error
  201. Copying a value from one workbook to another
  202. Macro reads cells with numbers . If given number is found , delets
  203. Thumbnails
  204. Can't replace commas with period
  205. pdf Reader
  206. Answering Pop questions when macro is running
  207. Determine which cell was populated
  208. Enable Command Bar
  209. Need macro that analyses 2 columns . Delets row if same text is fo
  210. pivot table filter macro error
  211. Create a loop
  212. More control over moving and inserting OLE Objects via code
  213. Prevent closing if values do not match
  214. If sheet exists and it is named run this code
  215. Grocery list
  216. Display Calculated amount in a textbox on userform
  217. Closing running sub from a different one
  218. Sub to stack data n paste unique order ID lines
  219. activate optionbutton in a userform based o a condition formatting
  220. Macro analyses cells in 2 columns . If same text found , keeps row
  221. Microsoft.Office.Interop.Excel myexcel = new EXCEL.Application()
  222. Dynamic range issue
  223. Excel automation problem
  224. Macro Help
  225. Turning off Selection/sizing handles?
  226. Windows Explorer
  227. unlock vba password using another vba code
  228. Listbox Column Display
  229. Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ?
  230. Random Number between a Range of Numbers
  231. read xml method-- faster one
  232. I want to change the chart series line settings in a macro
  233. End of rows in a column
  234. socket programming in excel vba as client
  235. Code to Insert File as Icon & Open Browse Dialog Box
  236. Multipage Buttons?
  237. Close an active ODBC connection
  238. Macro Help
  239. Selecting Range of Copied Text
  240. Button controlled "self populating PopUP" menu
  241. An old chestnut: finding the last cell in a range
  242. changing image when mousepointer moves over certain cells
  243. Push data from Excel to SQL Server
  244. Connect Files
  245. Underlying events in a worksheet?
  246. Event when cursor changes cells, but no select(?)
  247. How to assign a reference to [Validation .add] xlValidateList(?)
  248. Help with VBA Capitalization
  249. Testing for different versions of Office
  250. Turn protection Off... <run code>... turn protection back on
  251. Copy every worksheet
  252. Copy Text Box Contents into Rows
  253. change cells when a particular user makes her input
  254. MsgBox. problem to continue the macro
  255. Search
  256. looping programme require
  257. copy non adjacent cells
  258. Multiple or nested AdvancedFilters?
  259. Re: Call macro from active workbook
  260. Re: Call macro from active workbook
  261. Re: Call macro from active workbook
  262. Went from Office 2003 to 2007. Error 438 VB v.6.5.
  263. Excel 2010
  264. App-V - Excel- Programmaticaly accessing the virtualized Excel DLL
  265. How to open a linked graphic?
  266. Values in a array are disappearing
  267. type mismatch when opening a userform
  268. Multipage Buttons??
  269. Open UserForm
  270. Cannot find a loaded VBA addin
  271. Code corruption problem
  272. Using SUMPRODUCT Function on Calculated (Function-Derived) Data
  273. Insert Row and calculate difference between two dates
  274. import a .dwg or .pdf
  275. A .XLSM file suddenly quadrupled in size
  276. Excel and JD Edwards
  277. Search for sepcific words and delete rows between them
  278. Sort column without referencing sheet name
  279. Adding Page Numbers
  280. Date Time Picker
  281. How to read previous copy selection address
  282. Button to saveas then new sheet asks Questions
  283. MS Query - changing data using inputbox?
  284. 2007 AutoFit, WrapText, fails
  285. Format Textbox w/ $ sign
  286. copy and past based on criteria
  287. How to prevent and event?
  288. code for impoting userform and module
  289. Getting data from a closed wbook
  290. Is it possible to build sort statement?
  291. Fill empty cell macro not working
  292. Fill Blank Cell Not working
  293. Excel Macro
  294. Web Services Tool Kit Usage - Handling the data returned from WS c
  295. Yes/No message box appears based on cell's value and its selectionproduces a value
  296. ActiveWorksheet.Sections(1) does not work
  297. Text in the first page footer
  298. SaveAs?
  299. Open Userform two ways
  300. HLOOKUP
  301. Excel VBA Project Excel Lost !
  302. finding where text wraps in a textbox
  303. How to hide "Image1" when you hide Row
  304. Text not looping through ranges
  305. BeforeSave Problems
  306. More then 1 worksheet_change event
  307. Variables
  308. 2007 - is it possible to set a hyperlink in a msgbox??
  309. Sorting of table depending on a drop-down-list entry
  310. Combine Advanced Filter with a loop?
  311. Icon Type and Name when Insert File As Icon
  312. SpecialCells(xlCellTypeBlanks) = error 1004 No cells found
  313. UDF for extracting only numeric values.
  314. How to define variable a("H") = "Follow-up"...
  315. Referencing a cells value
  316. can't save my file with macro
  317. Replace a format of a part of a cell
  318. Userform List Box content not visible?
  319. Trouble with Validation formula1:=Join(... Is '!' a reserved cha
  320. Triggering procedures
  321. OnTimer - The macro 'macro name' cannot be found.
  322. Excel Spellnumber Formula
  323. debug not working
  324. Concatenate without duplicates
  325. Find and copy
  326. XML-Gallery- Ron DeBruin
  327. Opening a Word document from Excel
  328. Dynamic Arrays
  329. About the autocalculate in the status bar...
  330. AutoFilter Macro Protected Sheet
  331. Copy sheet from closed workbook
  332. Database interface.
  333. Active or current file path
  334. Simple SetFocus on userform issue
  335. Button in a toolbar to insert a specific function
  336. programming delima
  337. Sort by a Variable Range
  338. Need to open a file and a hidden file and hidden toolbar
  339. Workbooks.add count:=X?
  340. RE: Workbooks.add count:=X?
  341. boolean variable?
  342. Closing down running macros at the file close
  343. Setting "save as" and "save"
  344. turning number into text
  345. The Macro Button is disable
  346. Macro Help
  347. Create a Drop down List on a Form
  348. Delete Hidden Sheets
  349. Macro Question
  350. Macro analyses Cell . If text found , delets entire row
  351. Grossery Budget spred sheet.
  352. a Disaster in the Making - R/T error 1004
  353. Greater than, less than, cut and paste rows to sheet3
  354. column to row macro
  355. Unexplained WorkbookBeforeSave SaveAs Error Causes Excel to Crash
  356. Copy number to pivot table
  357. Run Time Error 91 -
  358. Opening time
  359. macro to extraxt information
  360. Mid function
  361. Delete rows but keep formatting to 1000
  362. AutoFilter & Selecting First Visible Cell
  363. Selecting names based on Teams (using dropdown)
  364. Data Val MultiSelect on Userform?
  365. Excel Userform Org Chart?
  366. Function needed to pull in cell values
  367. Building A string
  368. Please Help: Upload a File and save it at a specific location
  369. Userform Control Change from Different Workbook
  370. Assigning a date that is before expiration date
  371. Add-In Adding to Help File?
  372. MS Excel VBA Worksheets group tables in one table.
  373. Filenet Panagon Question
  374. merge word documents from excel macro
  375. Conflicting VBA Coding
  376. Worksheet_BeforeDoubleClick event question
  377. Command Button - Send and Save
  378. Which day
  379. Opening the "find all" feature on workbook launch
  380. LISTBOX
  381. Questions on Combo Box
  382. delete entire row with condition
  383. RE: c.Resize
  384. Re: c.Resize
  385. Re: c.Resize
  386. Selecting Range between two named ranges
  387. Cell updates not occuring
  388. How can I use VB to hide Row 57 if cell A53 has a value of 1?
  389. copying one entire row from a source sheet to a destination sheet
  390. macro in excel 2007
  391. Create a list of Sheet names
  392. Pivot Tables Overtaking Non-Pivot Rows
  393. Getting Pivot Tables to Displace Columns Populated Only with 0's
  394. Importing a Text File Into 1 Column
  395. Selecting sheet 2
  396. Named ranges
  397. Macro to copy a sheet and delete a macro button
  398. Macro Timing off in IE7
  399. Can't trigger Keydown event
  400. Display only file name in embedded icon
  401. using filter based on last column
  402. INPUT BOX in excel 2003
  403. Page Number
  404. macro to copy rows that contain a cell with a certain number
  405. Problem with connection to sql server from excel
  406. Excel listbox
  407. Concatinating two spreadsheets by a column
  408. Unable to get the VLookup property of the WorksheetFunction class
  409. Retrieving short system date format in VBA
  410. Clear Files Displayed As Icons
  411. Auto shutdown for inactivity in Excel
  412. Protection of cell in excel
  413. Excel 2003 list of names and calling
  414. working with MsAccess in multiuser environment: error Cannot start
  415. Determine tje last visible row on the screen.
  416. Selecting rows
  417. On Line guide like windows creation in excel
  418. Project - VBA Project window - Excel 2003
  419. Macro to Loop through and sort worksheets
  420. Macro that analyses data from 3 columns and puts result in 4th
  421. Complicated sum
  422. Macro to determine chart name
  423. Parsing Address, City ST ZIP
  424. Macro Help
  425. Always the same average for random numbers!?
  426. Hide control until report section populates
  427. Formula to Sort Numbers
  428. Reducing a List by Eliminating Entries in it Found in Another List
  429. Sorting Formula Question
  430. Link Text Boxes (As can do in Word)
  431. data as a combo box or list box
  432. quick access tool bar show/hide custom button on open/close workbo
  433. What does allcalc (a table_array) refer to in a cell formula?
  434. Paste problem from HTA
  435. Macro for calling the previous worksheet
  436. call C++ DLL from VBA
  437. How do I obtain a digital signature certificate for my projects?
  438. Automatically load solver reference library
  439. Re: Open Files with Macro or switch windows with macro
  440. move entire column
  441. Add Trim Function to Code
  442. Lookup
  443. posting
  444. RE: Application.Evaluate("5705")
  445. Re: Application.Evaluate("5705")
  446. Re: Macro to replace a range of cell values
  447. How do you embed Access Report in Excel?
  448. VBA Function returns #VALUE! when working on another book
  449. Microsoft Date and Time Picker control for User Form
  450. How to detect protected sheet
  451. Problem copying name range
  452. Data Val MultiSelect ?
  453. Problem with VBA Functions that use a DefinedRange as parameter
  454. Find and replace
  455. Macro - reads cells in a column .If keyword found moves cell conte
  456. MACRO HELP
  457. Col number not letter
  458. Changing font for msgbox
  459. RE: Get sheet name in formula
  460. Finding the top 10 from a month of data
  461. Macro that delets all cells containg ALL words in bold
  462. How to open CSV as text?
  463. Loop clean up
  464. Subtotal function
  465. ADO and User function
  466. Macro to determine min/max values of column
  467. Macro that splits content from cell if given character is found
  468. UDF in PERSONAL.XLSB
  469. Macro searches for keyword. If found , puts 0 in cell from next co
  470. sorting data
  471. What you see is what I want
  472. dropdown list select event.
  473. Repost - Best way to get data from Access 2003 to Excel 2003
  474. macro to do subtotal by eachqtr in calendar year
  475. Looping Through an Array and Transposing
  476. Check for dual key Duplicates
  477. Determine which row is active below freeze pane
  478. Address of Formula
  479. macro which delets cell if the cell above has the same keyword
  480. ROUND AND SUM
  481. Automatically input file names from a directory to Excel sheet?
  482. PDF export add-in
  483. Userform within a userform ...
  484. Square before beginning of a new line
  485. Wilcard for Workbooks???
  486. Online Help on VBIDE
  487. how can i take of the buttons of the pivot table or the informacio
  488. SOURCE "VALIDATION"
  489. Assign buttons on QAT
  490. FORMULAR INSERTION
  491. Concise Way To Select All Rows Except First?
  492. Problem with Union
  493. Quick ? - Worksheet_BeforeDoubleClick
  494. Can i remove the informnation of a hyperlink???
  495. XY coordinates to cell address? is it possible
  496. Macro which searches for a character . When found delets what's be
  497. Multiple chart creation using multiple series in the same row
  498. Macro - searches for key word in a column and concatenates entire
  499. Attempting a dynamically defined conditional in VBA
  500. Unable to format a control in a Userform
  501. Validate User Input in Dialog box
  502. Control of Sheet Tab functions?
  503. method to split data rows to multiple worksheets.
  504. Update Pivot tables in a shared workbook
  505. Resizing a form at run-time?
  506. Restricted Functions
  507. Determine path to picture displayed in image control
  508. Publish as PDF/XPS Strange
  509. Reference Personal.xlsb in other projects...
  510. delete certain rows only
  511. Error Handler displaying message when no error
  512. Simple Do Loop!
  513. Multiple chart selection in Excel 2007
  514. Read data from workbook without showing it?
  515. Macro that compares columns and identifies changes
  516. IF Statement based on first two characters of cell
  517. macro doesn't recognize korean letters
  518. Find Minimum and Return a Figure
  519. Macro that takes words from a sentence and puts them in diff cells
  520. Excel COM dll - how to escape from process
  521. Declare a Public Array
  522. UserForm shown and worksheet active
  523. mail merge - pls help me
  524. Programmatically copy text from screen in other application
  525. inconsistant teatment of web data
  526. adding data column without changing sheets
  527. Count repeated entries without typing the entry (large data base)
  528. Make protected hidden row & column headers appear and rehide based ona cell's value
  529. bad file name or number - accesing sharepoint folder
  530. Re: Loop through range, Autofit height
  531. Re: Loop through range, Autofit height
  532. Re: Loop through range, Autofit height
  533. excel addin options
  534. Macro that change words in predefined numbers
  535. Re: Txt to Column wizard
  536. CheckBox / Linked Cell Problem
  537. Need macro that transforms key words into predefined numbers
  538. Mail Merge
  539. Need macro that concatenates cells with text
  540. Run time error 13 - type mismatch
  541. Need macro that delete rows starting with specified letter/word
  542. Controls for Excel 2007
  543. How can i remove the "printing" windows when i print excel workboo
  544. Find matching values, copy/paste values as well as values in ColA
  545. Macro When Worksheet Opens
  546. Cant "picture" Format from Clipboard to .bmp file type
  547. Userform Question
  548. Pivot table custom/calculated field?
  549. Open xlsm as a template file
  550. EXTRACTING ROWS OF DATA/FORMULAS TO CREATE NEW WORKBOOK
  551. Printing userforms
  552. Paste values?
  553. Is it possible?
  554. Update the excel file on my computer, once a new version excel fileis add on other computer within same network.
  555. Find column number of last used cell in a row
  556. Ensure cell contains a number
  557. Programmatically add control to worksheet.
  558. Selecting Range Based on Cell Content then Copy/Paste to New Sheet,Looping
  559. Resizing of picture different in run time and design time
  560. excel 2007 conditional formatting question
  561. Yes, another variable range question....
  562. What is the AcceptLabelsInFormulas workaround for XL2007?
  563. datamining with excel
  564. If Cell = X, Then Copy Entire Row Into A New Sheet
  565. Automatically Adding a Worksheet
  566. If logical statement and a function
  567. Formula Question
  568. Excel Formula
  569. Resolve object pointer any use for this?
  570. UserForm Mouseover???
  571. Macro for Data Mining
  572. Copy rows to different sheets
  573. Search and list in a new worksheet 3 cells from up to 1000spreadsheets
  574. Searching two ranges
  575. Making Default Code Apply to Preexisting Workbooks
  576. How to run a shell command via VBA?
  577. Unhide multiple worksheets
  578. Code Execution has been interrupted
  579. copy records from range to another range
  580. RE: searching
  581. Web Query? Is This Possible?
  582. MsgBox including range value
  583. SaveAS dialog box gives run time error 1004 in Excel VBA
  584. Help with Workbook Calculation
  585. Doesn't work with or without parenthesis?
  586. Slow exports from MS Project to Excel
  587. how do i Save a file with the name i want and with CVS(Command Del
  588. WRQ Reflection
  589. Extract RGB values for selected chart series
  590. How many days fall in each month?
  591. Check for Complie Error in VBA code via VBIDE
  592. Automated Print from Excel to PDF
  593. Searching this newsgroup
  594. Macros will not run with two Excel applications open
  595. How to specify an absolute cell ref in FormulaR1C1
  596. Standard Paper sizes not the right number of points
  597. case sensitive IF, Visual Basic macro IF
  598. "=TEXT(RC[-1],"MMM")"
  599. How to protect formats in unprotected cells
  600. vba to check range of cells and print
  601. Months between two dates
  602. How to change comment Box width and high
  603. Count if
  604. Search for the cell content between sheets and copy corresponding
  605. Using ShowScrollBar API call in VBA?
  606. how to get the PageFields in c# for Excel2007
  607. Textbox value as sourcerange
  608. How to calculate a Range from Row and Column count
  609. Fill serie
  610. Apply error trap to all objects in worksheet?
  611. Macro to place borders between groups or rows
  612. Excel: 'Find All' macro
  613. colour format text when copied from text box
  614. 1004 error when using ATPVBAEN.XLAM!Regress
  615. Insert Comment in Current Call and set then width
  616. RE: Maintaining Shift details Data
  617. Assign Ranges On Different Worksheets.
  618. Concatenate results without decimals
  619. How do you capture the name of the current worksheet in VBA?
  620. Can I pre-load wav file into memory on opening excel wb?
  621. Looking for a value in a previous row
  622. copy unique values into listbox, then modify sheet from these values
  623. Cell Color changes On Input even if new input matches default
  624. Coppying cells, including conditional formatting ('03 & '07)
  625. Add menu to QAT with VBA Excel 2007 & 2003
  626. Inserting and copying Rows based on a variable
  627. slow execution time in excel 2007
  628. How can I get a list of the available printer names
  629. Excel 2000 SP3 versus Excel 2007 --error code 0Xc0000005
  630. Incorporating 2 scripts together that only work separately right now.
  631. macro to copy data and paste to a new sheet in next available cell
  632. How can I get a list of the available printer names?
  633. Re: Lines in UserForm??
  634. Is it possible to disable a single sheet for ActiveWorkbook.Refres
  635. Class Raise Event not firing
  636. Re: Lines in UserForm??
  637. VB Code to save a copy of the workbook as another name
  638. ComboBox.Enable giving error on ActiveWorkbook.RefreshAll
  639. value from cbo box and text box
  640. BEFORE SheetSelectionChange
  641. Tag Property for TreeView Node
  642. Counting entries in a range
  643. Print page based on the value of a cell
  644. RE: Change Cell color
  645. Re: Change Cell color
  646. How to fake/simulate more than 256 columns
  647. Recording
  648. Autofit
  649. xldynamic is back
  650. UserForm and Worksheet ???
  651. vbext_pk_Proc and vbext_pk_Get in Class Modules
  652. UserForm Not Visible on Load???
  653. Code execution has been interrupted
  654. Macro To run after Template Refresh
  655. Activeworkbook.ApplyTheme()
  656. Create merge cells from table definition
  657. FORMS ListBox
  658. Search used cells for values containing named range
  659. Workbook Variables
  660. Copy entire row(s) to another workbook based on partial cell crite
  661. Preview Excel file before opening
  662. Dim item As ListItem
  663. Streamlining macro created by macro recorder
  664. Add - Trim(Clean())
  665. loop thru folder looking for files with date code in name
  666. Insert a calculated number of blank rows
  667. INcremental increase
  668. Data samples
  669. list box listfillrange entity and events
  670. Rich Text Box problem
  671. count visible cells after autofilter
  672. copy entire row and paste values only to another sheet
  673. Counting Colours
  674. This excel sends email when used with Outlook 200 and 2003 but not2007 can anyone help
  675. MACRO HELP
  676. Divide one range with another
  677. how to move mouse using excel macro
  678. Formatting selected chart in Excel 2007
  679. Textboxes and labels in Userform??
  680. run macro in formula with "if" condition
  681. Making Excel visible from Word
  682. How do I use VBA to play sound clip from website?
  683. On error resume next
  684. Compare Two Columns
  685. Excel 2007: create specifically named copies of an autoshape?
  686. Pie Chart Tweaking?
  687. View Access Reports on a Userform?!
  688. VBA help - undo search and show all records
  689. Select TreeView Node with cursor instead of mouse click
  690. How to strore exact double from macro into Excel cell?
  691. Stop Refreshing via VBA
  692. Open spreadsheet on specific tab
  693. hide or remove filter arrows from protected pivot table
  694. Split up delimited string & insert row below
  695. rng propblem
  696. Taking two passes at at Text File using Do Until Loops
  697. copy table to new sheet
  698. Adapting your Unique Value method Attn: Ron de Bruin
  699. Operation is not allowed when the object is closed
  700. How to set up macro in Excel
  701. Inaccurate LAST ROW / LAST COLUMN #
  702. Find cell for today
  703. Font in Header - @22 "25 Miles" goes to 409 font
  704. Macro Help
  705. mix font attributes of text returned from cell formula
  706. Shortcut keystroke for ...
  707. Invalid procedure call or argument.
  708. How to CopyFolder to a readonly Folder? Help???
  709. need to call data from a one worksheet list and insert into anothe
  710. Help Using EntireColumn
  711. Need formula to count blank cells
  712. Run macro if user goes to a specific worksheet
  713. Re: finding cell with + and sorting
  714. Hopefully an easy one - turning a list into a row
  715. Create New Workbook on Hyperlink
  716. Selecting/copying a dynamic range in VB
  717. Format in text boxes with multiple text lines
  718. XL2007: Add my certificate?
  719. Code no longer working
  720. Com Add-In Modifying RIbbon in 2007?
  721. Should be quick and easy to do this in excel but drawing a blank
  722. Dynamic MAX formula
  723. Creating a new "directory" on Sharepoint
  724. Could not set BorderStyle property
  725. Custom Ribbon
  726. Fomat with Code Q
  727. getting the selected range and active cell of a non active worksheetsheet
  728. Don't Show Msg Box if file ext is .xls
  729. if worksheet visible - calendar form
  730. Re:
  731. Blocking Access to Sheet
  732. Differences Between Excel 2007 Versions
  733. TIP: subject matter
  734. HELP PLEASE
  735. External Data
  736. RE: RowSource command
  737. WorkbookOpen in COMAddin for CSV-files
  738. Save with filename ACJRNyyyymmddhhmm
  739. RE: VBA Code to Find & AutoFilter last zero occurrence
  740. RE: Sorting Data from ont sheet to several sheets
  741. XL2003 toolbar macros in XL2007
  742. Excel Can't Complete This Task with Available Resources.
  743. Is this the right way to implement your own VBA Control?
  744. Range Defined names loop
  745. Processing Text Data for importing into Excel
  746. Recordset to Listbox, no application.transpose
  747. Can this be done as a Case statement?
  748. possible to enumerate objs from drawing toolbar - like textbox in
  749. Best Practice for Obtaining hWnd
  750. Find and replace a character in a cell with another cell's content