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. Userform - need to access data from a particular sheet
  2. small easy userform
  3. if then else
  4. delete rows
  5. Alternatives to "WorksheetFunction.VLookup"
  6. Hiding rows with zero values
  7. automating import of several text files from specified folder
  8. excel macro in '97 does not work in Vista
  9. Need help with userform vb code, any help would be appreciated.
  10. Add help or help file to a user defined function?
  11. Macro to insert at correct point
  12. vb add-in manager is empty
  13. solve for a variable
  14. Help with find/replace
  15. Format sheet programmaticlly??
  16. Help for VBA Functions
  17. Macro Path
  18. Search worksheet from add-in
  19. Change Text size on focus
  20. how to format a date to be used in sqlstring in excel 2007- contd
  21. Pivot Table Macro
  22. Deletions
  23. Shapes(Count)
  24. Search code help needed??
  25. Center Checkbox
  26. Macro Path
  27. Need Text box value to be $5,000.00 not 5000
  28. Code to copy cell borders and fill color from one cell to another
  29. SpecialCells(Formula) --> Value
  30. Dynamic data in PivotSelect statement
  31. Copy date from row 1 to last row next sheet
  32. User Permissions
  33. copy WB without VBA: copied sheets link back to source WB
  34. Connect to Sharepoint List and Update Values from Excel
  35. Code replacement
  36. How to close All Workbooks
  37. Userform Scroll Bar Doesn't Update in Real time ???
  38. Autofilter +Create Sheets
  39. RibbonX: Problem with OnLoad
  40. how to format a date to be used in sqlstring in excel 2007?
  41. Certificate not trusted
  42. Unique values in a macro
  43. Macro malfuntion
  44. display cell only if it contains a value
  45. Overcoming an Error Message Q
  46. tricky password
  47. Use lookup to write to cell
  48. Subscript Out of Range ... Setting Page Breaks
  49. Please Macro or Formula Help needed
  50. Displaying Text on a Forms 2 Form
  51. Save a shared file as webpage
  52. Default commandbutton
  53. Empty a cell if the values equal to "IN" , "MC" or "PP"
  54. Auto Populate multi cells
  55. Extract Cell Contents to String
  56. How to: if a range is not empty don't allow close?
  57. Return Rows of Selected Range in a Pivot
  58. Delete rows containing same value in two columns
  59. Creating PDF from Excel Using PrintToFile
  60. for each character in a cell
  61. Help with code: Security and web queries
  62. Simpler way for nested If statements (VBA)
  63. Create macro to load custom toolbar
  64. Code into MS Object Sheet Hangs up
  65. User Form
  66. conjugating 2 sheets. pleae help i'm already late for the deadline
  67. Call a Control_Click Event when UserForm is Initialized
  68. Excel VBA DAO Data Control
  69. Error code 13
  70. Automate Excel download of csv file without proper URL?
  71. Error: can't find project or library
  72. Drag & Drop in ListBox Ctrl: Find pointer position on mouse up?
  73. Macro generates "Type Mismatch Runtime error"
  74. Need Help with Pivot Table
  75. Chart transparency
  76. MACRO TO GET BALANCE FIGURE
  77. Select Cell and open UserForm
  78. copy to next blank cell in colum
  79. Pivot Table Calculated Field
  80. Macro to grap certain cells and copy.....
  81. Series function& protect sheet in excel 2007
  82. Test if a file is password protected
  83. IF and OR Functions
  84. XML and DOMDocument
  85. Refresh workbook changes without saving
  86. Shared Excel worksheet
  87. excel
  88. add new worksheet after specific sheet
  89. Open Workbook Assignment
  90. userform from scratch
  91. Paste and Paste Special options are disabled
  92. Paste and Paste Special options are disabled
  93. Paste and Paste Special options are disabled
  94. Help with search code
  95. Scrolbars
  96. how do i get word conversion number to text in excel (100 = "hundr
  97. Form ScrollBar Help
  98. Custom Function Desired
  99. Need help creating a formula
  100. In Access Can't Run Excel Macro Through Automation
  101. Dynamically Building List
  102. Macro to Find a specific data set and do a count
  103. Add records to sheets based on a variables table
  104. Automatically Excuting a Macro in a different workbook ?
  105. parameter to open file name in macro
  106. XL Odd behavior interaction between dynamic range andSheet_Deactivate macro
  107. VB/VBA to read Task Manager
  108. VB/VBA to read Task Manager
  109. VB/VBA to read Task Manager
  110. Copy Formulas
  111. Truncate Left Characters in Cell Value
  112. Pivot Table based on data in protected cells
  113. delete checkboxs
  114. Adding to text's togther in a data value in a chart
  115. Passing Variables between Workbooks
  116. range.address, replace characters
  117. Renaming files in a directory
  118. Copying data
  119. Excel Justify
  120. renaming a page doesn't stick
  121. Last Used Cell in a row??
  122. refreshing a multipage
  123. Error Application Defined or Object Defined
  124. date format conversion
  125. Change Event duplicating action
  126. How to change the default caption of a workbook to the full pathname?
  127. List all internet explorer (or other) windows (and close them)
  128. Displaying YTD for each Month Selected
  129. Sub to copy n paste as values based on an "instructions" table
  130. Keydown event on a userform
  131. Showing text on A Userform
  132. naming my worksheet
  133. 2 userforms, 2 UserForm_Initialize()
  134. Text Box Enter and Exit Events
  135. Disable Menu (CommandBar) if not workbook is opened
  136. [SPAM]
  137. Worksheet Change Event Does Not Work When Reopening Excel
  138. public variables, 2 userforms
  139. Assigning a hotkey to run only from a given range
  140. A "chessboard" problem
  141. Peter T's Copy WorkBook Contents Copy
  142. excel security
  143. setting focus to particular textbox
  144. etract unique data from multiple workbooks after extracting data
  145. making a different sheet active
  146. Run Excel macro from XP shortcut menu
  147. Creating first excel addin
  148. Memory leak
  149. Error retrieving data from closed workbook
  150. urgent ?
  151. rotation of an arrow created by an drawing object
  152. retrieve data from Access Database
  153. worksheets
  154. Catastrophic Failure -2147418113 Lost Project
  155. Userforms, switching sheets
  156. Help with code creation
  157. How di I make an XML file from this unusual xls...
  158. OPENFILENAME A P I. User cancels ?
  159. open and printing workbook with vba
  160. Separate Numeric Values
  161. Fiind the newest file
  162. Getopenfile
  163. Detect page break preview
  164. Passing Array Formula result to a variable in VBA (Leo)
  165. change color of command button problem
  166. Named ranges scope / workbook/worksheet level named ranges- changeswith variable use...
  167. Saving a file every fifteen minutes
  168. “Merge” data from 2 Excel files
  169. How to get printable area of the page
  170. Remove extra space within text
  171. User Defined Password
  172. Name of Current TextBox on Userform
  173. A Little More Advanced Range Fill-In
  174. Macro Conversion To Relative Cells
  175. Vlookup on a VB Form
  176. zoom problem ??
  177. Create A GUID
  178. Image popup (as comment) when you mouse over.
  179. Add a period to name initials
  180. do...loop with timer problem
  181. caculations letters
  182. finding only numeric values in a worksheet using vb.net?
  183. Ribbonx - how to create two ribbons?
  184. VBA password removal - how many tabs?
  185. about .exe file
  186. A #NAME? problem with a transferred function
  187. refer to an object in a group
  188. Multi Workbook Data Extraction
  189. reference to external ranges
  190. How do I start a Process I can then communicate with from VBA
  191. toggle borders macro
  192. Listbox load event
  193. moving controls in X & Y axis
  194. how to make a userform like the built in Data form
  195. Lots of REM lines an easy way?
  196. How to change the color of a page
  197. Openform event
  198. Automatically Update Workbook Links as part of AutoOpen Macro?
  199. How to iterate through columns?
  200. Copy range
  201. How to tell if sheet exists in closed workbook
  202. VBA to select the cells next to the result of a find & combine the
  203. From Column to Row without blank cells
  204. rotate highlighting colors macro
  205. unprotect sheet failure
  206. Open with Openform; Workbook not visible
  207. Pharsing string from the right to the first space
  208. Worksheet_BeforeClose conditional Worksheet change
  209. Simulation
  210. Can I open an Outlook dialog box from Excel?
  211. create macro "merge selected cells"?
  212. Custom List
  213. expanding numbers?
  214. Passing Array of User Defined Type to Form
  215. Convert Text into Numbers
  216. Ron de Bruin's code "Copy a range from all files in a folder and subfolders (optional)" ???
  217. xls size doubles
  218. cut and paste with loop macro
  219. xlCurrentPlatformText
  220. xlWorkbookDefault
  221. toggle between autofilter Criteria1:= "*" and "all"
  222. deleting multiple rows
  223. data type mismatch error
  224. Opening a file command doesn't work
  225. week function in vba?
  226. sort issue: Excel seems to be treating my column of numbers"alphabetically"
  227. Help with debugging
  228. date confusion
  229. getting the active chart/chartobject's name
  230. Change name of pictures in worksheet
  231. atpbaen.xla
  232. parsing data
  233. Turn formula into Select
  234. Sheet problem???
  235. Select different data label range (as values)
  236. Speeding up execution of a Macro
  237. Chart label questions
  238. Activating an open file with a variable name
  239. combobox doesn't load cell value at startup
  240. ComboBox.visible = False or True
  241. Variable Case issue
  242. moving to next cell without keyboard
  243. autofilter next and previous record problem
  244. Sumif function problem
  245. How many pages will be printed?
  246. autofilter row count
  247. copying many controls
  248. Error 55 File Already Open
  249. Using variable to identify a workbook
  250. splitting a file into two before importing it to excel
  251. Superscrpts in Excel 2007 Text boxes
  252. Username and password login.
  253. Fastest way to save workbook
  254. pop up calender in a userform
  255. add certain fields in msoenvelope
  256. Copy userform in msoenvelope
  257. Need a faster way to update values selected by advanced filter
  258. "Lines on 2 Axes" fails on Excel 2007
  259. Can I have code executed after Save?
  260. Trusted locations
  261. User defined - conditional between statement???
  262. Background color change, by using the formula.
  263. Consolidating data from various worksheet of same excel file
  264. changing value on a userform
  265. combobox data doesn't take affect right away
  266. Copy data
  267. copy foo.xls whilst it's opened by Excel - are there problems ?
  268. Discrepancy between manually formatting sheet vs. using VBA macro
  269. Selecti Page in Userform by Name not Number
  270. pasting from one sheet to another
  271. copy paste is changing the cell value format.
  272. Text boxs
  273. Write Additional Data within a txt File
  274. Create a calendar in VB with excel 2007??
  275. Maximum number of controls on a user form
  276. Onkey Key Codes for ADD and SUBTRACT keys in earlier Excel version
  277. Named ranges disappearing in Excel 2007
  278. A List of Collections and Custom Collections
  279. Redefine UsedRange property of Worksheet Object
  280. Looping through and array with three possible decisions to make
  281. add lines to a order list
  282. excel - inserting a formula in a cell (using =) fails
  283. VBA "sheet" NOT to minimize while working on worksheet
  284. Difference between 2 times
  285. Worksheet copy without user interaction
  286. Format sheets w/varying ranges
  287. Extract MS Query Cell Address
  288. LoadPicture compile error
  289. Graphing by seconds
  290. Determine if a PivotField is visible?
  291. Security Concerns using interop excel
  292. "Unreadable content"
  293. if then else problem
  294. "Sheet(1)" Syntax
  295. Customized menues
  296. On Error problem
  297. Number Value Check Question
  298. Using a form to edit data
  299. Referencing a cell in VBA from a different worksheet
  300. Retriving value from multiple sources
  301. ExecuteExcel4Macro("GET.DOCUMENT(50)")
  302. Counta with CountIf
  303. Search Directories/SubDirectories UserForm
  304. Combobox not scrolling
  305. change formula dynamically
  306. ListView - How to add checkbox column
  307. Copy Columns to New Sheet
  308. load data to cell comments
  309. getting behind the Hyperlink
  310. Putting large array into a worksheet
  311. Array Memory Size
  312. Simple method to webonize my spreadsheet
  313. macros... again
  314. Inconsistent Code?
  315. Allow Edit doesn't forget
  316. macros
  317. copy worksheets between workbooks - including named ranges
  318. about check boxe
  319. macros
  320. Suppressing the UPDATE while opening a file
  321. Active Sheet
  322. Date Question
  323. Insert rows in many sheets
  324. Modify function for another workbook
  325. run macro although blinking cursor is active in an active cell
  326. Add record to end of list, variables table
  327. changing font size in an activex label
  328. Excel VBA Evaluation of FormatConditions(1).Formula1
  329. replace blanks with values above
  330. Combo box change event fires twice
  331. How do i copy a cell from a workbook to another workbook?
  332. Easy One - do math with Textbox values
  333. Addin Macro Call
  334. Open a form from an Add-In
  335. Workbook_Open() of locked project causing errors
  336. How to obtain the names of all installed fonts
  337. Clear Range
  338. offset from combobox on userform
  339. Percentage formating in macro
  340. Variable Help
  341. Copy and Paste Macro
  342. List files on SharePoint
  343. Excel 2007 Craches when closing via macro code
  344. Close PDF files
  345. VBA and Colorwheel
  346. Attaching Macros To Items In a List Box
  347. 1 file- multiple headers, move columns to match first header
  348. convert excel to VBA
  349. PrintPreview error when run from VBA
  350. Updating values using advanced filter - VBA
  351. called macro
  352. Close workbook without being prompted to save in VBA
  353. Keep Timer Going While Altering Workbook
  354. Sheet Code Name vs. Sheet Name
  355. set focus to form
  356. if not isempty combobox does not work ?
  357. Module Name
  358. Row Number
  359. VBA to Select Cells with Conditional Formats
  360. Condition formula
  361. VBA Date Format Cell Check
  362. Simple Multiplication Formula
  363. Compatibility question
  364. Drop Down List & VLOOKUP
  365. Condition formula
  366. Y doens't this work?
  367. Mixing Fonts in a single text cell
  368. Progress bar that is constantly updating
  369. Easy One - Syntax for variables in TextBox & Label names
  370. new formula after condition met
  371. I need template for day trading
  372. Counting ranges
  373. UserForms to populate cells in a worksheet
  374. Server Calculated Members in Excel 2007
  375. Applying the target formatting
  376. Checking Column Constraints
  377. Print 2-Up
  378. add listbox item for all sheet same range
  379. How to count number of red font cells or rows
  380. Limit textbox to 255 characters
  381. Excel Validataion listbox
  382. advanced filter, goto next line(record)
  383. Removing vowels from words...
  384. Last Item in Column
  385. Windows file property access
  386. area code
  387. "Find all" and show the cell addresses in a MsgBox
  388. click cell and get a pop up number pad the one used in ms money
  389. Generate ongoing database of results via Macro
  390. probably a relatively easy macro question....
  391. Running a Macro Without Apparent Code
  392. Toolbar macro re-named
  393. Open a workbook with Notify option
  394. Case Statement for Changing Font AND Background Color
  395. Populate one cell with an offset cells contents
  396. Indirect in Conditional Formatting
  397. Trace dependents in protected sheet
  398. comparing amounts
  399. Range help
  400. Simple Question about combobox
  401. Excel copies graphics from one sheet to another arbitrarily
  402. Replace a cell (I2) with a cell (H2) if I2 = "a"
  403. Selecting multiple tabs in VB
  404. Associated Worksheets
  405. Method 'Columns' of object '_Global' failed
  406. Variable count and bound random numbers
  407. C# Excel Automation AddIn Help message
  408. searching data in XML from EXCEL
  409. Help with calling word reference from excel vba
  410. Limiting Size of Excel 2007 Spreadsheet
  411. Naming Cells - need help
  412. how do i empty the clipboard from within an excel macro
  413. Excel User Interface - Performance Testing
  414. Avoid Confirmation Questions
  415. Change PasteSpecial
  416. Form/Input box
  417. Importing Text File into Excel loses leading zero on some fields.
  418. Listbox horizontal scrollbar problem
  419. (Reverse Union) Randomly draw address from Range
  420. Sumproduct
  421. Combobox List Drop on Entry
  422. Problem with If-Then-Else Statement
  423. Conditional Formatting to VBA code
  424. Worksheet_Calculate fires for every worksheet in book?
  425. Type Mismatch
  426. object disconnected from client error message
  427. Inputbox to return range from another workbook
  428. Turn Off Circular Reference Message
  429. auto date
  430. Ressources about controlling html from VBA
  431. Declaring subs Public vs Private
  432. Macro for user defined Solver changing cells.
  433. How to Call Functions in the Personal Workbook?
  434. Importing data from excel to excel
  435. Copy Sheets to another workbook
  436. How do I write a macro for keeping time?
  437. How to retrieve text from the textframe of an oval shape in Excel?
  438. Conditional Formatting...
  439. OLAP - use CUBE functions to sort on the basis of underlying set
  440. Problem with saving documents as .csv file
  441. Long running operations
  442. how can I put the data from the second sheet in the first sheet?
  443. Re:
  444. Hiding sheets using code
  445. Can Macro command to open files?
  446. Pivot Table changing sum values using VB
  447. ListBox Column Widths
  448. Macro for Solver with user defined changing cells
  449. Reply
  450. New to Macros
  451. How do i seperate colums when special pasting information
  452. BeforeClose running twice
  453. Difference of HyperLink in Excel, between Windows XP 32bit and 64b
  454. changing size of characters in a selectionbox and date in a textbox
  455. Pls explain this VBA oddity
  456. setting print range based on looking up values
  457. mouse focusing in close button in preview window
  458. how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells
  459. Blocking a Windows Message
  460. cell.formula returns value
  461. creating a userform
  462. VBA Programmer Wanted for Short, Paid Contract
  463. Run Code on Activate Sheet
  464. Macro to copy values from a table
  465. XLA Deployment
  466. efficient / easy way to convert an Excel.Range to a double[,]
  467. Combobox help.....really easy I imagine
  468. Convert Conditional Formatting Into VBA Code Button
  469. referencing commandbuttons as OLEObjects
  470. Variable Series in graphs
  471. "Compile error in hidden module: This WorkBook" only appears whenproject locked
  472. Insert email address from Outlook into ActiveCell
  473. Insert email address from Outlook into ActiveCell
  474. click in a workbook
  475. Generating Graphs (XY scatter Plot)
  476. Accessing ranges with integer variables
  477. Copy doesn't copy in Sub Extr10L
  478. Check for directory then create
  479. need a alternating password
  480. Find Chart Sheets in workbook
  481. Area Select Tool
  482. ActiveWorkbook.ConflictResolution
  483. is there a "switch p, case 1 2 3 ...." flow control in Excel?
  484. Excel Range In Word
  485. Text File Data Formating
  486. Not resetting all cells
  487. End(x1Left) to column a
  488. Goal Seek on multiple rows/columns???
  489. EXCEL6 Window Class or Typed Value (WIN32)
  490. Problem with macro adding rows
  491. CSV line feed delimitter
  492. MergeCell range
  493. How to position to a specific sheet before saving
  494. selfcert.exe
  495. conditional formatting in excel vba
  496. Auto/Manual Calculation
  497. Converting a GPS waypoint from decimal to degrees, minutes and sec
  498. Using XmlImport to get dynamic data in Excel 2003
  499. Copy Rows using criteria
  500. command button properties
  501. Problem with adding rows
  502. Search Modules for Cell Addresses in Range Variables
  503. another code not working
  504. application or object defined error on print to file
  505. Splitting data on sheets for more than 65536 rows...
  506. HOW TO CHANGE RANGE
  507. Calendar not in a cell
  508. From HKBN
  509. questionnare
  510. code not working
  511. What can we use as an equivalent to "Sleep()" in vb?
  512. Floating textbox/label
  513. NEED CORRECTION IN MACRO
  514. code to move images
  515. Automatically copy formulae to next empty row
  516. Copy excel chart as picture to a particular ppt slides
  517. ConnectCode's new productivity tool automates removal of duplicateentries in Excel
  518. choos one of two comboboxes
  519. How Do I Use DispCallFunc with IMLangCodePages::GetCharCodePages
  520. Is it a bug? in VBA, FileName (with "[", "]") changes after opene
  521. Problems with Hiding/Showing Modeless Userforms
  522. Combobox problem, please help this novice!
  523. Calender not working in excel 2007??
  524. Excel template usage???
  525. Data Consolidation using dynamic path
  526. Formatting not updating inside a function
  527. error in setting chart area width
  528. Combobox_Change event fires on workbook close
  529. Screen "Flickers" When macro Starts !!
  530. Default Cell Formatting
  531. Comment disapears
  532. LOOKUP VALUES FROM OTHER SHEET
  533. Refreshing External Data
  534. Delete Matched Cells
  535. Macro to Lookup Exact Value
  536. weekly report
  537. Bias in rand for excel 07
  538. correction needed
  539. Where did Tools>Reference go?
  540. batch file for collated printing
  541. add a dropdown calendar to a worksheet?
  542. profit/loss calculator
  543. makro to log info in Access
  544. NEED MACRO FOR COLOUR BY CONDITIONAL FORMATTING
  545. I want If and Vlookup together in one cell
  546. Horisontal scroolbars problems
  547. excel files will not down load from outlook
  548. Open a dialog box
  549. difficulty with percentage from worksheet as seen by VBA
  550. Copying dada from multiple workbooks into 1 workbook
  551. Need Help: Strange, Strange Behavior ( Not Me. My Model! )
  552. Range Question
  553. one per day password
  554. vlookup ?
  555. Formatting a single column
  556. <xxx is not a valid add-in> error in Excel 2003 SP2
  557. Help with Userform/Autofilter/VBA
  558. Clone Sheet?
  559. GetFromClipboard help needed please
  560. enter text in cell just by selecting cell
  561. dates in macros
  562. indirect?
  563. Please Help
  564. copy rows to next sheet
  565. Error Message
  566. Tab Name
  567. Emailing Activesheet As Body of Email
  568. setting page breaks based on value & printing to and from value
  569. information message
  570. copy rows based on cell colour by conditional formating
  571. TMOO - Mood tag<055afe80-b296-4109-9e1f-2c82cf08bc60@v4g2000hsf.googlegroups.com>
  572. ADO 2.7 recordset problem
  573. Public variable not storing
  574. How convert VBScript to VBA?
  575. Visual Basic
  576. compile error in hidden module: sheet1
  577. labels
  578. Name limits
  579. If - End if problem
  580. Problem running VBA 2000 code in Excel 2003
  581. Re: workbook sharing entries at the same time
  582. getting current procedure name
  583. Pivot Cache error using Range object containing cell with 255 char
  584. copy & paste columns to new worksheet
  585. Offset & Range
  586. Column label based on column index
  587. Problem with multiple error handling
  588. Dumping Data Into Excel
  589. Add worksheet to workbook of calling procedure
  590. highlight a list
  591. Better example I hope how can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2
  592. Fill down function
  593. if an element in a row is true then copy whole row to another shee
  594. Getting unnecessary 2nd Page
  595. macro to prit to pdf
  596. Launching Standalone Program from within Excel.
  597. Macro formats field with value
  598. Worksheet tab won't update.
  599. Remove passwords from many workbooks
  600. How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2
  601. Sort worksheet tabs based on ASCII values.
  602. Automation performance degradation in Excel 2007
  603. PopUpMenu in Flexgrid - Excel2002
  604. ConnectionString Timeout After 60 seconds
  605. Excel Properties() collection
  606. Macro for User defined Excel Solver
  607. Compare values of cells in a range
  608. worksheet range qualifier
  609. Active cell hunt
  610. Disable the Close button on a Userform
  611. workbook sharing entries at the same time
  612. delete columns
  613. BeforeDoubleClick
  614. PopMenu in Flexgrid (with Excel 200)
  615. disable copy and save as
  616. Decimal Places
  617. Making new Pivot functions
  618. How to ORDERBY Alphabets in ascending order?
  619. VBA versus VSTO (fundamentally excell based)
  620. file not there
  621. excel VBA programmer, what is the value of adding access for data
  622. quick Conditional Format question <--rookie here
  623. hiding sheets using a form
  624. checkbox to hide/show row
  625. help
  626. remove macros
  627. VBA to sort blank cells to bottom <--help please :o)
  628. Macro to Enter text
  629. How can I make arrow keys skip over cells?
  630. MsgBox Help
  631. Activate Range for Workbooks Already Open
  632. Excel 2003 VBA Help me complete this Search script
  633. Return To Last Active Sheet
  634. Excel to Powerpoint - Text Box Properties
  635. Code for sending Outlook email with attachments using a list
  636. copy rows based on cell colour
  637. copy rows based on cell colour
  638. DDE Link format question
  639. Programmatically Extracting Validation List
  640. adding worksheet with macro but need to get back to 1st sheet
  641. Application.FileSearch in 2007
  642. Locking cells after the user has entered values in protected works
  643. question on excel 2007
  644. Excel Calculations through VBA
  645. Prime numbers
  646. Finding a value in one of two columns
  647. Import data from access problems
  648. Need assistance with code issue??
  649. locating cell that partly matches a text string
  650. Display contents of text file in a listbox or textbox on Excel for
  651. excel to CSV
  652. Import data from multiple excel files in one folder
  653. Month to Number format
  654. Rounding formulas
  655. Excell Random number
  656. UDF that works under Excel 2003 but not under Excel 2007
  657. Find Last Used Row
  658. Unicode strings and Excel 2003
  659. Problem asttaching macro to form button
  660. deleting cells
  661. Macro That Deletes Rows Extremely Slow
  662. delete cells
  663. Adjust series order in Excel 2007
  664. Lookup
  665. tlbimp vs. primary in VS project file
  666. Open , Save, and Close Macro
  667. Excel Interop DLL problem 2003
  668. Macros missings
  669. howto replace the order of adress ?
  670. How to diagnose a COM addin that fails to load?
  671. Data Validation by List
  672. Paste data into another workbook but not overwriting original data
  673. Age old business day with holiday entry
  674. Check range of cells for non-null values
  675. UserInterfaceOnly not being recognised
  676. Update Custom Toolbar Buttons
  677. Automation stumble
  678. Automation stumble
  679. Automation stumble
  680. SaveAs without closing original workbook
  681. Drawing on a Chart
  682. Importing from another file of unknown name
  683. Saving to Intranet Site
  684. right click menu
  685. pop-up calculator
  686. Setting variable print areas & pages to print
  687. HELP & Commercial
  688. find numbers in text and put value in another worksheet
  689. Application.Iteration in UDF
  690. Conditional counting with multiple criteria
  691. Moving data makes unwanted change to formula
  692. UDF Optional variables become required in Add-In
  693. Simple Excel formula
  694. removing a macro
  695. VB error
  696. Limit on Range Object
  697. Insert Formula in Range
  698. Simple VBA Macro to import Data
  699. Userform Frames Occasionally Disappear When Form is Activated
  700. lookup
  701. adding combo/list box to msgbox/inputbox
  702. looking up
  703. VBA Excel Conditional Formatting <--rookie here
  704. RE-Post Max Function not working properly on 2D Array
  705. Refresh Data on hidden worksheet <--help please
  706. Elapsed period between dates
  707. Change all Links
  708. printing with out data
  709. How to Copy a sum of a column from different Excel sheets to a single master excel sheet?
  710. Dialog Box
  711. macro to move data to new column
  712. Checking a setting on startup
  713. CurrentRegion issue (attempt 2)
  714. Currentregion issue
  715. Application.ScreenUpdating problem in Excel 2007
  716. How do you report a bug to the Microsoft Dev Team?
  717. Range analisys
  718. Variable number of parameters in Excel User Defined Function
  719. Read text file and UNIX end of line
  720. Mouse Scroll event in listbox kills Excel
  721. Date Format code with error now
  722. Change Hyperlink addresses in a worksheet
  723. Replace worksheet
  724. What am I missing here???
  725. Keyboard Macros
  726. Remove Pivot CommandBars from right click menu
  727. Right() error changing columns in macro
  728. Very long code execution time problem
  729. I have a query about loops and random numbers
  730. Date Question
  731. removing special characters
  732. VBA code, delete worksheets
  733. Please help with my code
  734. Using comma inside the comma delimited text in Data Validation/Sou
  735. Help with user interface for charts
  736. Select Case and If...Then Statements in UserForm not Calculating
  737. Excel default workbook
  738. Macro to extract data from webpage
  739. Help required with 'FOR' Loop and Userforms
  740. Repeat
  741. Dot Trailers '...' in Cells where text is too long...
  742. activating a page of a multipage control
  743. Hide and Unhide Rows button
  744. Determine if the sheet has been changed
  745. VBA, copy unique values
  746. Code hangs second time around
  747. Problem with macros
  748. Help with C. Pearsons code to VBE
  749. coding for excel programming
  750. Hiding Formulas