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. Remove add-in
  2. RE: XL file opened using automation - how close?
  3. Print Preview slows my code?
  4. RE: Macro to merge cells of the same colour/pattern index
  5. RE: Pass Parameter from Excel to SharePoint
  6. How To Remove VBA Code For Distribution of an Excel Sheet
  7. starting a function will not allow comm_button
  8. RE: Remove spaces
  9. Show / Hide items in Pivot Table as required
  10. RE: Macro to delete rows
  11. RE: not in array
  12. automatically number a table in word document
  13. RE: XL file opened using automation - how close?
  14. RE: Odd VLOOKUP Error
  15. RE: Macro to delete rows
  16. Have VB Code "on" for all workbooks
  17. code to delete vba code
  18. Can we set the UI color scheme via VB[A} or XML?
  19. Change checkbox value
  20. Conditional Formatting with Hyperlinks
  21. RE: Remove spaces
  22. Rotate application
  23. RE: Can you calculate delta time using different entries
  24. Calendar Control
  25. Linking data with variable cell location
  26. using the cells property for use with Application.WorksheetFunction.Sum
  27. How to access macros via tool buttons?
  28. Sorting stuff into alphabetical order
  29. can I use code to make code in another book
  30. VBA to insert .xlborder if cell value not equal to previous cell
  31. Optical Character Recoginition
  32. To show a message box if the mouse is over a particular cell??
  33. Fix Broken Cell Formula with VBA
  34. Cosmetics
  35. Reading system log files
  36. Icon in Notification area
  37. Icon in Notification zone
  38. Next weekday ...
  39. Next without For Error
  40. Copying worksheet from hidden instance of Excel
  41. Delete Columns if sum is 0
  42. Conditional formatting if condition of an if statement is true and astring value is displayed
  43. Looping Open and Save as CSV
  44. Calendar Control 12.0 help
  45. Reading properties from closed book
  46. Addins attached only to selected workbook(s)??
  47. Still need help with a code reference problem - Excel 2002 XP
  48. Timer question
  49. date handling problem with International issues
  50. Advanced compare of two worksheets
  51. Calling a sub on another worksheet
  52. Programmable Column Sequencing?
  53. Userform ComboBox Row Source
  54. Excel 2007 sorting ribbon is not working with .Net save code
  55. Problem With Code...Still
  56. Text Formats
  57. AutoFilter macro
  58. Macro for merging rows
  59. Code "crashes" after dynamically adding control to worksheet
  60. sumif help
  61. Email From spreadsheet
  62. Hand Icon when sheet protected problem ?
  63. VLOOKUP VALUE ERROR
  64. Printing sheets based on a cell value
  65. Autofilter macro
  66. MultiWorkbook Change Event Detection / Spell Checker
  67. Automatically Copy Information when data is entered
  68. Open Excel file from SharePoint; opens as ReadOnly
  69. For statement behaving very strangely
  70. Newsgroups going bye-bye
  71. Non existent code reference problem
  72. SendTo
  73. EXCEL 2007 - export to dbf files
  74. Exporting to .txt converts single quotes to double quotes
  75. P.S.
  76. File not saving
  77. Autocompletion For UDFs?
  78. Autocompletion For UDFs?
  79. New functions needed
  80. Comparing Apples and Oranges
  81. GetOpenFilename code execution interrupted
  82. Copy data in table to column in worksheet
  83. Create a list with multiple criteria
  84. Parsing a string
  85. Register HelpID via Categories dll
  86. Using Color as Criteria in Countif Function
  87. Finding the end of Data
  88. Protection
  89. Answer Message Box - Other than Y/N?
  90. Running another program
  91. Controls in a frame within a frame are always invisible - What am I doing wrong
  92. Pivot Table Macro Run-time error
  93. Button to add Rows on Form in Excel
  94. Protection Tutorial
  95. Macro to rename Tab and then save as
  96. Need Suggestions - Find < 30 days & Mult-Location entries
  97. View what macro is assigned to a tool bar button
  98. Fire a macro
  99. please help.. highly important...
  100. Excel wait for Find Replace dialog box in Word
  101. Re: Drill down pivot table data via VBA macro
  102. Using Trim in a Userform
  103. Date programing in a cell
  104. Creating a formula which references a dynamic cell location
  105. Sort Order Doesn't Seem Correct
  106. Latency on the move - without tripping down the stairs!
  107. Save in different folder
  108. Help with forcing chart axes scale
  109. How to code it in macro?
  110. Blinking Text
  111. BKF files
  112. autofilter master copy data to worksheet
  113. Coding for inventory
  114. creating a pivot with external data source (from access)
  115. pivot table with external data
  116. "000" reverts back to "0" even with a string
  117. Entry data sheet automaticlly updates or adds data to differant sh
  118. Re: Maintaining Text Box Font Setting (Excel) using VB
  119. One line is killing my program!
  120. Testing/Finding .Hidden for Rows May21
  121. watermark
  122. Check out Excel file from SharePoint; if no other Excel file is op
  123. Maintaining Text Box Font Setting through VB
  124. Problems with ACE OLEDB provider
  125. ounces vs. pounds
  126. Using Select Case on Single column only
  127. I need VBA Help for Excel spreadsheet -- Please!
  128. General Question on one line of code - parentheses and quotation marks
  129. RowSource property in cbox
  130. Open Add-In (.xla) workbook as Read Only automatically
  131. Change Gradient Fill Colors of Bar Chart data points
  132. RE: Count Workbooks that are open; Prevent another from opening
  133. delete single occurances in a string
  134. xlPasteValues is also pasting Formats
  135. Open & update another file (through macro) while running macro
  136. Conditional Formatting
  137. get Control of a Butoon placed in the Sheet
  138. How to prevent a graph update
  139. Redefining a table range with a macro
  140. value of value of a variable.
  141. Get control of a Userform by the Name
  142. Command Button to import worksheets
  143. Getting data from a closed wbook (adaptation of rondebruin's)
  144. Identifying other users
  145. Help changing Keyboard Shortcut assigned to Excel Macro
  146. how to disable update links message when opening files
  147. Macro to add / delete column
  148. Public Variable problem
  149. Save BeforeClose
  150. Check numeric char
  151. Prevent Save/Publish
  152. String Search
  153. Disabling Built-in items on a menu
  154. visual basic excel 2000
  155. Application.VLookup and External files
  156. Capture Date from External Sharepoint Portal
  157. SaveAs *.txt - Outputting with Text quantifiers
  158. launch instance of excel without loading personal.xls
  159. Disable Save
  160. Running formulas with data from mulitple workbooks
  161. DTPicker controls missing from userform
  162. Re: Calling Excel shortcuts from VBA
  163. Columns("C:C").Value = Columns("D:D").Value not working after adding16th page
  164. Setting a reference to the Ribbon
  165. Unlink chart from sheet
  166. Option Group actions
  167. How to read Checkbox-Value if only position is known
  168. Re: retrun an RGB value to a specified cell
  169. Calling Excel shortcuts from VBA
  170. Autocomplete Custom Functions and functions arguments
  171. Export Several Worksheet Groups (Values Only) Macro
  172. Fails to delete empty rows
  173. Code not working as expected
  174. Can I put something in the footer that reads from the sheet
  175. Cell colour format according to date
  176. Application.Visible=False
  177. dynamic range definition
  178. "Update" calendar on userform?
  179. Send data to serial port
  180. Modify sub to work on cells with formulas
  181. Re: Number of lines in the Immediate Window
  182. Set object with a function
  183. Open_Files_In_A_Directory
  184. match two conditions to return value from pivot table
  185. Macro to sort, format, sum, a dynamic set of data
  186. VBA to check omissions and show/hide form
  187. Save as cell reference then email
  188. VBA Workbook Open Function
  189. Not sure what to call this
  190. How to display a macro generated menu in Excel 2007
  191. How to update .xlam file (add-in) while it is in use?
  192. use Excel Now() in VBA
  193. Option group controlling objects
  194. Sheet change event to return sheet name just left
  195. Insert Page Break After Partial Text Match
  196. Excel ODBC driver created table/inserted data lost on application
  197. File folder info. in Excel workbook?
  198. Custom validation rule - must be 15 increment of time
  199. What does Compile VBAProject do
  200. Autofit row height in only some rows
  201. Conditionally count unique values
  202. Bug Report: VBA runtime Access Violation
  203. VBA in IE window
  204. retrieve data into a spreadsheet from a copy of that spreadsheetwhich is saved as its own xls file
  205. Convert number to letter 123 to ABC
  206. Checkbox or Option Button
  207. Search Option
  208. Application.OnTime - Macro Cannot Be Found - Internet Explorer
  209. Application.OnTime - Macro Cannot Be Found - Internet Explorer
  210. UserForm_Terminate problem
  211. loop through all worksheets
  212. stop VBA in solver when maximum iterations reached
  213. save(append) to an excel file
  214. Change Pivot Table Page Value
  215. Tracking an email when sent directly from Excel
  216. Creating a common starting point
  217. .PutInClipboard
  218. Help with VBA and SUM
  219. If no activity, display a UserForm; 10 seconds later close Workboo
  220. UserForm1.ComboBox1 to initialize
  221. Copying a sheet fails
  222. XL 2007: How to find out what keyboard shortcuts I've assigned tomacros?
  223. Special character in Input Message - Data Validation
  224. VBA Macro fails when Excel Not in Foreground
  225. Run-time error 1004
  226. Kill Open Read Only Message on Open
  227. Re: Data entered in several cells before proceeding
  228. Array Sorting problem
  229. Lost horizontal scroll bar
  230. Probelm with Code !!!!!!!!!!!!!!!!!
  231. Browse to select a folder
  232. USE THE "IF" STATEMENT IN EXCEL
  233. VB codes
  234. Pasting Variable cell info into a macro
  235. How to code it in macro?
  236. Dynamic VBA for dynamic Forms
  237. RE: Exporting from Excel to Access DB
  238. Macros Menu in Excel 2007
  239. Runtime error 1004 application-defined or object-defined error
  240. Nested If Function to be converted into a user-defined customfunction
  241. #ref error
  242. Problems with Read Only Workbook
  243. Macro to merge workbooks onto one worksheet
  244. Get Standard CSV File
  245. How to enable "enable automatic update" security setting by VB cod
  246. Replace more characters using replace
  247. Differences between VBA in Excel 2007-2010
  248. cell formula question
  249. Pasting
  250. Converting digits to characters (123 to ABC)
  251. VB code to open other applications from templates
  252. Import Data from SQL server to excel
  253. Extract data from SQL Server table into excel using Listbox Selection as criteria
  254. Populating listbox on the basis of Combo box selection.
  255. Opening Files on other User's Desktops
  256. SEARCH IS NOT WORKING
  257. Resize a password protected page
  258. Re: understanding
  259. How To Clear Drop Down Selection
  260. Help With A Variable And Functions
  261. Summarizing multiple workbooks to other multiple workbooks
  262. How do you programmatically hide/unhide a command button in Excel?
  263. Marksheet
  264. Getting data from a closed wbook
  265. Check row above for information if it has contents copypaste empty
  266. Test variable range for 'Delete'; then delete the row
  267. DTPicker control - Initial date
  268. Find and replace
  269. Type Mismatch Error
  270. button for saving all workbooks
  271. Help revising slow code
  272. Export Only Values
  273. Find and replace
  274. Solver for Inventory Control
  275. Stop Emailing Before Save
  276. Keyboard shortcut too slow
  277. Track and write the number of times that sub is run into a cell
  278. how to query my web site from VBA and return a value to VBA
  279. Opening and Naming Files
  280. Recorded Excel Macro not working
  281. Call a subroutine from ThisWorkBook
  282. Stop my timer
  283. Basic Looping
  284. Simple Problems
  285. Keystroke Speed Cancels Shortcuts
  286. Arrow-keys don't work after deleting OLE-object
  287. Handling the WorkbookAfterSave Event in VBA
  288. Comparing data between files
  289. 32 bit DLL with 64 bit Excel 2010
  290. Page numbering
  291. Cracking VBAProject Password
  292. Select / Copy / Paste
  293. Question - I think not sure. but there are many ways around it - SQL and Excel
  294. Get AutoCorrect Options with VBA
  295. X = SHELL
  296. E#xcel 2007 problem
  297. Calling Macro
  298. Call Paste function with Undo
  299. How to write any registry key
  300. formula needed to extract data from another file
  301. Changes to working code
  302. Insert a custom function in a cell by runnig a sub or through amacro.
  303. Windows update
  304. Re: Save a backup file
  305. Macro to Formula
  306. Call random UserForm from list
  307. Count Unique Combinations
  308. help with formula please
  309. pasting of variable cell value into macro
  310. RE: Select a worksheet based on cell value
  311. Re: drop down fill in
  312. copy a from a cell to another with desired format
  313. Calendar stuff
  314. Select from a list of workbooks that are open
  315. insert cells
  316. .value
  317. if-then functions
  318. Test to see if a workbook is open
  319. Removing or deleting Checkboxes from workbook
  320. Macro to add worksheet
  321. Deleting a Command Bar 14May
  322. Macro to control Print area/view
  323. easiest way to parse column and row info?
  324. Find Text and Insert Row Above
  325. Ignore error
  326. Search and display based on cell value
  327. Error 1004
  328. formula to VBA
  329. Re: OPEN WORKBOOK
  330. Search letters within Words from the List
  331. Loop?
  332. multiple 3D equations in one excel surface chart
  333. Excel 2007 "Protect Sheet" option not available
  334. Controls in protected sheet don't response!!!
  335. Controls in protected sheet don't response!!!
  336. Event Triggered in Wrong Sheet
  337. userform validiation
  338. ThisWorkbook.Name returns a wrong workbook name
  339. ThisWorkbook.Name returns a wrong workbook name
  340. Can I refer to a sheet in another book by its codename?
  341. Upload data on sharepoint automatically.
  342. Re: streaming data into excel
  343. Excel
  344. how to print autocad dwg's from excel vba
  345. Help with this code please !!!!!!!
  346. How to select a workbook?
  347. selection.copy = "picture too large"
  348. Return cursor to proper place
  349. missing Application.FileSearch excel 2007
  350. Negative to zero code
  351. Would like to locate a text box based on a search string and copy
  352. Help to find and replace between sheets
  353. Going through Named Ranges in only specific Sheets in my WorkBook
  354. Get a list of open workbooks and choose one
  355. Converting a “Delete Column” Macro to a “Delete Row” Macro
  356. How do stop a 30 MB Excel file from freezing, while I am working i
  357. Sorting help !!!!!!!!!!!!!!!!!
  358. delete rows
  359. See if cell is in Range
  360. EXCEL
  361. challenging sumifs?
  362. Print all tabs to a pdf file
  363. help with a sub
  364. Combine 2 spreadsheets by parsing from one to the other
  365. LOOKUP function help
  366. Before Cell Exit
  367. Can I call a macro from a specific book
  368. Userform Help Please
  369. MAX Function in VBE
  370. 2 spreadsheets - populating one by multiplys of another
  371. Error of "application-defined or object-defined error" in Goalseek
  372. Run Time Error 1004 in Loop
  373. Altering Paste Data
  374. Merge data by macro
  375. MS Query problem
  376. Copy data into multiple workbooks
  377. can i sort certain entries from a big excel sheet
  378. Can I open a combobox from my code
  379. How to Lock VBProject Programmatically without SendKeys (Note:- Idon't want to Unlock or crack the VBProject. Just want to Lock itProgrammatically)
  380. Find and delete rows
  381. Scrolling Caption
  382. .Seriescolection(n).formula - size limitation?
  383. Copy/Paste problem from another app to Excel
  384. growing excel database
  385. Find Length and Format and Compare
  386. Getting rid of the green triangles in XL 2010
  387. Identify when Excel is displaying ### in a cell? (contents>width)
  388. runtime error code 1004
  389. runtime error code 1004
  390. Using c# object in Excel VBA
  391. Update Directory Path in Code
  392. Run Time Error '1004'
  393. Force increased width of GetOpenFilename dialogue box?
  394. Pull out lastname
  395. Run a macro upon saving
  396. Change Picture
  397. Call List Macro
  398. Issue with expired digital certificate ..
  399. Re: Finding a range and performing a function
  400. Open workbook without running Workbook_Open Event
  401. SumProduct in VBA
  402. treeview control problems
  403. What kind of workbook function should I used?
  404. Custom Function for Pivot Table
  405. Add-in doesn't load properly
  406. macro based on text or number
  407. Renaming tabs
  408. Personal Macro Workbook
  409. How to define the default value?
  410. Macro for adding rows if two different columns have a value
  411. Move columns of data from one worksheet to another in open WB
  412. macro open tabs
  413. closing file
  414. macro to automatically send an excel spreadsheet by email
  415. Count Timer Pause and Stop button
  416. Count Timer Pause and Stop button
  417. Function arguments prompt causing problems
  418. sendkeys
  419. row striping with VBA
  420. Alphabetize Macros in a module
  421. Skip condition if cell is blank
  422. Skip condition if cell is blank
  423. Macro to delete entire row
  424. SendKeys with enter
  425. copying the objects from a sheet
  426. Insert a function through a command button
  427. Startup files open while login.
  428. How to ???
  429. Open files while login, Pls help
  430. Figuring out MAX LEN in a given column
  431. How to map a shortcut key to a routine in COM AddIn for Excel 2007
  432. Sort by one column then another.
  433. How to redistribute microsoft.office.interop.excel?
  434. Data Validation AutoComplete Help
  435. Please help with Custom Views
  436. Concatenate Macro
  437. Hide subsequent rows based on pull down list choice - macro
  438. Print Autocad Files From Excel Vba
  439. Excel 2007: UDF can't reference row below 65536
  440. List Box + Sharepoint Navigation
  441. Case format for getting cell value from a worksheet.
  442. Running code from userform
  443. MsgBox; if 10-seconds, assumed 'No' Clicked
  444. Trying again for an answer.
  445. User selection of charts
  446. Unhide/hide based on drop down list
  447. MACRO TO COUNT ALL OPEN WORKBOOKS and print
  448. Re: Copying a variable nuimber of rows
  449. require cell input before macro can run
  450. Re: Macro puts text if keyword is found in cell above
  451. Re: Macro puts text if keyword is found in cell above
  452. Open Save & Close Macro
  453. AdvancedFilter property?
  454. Looping Macro - Run Time Error
  455. FOR EACH NEXT Multithreaded !
  456. Can not show scrollbars using listview on a userform
  457. Excel, How do I make column A renumber itself if I remove a row?
  458. Subscript Out of Range Error
  459. Display a filtered list in a "rolodex" format
  460. Passing Array to function
  461. Vlookup
  462. if else if...
  463. How to close excel worksheet after 15 mins? once it opened
  464. Comment in every 10 the row
  465. Conditional formating of cells
  466. RE: Copying a variable nuimber of rows
  467. How do I check error result occurring by filecopy function in VBA
  468. Worksheet "slideshow" in Excel
  469. How to turn off standard control functions
  470. Copy range if column N is empty
  471. fraction udf
  472. Copy range based on input
  473. Excel Data Validations
  474. Pivot Table from 2 worksheets
  475. Macro help
  476. Itemize a colum and fill down
  477. data file size increase
  478. Data aggregation with multiple workbooks
  479. Find matches in different spreasheets then copy and paste to new s
  480. Copy Sheet to Desktop
  481. WebBrowser Navigate Path
  482. Custom Menu Bar in Excel 2007
  483. Text to Column and Transpose?
  484. formatting of txt file
  485. xlFillDefault, based on values in ColA to ColZ
  486. Adding/changing registry keys
  487. How to count drawing object (text box) in vba
  488. 2003 toolbars problem
  489. Comparing
  490. Exporting to text file in multiple lines
  491. UserForm Delete Sheet Columns
  492. Control-Home key behaviour
  493. How to copy a workbook
  494. Sending data to a RTD
  495. Can I stop the footer from indenting?
  496. Remove Excel addin completely
  497. Prevent user input, if adjacent cell text is identical
  498. WordMerge
  499. copy row heights
  500. Unable to assign macros to a new button in the current worksheet
  501. Choose which cell to paste data
  502. Getting compile error on WorksheetFuntion.Sum line
  503. find largest column width and ...
  504. extracting data from one workbook to another
  505. Declaring Range
  506. Geometric progression in VBA
  507. Workbook Macro
  508. Private Sub Workbook
  509. How to run a macro if I don't know the name in advance
  510. Adding a decimal place
  511. Display currency as calculated
  512. Re: Array to copy columns
  513. Speciefie table and not cells to sum
  514. Dynamically Create and ID OptionButtons, then insert Row; Loop
  515. VBA troubles
  516. Sendkeys
  517. Can I tellthe difference between 'Save' and 'Save As'?
  518. Set objListObject
  519. How to programme this??
  520. File Attributes Function
  521. Worksheet protection
  522. please help about handling "#NUM!" error !
  523. Search a sheet for a word
  524. Macros on Windows 7
  525. Select first cell in active row?
  526. Organizing a Name in a cell
  527. List words starting with a specific letter
  528. Excel formula needed to round up a value to a whole number
  529. Loop in Excel
  530. Loop in Excel
  531. how to perform function (e.g. Sum, Average) on VB 3-d Array
  532. Delete Columns Macro
  533. Apply formatting through code
  534. Any help with inserting, copying and transferring data.
  535. How to copy ActiveX Controls which are locked on a sheet
  536. Combine two cells without losing data cell formats
  537. Referencing Merged Cells in VBA
  538. Selecting multiple sheets to print to PDF
  539. Checking Cell Value for a Date
  540. Excel 2003: Printing a worksheet and setting properties
  541. VBA for All cells in workbook
  542. Running Excel 12.0 Application on Office 2003
  543. Help with function VBA existing code.
  544. Any way to use "standard" Excel functions inside VBA functions
  545. copy and paste from workbook to workbook
  546. Linking Large Text Database to Excel
  547. Find percentage of sums
  548. Fire event code with Hyperlink and copy/paste RadioButtons
  549. Re: Macro that delets rows if keyword is found
  550. Lost X-axis after resizing charts using VB - not sure why...
  551. Any way to show / hide sheets
  552. To determine the font of a cell and change it if required
  553. XL2003 to XL2000 code converson
  554. Display Math Symbols in UserForm
  555. Worksheet protection prevents Data Validation code from running...
  556. copy and paste data from different sheets
  557. use formula on external data range
  558. how to close Read Only file without prompt to save copy
  559. Windows key and keycode
  560. Code to save Word-document do not work properly
  561. Copy worksheet, trying to paste to new workbook error assistance.
  562. Cell referencing in Macros
  563. how to get DateLastModified name with wildcard
  564. Limit due to selected cells
  565. Run a sub every time a function is used in a sheet
  566. Sub to freeze cols up to extent of data in col Q
  567. shortcut keys
  568. Possible disregard formatting in exception match code?
  569. Linking Large Text Database to Excel
  570. Excel 2003 and Gantt Chart
  571. VBA used to resize objects?
  572. Call Macro
  573. Sum - to end
  574. Non-matching cells
  575. Create employee attendance db using personal.xls?
  576. active window on top
  577. AfterUpdate/BeforeUpdate and SetFocus
  578. Trying to Modify Excel code; Pointing to SQL Server Instead of Acc
  579. remove duplicates
  580. Removing Command Button
  581. Lookup Table
  582. insert a dash
  583. range calculate in vbe
  584. Problems executing commands on one file from another
  585. Create Tab delimited file with no quotes in Currency fields.
  586. MACRO BASED ON A NUMBER OF CHARACTERS
  587. Last Column With Data
  588. With Sheets("wildcard")
  589. transfer data range from criteria in 2 combo boxes
  590. I want to format lines in my footers
  591. Need Help! Need to Change Linked Source on Several Workbooks.
  592. Parsing thru columns to find the last number
  593. Referencing Defined Name in another workbook
  594. using VLOOKUP in a text box
  595. Screen repainting issue
  596. Copy varaible no. of rows to another woorkbook
  597. vbe command for making excel in the active window on top
  598. Locked problem when using .Clear
  599. remove crlf
  600. How to delete numeric characters in a cell with alpha numeric char
  601. Re: Autocomplete doesn't function properly
  602. Re: Autocomplete doesn't function properly
  603. Why is Excel 2003 changing the names of my macros??
  604. Re: Concatenate then Fill Down
  605. Re: Concatenate then Fill Down
  606. Find value in a column and insert rows above
  607. A generic "find" function
  608. Get Column Header Value
  609. When extracting from column A no data
  610. "fixed objects will move" warning
  611. Process all cells in a (user) selection - vba
  612. splitting names from one cell to two cells
  613. pagesetup.printarea cannot getting infos from .xlsx file
  614. Web Query Multiple Variables on a Mac
  615. create a macro with the match lookup_array is changing everyday
  616. Automatically control the font of a cell when a function is used
  617. Problem formatting date as "dd/mm/yyyy"
  618. sumproduct in UDF
  619. Displaying the arguments of UDF in the spertip
  620. Macro to "find" the next empty cell in a range
  621. How to bypass MkDir when that Dir exists already
  622. Run-time error 91 Object variable [2003]
  623. Help with activating window from Application.GetOpenFilename
  624. Worksheet Change Event macro fails intermittently
  625. Arbitrary data to Textboxes in UserForm
  626. Can this be done?
  627. Insert copied cells above hidden Named Range
  628. Re: changing a cell to different colors
  629. Re: changing a cell to different colors
  630. Color change for Column Chart
  631. limit range to unique values
  632. Date question
  633. Problem converting script from Excel 2003 to Ecel 2007
  634. Excel Heiarchy and Highlight rows where certain data lies
  635. custom color for font color and or background shading color
  636. trouble using checkbox26_DblClick
  637. SUMIF criteria
  638. potential bug in copy method
  639. Update Multiple Charts then Print to One PDF File
  640. Using the FIND function in a loop
  641. Z order problems
  642. dsget
  643. Working With Multiple Source and Destination Ranges
  644. identifying text boxes
  645. Select statement or me?
  646. Range References in vba
  647. To attach file to a workbook in a addin.
  648. Cell context menu in XL2007
  649. Drop down-list translation
  650. copy several rows
  651. how can i apply a footer in every .exl file
  652. Save excel sheet as html then save to web useing ftp
  653. Macros
  654. running Excel 2007 macro in Win7
  655. List details in another sheet
  656. Challlenging COUNT IFS?
  657. Amnesty Bill
  658. VB to delete columns except these...
  659. Cannot search forum
  660. Formula that checks balances
  661. Deleting rows
  662. RE: Cannot search forum
  663. finding unique values and removing all duplicates
  664. Unknown object in the Project Explorer in VBE
  665. WEIRD - Excel is Changing the name of my macro
  666. Referencing cell range in another workbook with a formula
  667. Array again limit
  668. Get column of named cell
  669. conditionally formatted list
  670. Re: Chart events
  671. Chart events
  672. copy range
  673. populating neighbouring columns based on drop-down choice
  674. VBA and VB.NET give different results for same RegEx code
  675. Re: How do I access a sub in a New Class
  676. move item in multiselect listbox
  677. Change fill color of cell
  678. Get column name and data type from closed workbook
  679. copy the data to all the columns
  680. Macro executing twice??
  681. Help in VBA code
  682. import Excel worksheet to SQL Server table
  683. When recording
  684. need to sort 2 column "" as a dictionary ""
  685. Help with Regexp, please
  686. Ratio ??.
  687. Freeze the Title in Excel
  688. Two codes in one set.
  689. Column Width
  690. not enough resources
  691. RE: The VBA IDE will discard changes without warning
  692. How to look up each Excel workbook raw in another.
  693. How to close file and hibernate?
  694. Re: Minor puzzle: some UDF calls respect mixed case, others insist onlower case
  695. Splitting a string into columns
  696. Array Limit
  697. refresh linked query
  698. UDF
  699. what besides displayalerts statement
  700. Picture Orientation
  701. Prevent copy and paste in one column
  702. Re: The VBA IDE will discard changes without warning
  703. Which textbox am I in?
  704. Problem Copying Charts to PowerPoint
  705. RE: The VBA IDE will discard changes without warning
  706. Re: The VBA IDE will discard changes without warning
  707. Web Query
  708. Re: Minor puzzle: some UDF calls respect mixed case, others insist on lower case
  709. Re: Error message on opening Excel after deleting add-in file
  710. message "fixed objects will move" HELP!
  711. Shape.OnAction stops working after workbook closed and re-opened
  712. DO Until Loop
  713. Porting a macro to 500 users
  714. RE: Critique a function to convert time, please
  715. Updating a Read Only file
  716. Accessing the Data Connection Strings and Command Text (SQL) in VB
  717. Lookup based on reference
  718. Macro Help
  719. Addin UDF Registration/Declaration
  720. Use UDF In Conditional Formatting
  721. Create CSV
  722. range loop? help
  723. Help with error on PasteSpecial
  724. Textbox Validation
  725. XL2007 (or 2003): Triggering SelectionChange event
  726. How to copy specific number of rows from cells to cells?
  727. Re: Does IsMissing only work with Variants?
  728. Excel VB application
  729. Printer PaperSize returned as a String - How
  730. Re: Macro that searches for keyword and replaces it with ...
  731. Simple code to find the empty cells in a range and cells with number
  732. Limits in SQL query
  733. Drop Down Box
  734. Drop Down box
  735. Search within a single cell for a character
  736. Excel 2007 Macro Security
  737. Copy the contents of a range of cells to a single comment(indicator)?
  738. arrays
  739. array values
  740. Enable Spelling Check
  741. Need VBA for Conditional Format of Row
  742. Apparent Excel 2007 chart HasTitle race condition
  743. Re: Macro that searches for keyword and replaces it with ...
  744. Getting Data Validation to execute when using Paste Special... Val
  745. Checking if some cells are empty when file is being saved
  746. Re: Macro that searches for keyword and replaces it with ...
  747. referring cell in macro function
  748. Is there a way to speed up Calculation !!!!!!!!!!!!!!!
  749. Setting up a macro that can be ran from any excel file.
  750. Count Images in an Excel Sheet