PDA

View Full Version : Excel Programming


Pages : 1 |  2 |  3 |  4 |  5 |  [6] 7 |  8 |  9 |  10 |  11 |  12 |  13 |  14 |  15 |  16 |  17 |  18 |  19 |  20 |  21 |  22 |  23 |  24 |  25 |  26 |  27 |  28 |  29 |  30 |  31 |  32 |  33 |  34 |  35 |  36 |  37 |  38 |  39 |  40 |  41 |  42 |  43 |  44 |  45 |  46 |  47 |  48 |  49 |  50 |  51 |  52 |  53 |  54 |  55 |  56 |  57 |  58 |  59 |  60 |  61 |  62 |  63 |  64 |  65 |  66 |  67 |  68 |  69 |  70 |  71 |  72 |  73 |  74 |  75 |  76 |  77 |  78 |  79 |  80 |  81 |  82 |  83 |  84 |  85 |  86 |  87 |  88 |  89 |  90 |  91 |  92 |  93 |  94 |  95 |  96 |  97 |  98 |  99 |  100 |  101 |  102 |  103 |  104 |  105 |  106 |  107 |  108 |  109 |  110 |  111 |  112 |  113 |  114 |  115 |  116 |  117 |  118 |  119 |  120 |  121 |  122 |  123 |  124 |  125 |  126 |  127 |  128 |  129 |  130 |  131 |  132 |  133 |  134 |  135 |  136 |  137 |  138 |  139 |  140 |  141 |  142 |  143 |  144 |  145 |  146 |  147 |  148 |  149 |  150 |  151 |  152 |  153 |  154 |  155 |  156 |  157 |  158 |  159 |  160 |  161 |  162 |  163 |  164 |  165 |  166 |  167 |  168 |  169 |  170 |  171 |  172 |  173 |  174 |  175 | 

  1. Server Busy message during printing from Excel after Off. 2003 SP2
  2. Data Validation combo box click - 2007
  3. How do i create a macro using copy
  4. How to open a password protected powerpoint file by Excel macro
  5. how to open a password protected powerpoint file by Excel
  6. Macro Record problem
  7. Need help in highlighting the cell color in VBA
  8. filtering two pieces of data
  9. Parsing a String - Call to Ron Rosenfeld
  10. Passing Information to and from Forms
  11. Excel 2007 - VBA Password Input shows after Excel is closed
  12. Looping with more than one condition
  13. HELP: Unable to clear values for control of type text in a userfor
  14. Change color of row (Col A thru Col Q) based on text value in Col J
  15. How To Use External VBA Custom Function In Excel ?
  16. Working in Sheet2 with data from Sheet1
  17. How to change to active sheet on macro?
  18. how to load a file
  19. AUTOMATIC EMAIL
  20. How do I print xls file into two separate columns on the page?
  21. Sort tabs numerically
  22. Sheet codename not working
  23. active control box name on worksheet
  24. Just a test
  25. Vlookup from closed excel file
  26. Equal list values.
  27. VBA Conditional Formatting
  28. XL 2010: Parent of a Range can be a Shape?
  29. Addressing HTMLText object in Spreadsheet VBA Script
  30. The last day
  31. simple reszie
  32. simple resize
  33. Delete all rows where there is no entry in Column 'C'
  34. Alterations/corrections on userform
  35. How to create a function in a code sheet
  36. Evaluate problem
  37. Formatting previous selection
  38. Problem with existing workbook with macros
  39. Problem with - sign in sheet name??
  40. Replacing spaces with underscore for specific expressions
  41. Change Times
  42. Parsing (again)
  43. Coloring Alternate lines
  44. Help - Need a Macro/Popup to Find a Date in a Sheet.
  45. How to open & copy paste a word document in excel using macros?
  46. How to Show/Hide Columns or Rows with no data via VB
  47. Change Color for Drawing Line Object
  48. Day of Week from dd/mm/yyyy
  49. delete file in addin directory
  50. Case Studies
  51. Running macros when multiple Excels are open
  52. SOLVER Reset command does not work in 2007Excel why???? Two Questi
  53. Swap Two Values in one Command
  54. dim
  55. Menus & Hot keys - works in Excel 2003 but not 2007
  56. Move data between ListBoxes
  57. Stopping a timer
  58. Web pop up
  59. Auto_Open over Private Sub Workbook_Open()
  60. Macro Help - Updating Master List
  61. Problem with the "Or" operand in Excel
  62. Problem with offsetting one row down
  63. How can this crash Excel?
  64. restrict a product eg 10*5=40 because 40 is maximum
  65. Need List of Embedded Files
  66. Input box to find date
  67. Method 'OnTime' of object'_Application failed
  68. Protection Problems
  69. Using a modeless form to show status
  70. Make (save) a file by using macro recorder.
  71. Need VBA Code to Select text boxes in spreadsheet
  72. Best way to copy and paste row of controls on userform
  73. Save as PDF not working on a domained Windows 7/Vista box
  74. export data between spreadsheets
  75. Need VB code to edit cell values
  76. Need Help Remove Duplicate Values In Array ?
  77. Refer a column in the 'sumif' function
  78. Help again!!!
  79. Thanks Everyone
  80. Lookup Cell Interior
  81. How do I stop my conttrols from resizing
  82. Indirectly referring to a variable
  83. Print sheets based on cell value
  84. Worksheet_Change?
  85. Automation of Excel Report using Access Data
  86. Error 1004 - Application or Object Defined Error
  87. NumberFormat not getting changing onFly changing the regional sett
  88. Alternate Column Shading to be applied only to visible columns
  89. VB converting UK to US dates, randomly, ignores cdate func!
  90. Find "invisible" conditional formatting
  91. Grouping
  92. VBA - how do I pass info from dropdown list to a string??
  93. Export Table Records to txt file
  94. referencing controls in userform from a different workbook
  95. Help with IIF statement in macro
  96. Macro for hiding all rows accept those selected by a dated column?
  97. Default Ribbon on File Open
  98. Exporting charts outside excel
  99. Code corrupts file (XL2003)
  100. Array - retrieve certain amount of recods for query
  101. How To Assigned "SelectionChange" Event To different Worksheets
  102. How can I use a IF Array combination to return values?
  103. Identify excel file on taskbar
  104. Odd VLOOKUP Error
  105. Macro to merge cells of the same colour/pattern index
  106. how do i allow fields to be either input or output in excel?
  107. autofit with wrap
  108. VBA problem.
  109. XL file opened using automation - how close?
  110. In a cell find words, copy and paste in another cell
  111. Find word copy and paste
  112. RE: How To Assigned "SelectionChange" Event To different Worksheets
  113. close excel; leave access open
  114. Automatically OPENing (GetObject) and Closing EXCEL via VB calls
  115. Help with VB code
  116. Showing Excel Cell Data in PDF Document
  117. Remove spaces
  118. RE: Array - retrieve certain amount of recods for query
  119. String search on two tables
  120. not in array
  121. Conditional Formatting v VBE code for desired effect
  122. Resize commentbox in VB
  123. "Do you want to update" msg
  124. Macro to delete rows
  125. RE: Code corrupts file (XL2003)
  126. MODI printing and combining files
  127. Protected project visible
  128. Using excel to Determine if a File Exists in SharePoint
  129. How to move worksheet into specific position?
  130. RE: Automatically OPENing (GetObject) and Closing EXCEL via VB calls
  131. RE: not in array
  132. RE: Odd VLOOKUP Error
  133. Pass Parameter from Excel to SharePoint
  134. testing for password protection
  135. RE: Remove spaces
  136. RE: "Do you want to update" msg
  137. RE: XL file opened using automation - how close?
  138. RE: Pass Parameter from Excel to SharePoint
  139. RE: testing for password protection
  140. Formula for Data Validation
  141. Send a worksheet to an open email
  142. RE: Macro to merge cells of the same colour/pattern index
  143. RE: Resize commentbox in VB
  144. Converting a HEX string
  145. Can you calculate delta time using different entries
  146. Remove add-in
  147. RE: XL file opened using automation - how close?
  148. Print Preview slows my code?
  149. RE: Macro to merge cells of the same colour/pattern index
  150. RE: Pass Parameter from Excel to SharePoint
  151. How To Remove VBA Code For Distribution of an Excel Sheet
  152. starting a function will not allow comm_button
  153. RE: Remove spaces
  154. Show / Hide items in Pivot Table as required
  155. RE: Macro to delete rows
  156. RE: not in array
  157. automatically number a table in word document
  158. RE: XL file opened using automation - how close?
  159. RE: Odd VLOOKUP Error
  160. RE: Removing or deleting Checkboxes from workbook
  161. RE: Macro to delete rows
  162. Have VB Code "on" for all workbooks
  163. code to delete vba code
  164. Can we set the UI color scheme via VB[A} or XML?
  165. Change checkbox value
  166. Conditional Formatting with Hyperlinks
  167. RE: Remove spaces
  168. Rotate application
  169. RE: Can you calculate delta time using different entries
  170. Calendar Control
  171. Linking data with variable cell location
  172. using the cells property for use with Application.WorksheetFunction.Sum
  173. How to access macros via tool buttons?
  174. Sorting stuff into alphabetical order
  175. can I use code to make code in another book
  176. VBA to insert .xlborder if cell value not equal to previous cell
  177. Optical Character Recoginition
  178. To show a message box if the mouse is over a particular cell??
  179. Fix Broken Cell Formula with VBA
  180. Cosmetics
  181. Reading system log files
  182. Icon in Notification area
  183. Icon in Notification zone
  184. Next weekday ...
  185. Next without For Error
  186. Copying worksheet from hidden instance of Excel
  187. Delete Columns if sum is 0
  188. Conditional formatting if condition of an if statement is true and astring value is displayed
  189. Looping Open and Save as CSV
  190. Calendar Control 12.0 help
  191. Reading properties from closed book
  192. Addins attached only to selected workbook(s)??
  193. Still need help with a code reference problem - Excel 2002 XP
  194. Timer question
  195. date handling problem with International issues
  196. Advanced compare of two worksheets
  197. Calling a sub on another worksheet
  198. Programmable Column Sequencing?
  199. Userform ComboBox Row Source
  200. Excel 2007 sorting ribbon is not working with .Net save code
  201. Problem With Code...Still
  202. Text Formats
  203. AutoFilter macro
  204. Macro for merging rows
  205. Code "crashes" after dynamically adding control to worksheet
  206. sumif help
  207. Email From spreadsheet
  208. Hand Icon when sheet protected problem ?
  209. VLOOKUP VALUE ERROR
  210. Printing sheets based on a cell value
  211. Autofilter macro
  212. MultiWorkbook Change Event Detection / Spell Checker
  213. Automatically Copy Information when data is entered
  214. VBA Dynamic range in Pivot table
  215. Open Excel file from SharePoint; opens as ReadOnly
  216. For statement behaving very strangely
  217. Newsgroups going bye-bye
  218. Non existent code reference problem
  219. SendTo
  220. EXCEL 2007 - export to dbf files
  221. Exporting to .txt converts single quotes to double quotes
  222. P.S.
  223. File not saving
  224. Autocompletion For UDFs?
  225. Autocompletion For UDFs?
  226. New functions needed
  227. Comparing Apples and Oranges
  228. GetOpenFilename code execution interrupted
  229. Copy data in table to column in worksheet
  230. Create a list with multiple criteria
  231. Parsing a string
  232. Register HelpID via Categories dll
  233. Using Color as Criteria in Countif Function
  234. Finding the end of Data
  235. Protection
  236. Answer Message Box - Other than Y/N?
  237. Running another program
  238. Controls in a frame within a frame are always invisible - What am I doing wrong
  239. Pivot Table Macro Run-time error
  240. Button to add Rows on Form in Excel
  241. Protection Tutorial
  242. Macro to rename Tab and then save as
  243. View what macro is assigned to a tool bar button
  244. Fire a macro
  245. please help.. highly important...
  246. Excel wait for Find Replace dialog box in Word
  247. Using Trim in a Userform
  248. Date programing in a cell
  249. Creating a formula which references a dynamic cell location
  250. Sort Order Doesn't Seem Correct
  251. Drill down pivot table data via VBA macro
  252. Latency on the move - without tripping down the stairs!
  253. Save in different folder
  254. Help with forcing chart axes scale
  255. How to code it in macro?
  256. Blinking Text
  257. BKF files
  258. autofilter master copy data to worksheet
  259. Coding for inventory
  260. creating a pivot with external data source (from access)
  261. pivot table with external data
  262. "000" reverts back to "0" even with a string
  263. Entry data sheet automaticlly updates or adds data to differant sh
  264. Re: Maintaining Text Box Font Setting (Excel) using VB
  265. One line is killing my program!
  266. Testing/Finding .Hidden for Rows May21
  267. watermark
  268. Check out Excel file from SharePoint; if no other Excel file is op
  269. Maintaining Text Box Font Setting through VB
  270. Problems with ACE OLEDB provider
  271. ounces vs. pounds
  272. Using Select Case on Single column only
  273. I need VBA Help for Excel spreadsheet -- Please!
  274. General Question on one line of code - parentheses and quotation marks
  275. RowSource property in cbox
  276. Open Add-In (.xla) workbook as Read Only automatically
  277. Change Gradient Fill Colors of Bar Chart data points
  278. delete single occurances in a string
  279. xlPasteValues is also pasting Formats
  280. Open & update another file (through macro) while running macro
  281. Conditional Formatting
  282. get Control of a Butoon placed in the Sheet
  283. How to prevent a graph update
  284. Redefining a table range with a macro
  285. value of value of a variable.
  286. Get control of a Userform by the Name
  287. Command Button to import worksheets
  288. Getting data from a closed wbook (adaptation of rondebruin's)
  289. Identifying other users
  290. Help changing Keyboard Shortcut assigned to Excel Macro
  291. how to disable update links message when opening files
  292. Macro to add / delete column
  293. Public Variable problem
  294. Save BeforeClose
  295. Check numeric char
  296. Prevent Save/Publish
  297. String Search
  298. Disabling Built-in items on a menu
  299. visual basic excel 2000
  300. Application.VLookup and External files
  301. Capture Date from External Sharepoint Portal
  302. SaveAs *.txt - Outputting with Text quantifiers
  303. Count Workbooks that are open; Prevent another from opening
  304. launch instance of excel without loading personal.xls
  305. Disable Save
  306. Running formulas with data from mulitple workbooks
  307. DTPicker controls missing from userform
  308. Columns("C:C").Value = Columns("D:D").Value not working after adding16th page
  309. Setting a reference to the Ribbon
  310. Unlink chart from sheet
  311. Option Group actions
  312. Calling Excel shortcuts from VBA
  313. Calling Excel shortcuts from VBA
  314. Autocomplete Custom Functions and functions arguments
  315. Export Several Worksheet Groups (Values Only) Macro
  316. Fails to delete empty rows
  317. Code not working as expected
  318. retrun an RGB value to a specified cell
  319. Can I put something in the footer that reads from the sheet
  320. Cell colour format according to date
  321. Application.Visible=False
  322. "Update" calendar on userform?
  323. Send data to serial port
  324. No Subject
  325. Modify sub to work on cells with formulas
  326. Number of lines in the Immediate Window
  327. Set object with a function
  328. Open_Files_In_A_Directory
  329. To Simon :- Adware problems
  330. match two conditions to return value from pivot table
  331. Macro to sort, format, sum, a dynamic set of data
  332. VBA to check omissions and show/hide form
  333. Save as cell reference then email
  334. VBA Workbook Open Function
  335. Not sure what to call this
  336. Re: Deleting a Command Bar 14May
  337. How to display a macro generated menu in Excel 2007
  338. How to update .xlam file (add-in) while it is in use?
  339. use Excel Now() in VBA
  340. Option group controlling objects
  341. Sheet change event to return sheet name just left
  342. Insert Page Break After Partial Text Match
  343. Excel ODBC driver created table/inserted data lost on application
  344. Re: Track and write the number of times that sub is run into a cel
  345. File folder info. in Excel workbook?
  346. Custom validation rule - must be 15 increment of time
  347. What does Compile VBAProject do
  348. Autofit row height in only some rows
  349. Conditionally count unique values
  350. Bug Report: VBA runtime Access Violation
  351. VBA in IE window
  352. Re: formula needed to extract data from another file
  353. retrieve data into a spreadsheet from a copy of that spreadsheetwhich is saved as its own xls file
  354. Convert number to letter 123 to ABC
  355. Search Option
  356. Application.OnTime - Macro Cannot Be Found - Internet Explorer
  357. UserForm_Terminate problem
  358. loop through all worksheets
  359. stop VBA in solver when maximum iterations reached
  360. save(append) to an excel file
  361. Change Pivot Table Page Value
  362. Tracking an email when sent directly from Excel
  363. Creating a common starting point
  364. .PutInClipboard
  365. Help with VBA and SUM
  366. If no activity, display a UserForm; 10 seconds later close Workboo
  367. UserForm1.ComboBox1 to initialize
  368. Copying a sheet fails
  369. XL 2007: How to find out what keyboard shortcuts I've assigned tomacros?
  370. Special character in Input Message - Data Validation
  371. Run-time error 1004
  372. Kill Open Read Only Message on Open
  373. Array Sorting problem
  374. Re: Handling the WorkbookAfterSave Event in VBA
  375. Data entered in several cells before proceeding
  376. Lost horizontal scroll bar
  377. Probelm with Code !!!!!!!!!!!!!!!!!
  378. Browse to select a folder
  379. USE THE "IF" STATEMENT IN EXCEL
  380. VB codes
  381. Pasting Variable cell info into a macro
  382. How to code it in macro?
  383. Dynamic VBA for dynamic Forms
  384. Macros Menu in Excel 2007
  385. Runtime error 1004 application-defined or object-defined error
  386. RE: X = SHELL
  387. Nested If Function to be converted into a user-defined customfunction
  388. #ref error
  389. Problems with Read Only Workbook
  390. Macro to merge workbooks onto one worksheet
  391. Get Standard CSV File
  392. How to enable "enable automatic update" security setting by VB cod
  393. Replace more characters using replace
  394. Differences between VBA in Excel 2007-2010
  395. cell formula question
  396. Pasting
  397. Converting digits to characters (123 to ABC)
  398. VB code to open other applications from templates
  399. Opening Files on other User's Desktops
  400. SEARCH IS NOT WORKING
  401. Re: Opening and Naming Files
  402. Re: 32 bit DLL with 64 bit Excel 2010
  403. Re: 32 bit DLL with 64 bit Excel 2010
  404. Resize a password protected page
  405. Re: Handling the WorkbookAfterSave Event in VBA
  406. Exporting from Excel to Access DB
  407. How To Clear Drop Down Selection
  408. Help With A Variable And Functions
  409. understanding
  410. Summarizing multiple workbooks to other multiple workbooks
  411. How do you programmatically hide/unhide a command button in Excel?
  412. Marksheet
  413. Re: Save a backup file
  414. Getting data from a closed wbook
  415. Check row above for information if it has contents copypaste empty
  416. Test variable range for 'Delete'; then delete the row
  417. DTPicker control - Initial date
  418. Re: Basic Looping
  419. Re: Stop my timer
  420. Find and replace
  421. Type Mismatch Error
  422. button for saving all workbooks
  423. Help revising slow code
  424. Export Only Values
  425. Find and replace
  426. Solver for Inventory Control
  427. Re: drop down fill in
  428. Re: Opening and Naming Files
  429. Re: Call a subroutine from ThisWorkBook
  430. multiple 3D equations in one excel surface chart
  431. Excel 2007 "Protect Sheet" option not available
  432. OPEN WORKBOOK
  433. Controls in protected sheet don't response!!!
  434. Controls in protected sheet don't response!!!
  435. Event Triggered in Wrong Sheet
  436. userform validiation
  437. ThisWorkbook.Name returns a wrong workbook name
  438. ThisWorkbook.Name returns a wrong workbook name
  439. Can I refer to a sheet in another book by its codename?
  440. Upload data on sharepoint automatically.
  441. Excel
  442. streaming data into excel
  443. how to print autocad dwg's from excel vba
  444. Help with this code please !!!!!!!
  445. How to select a workbook?
  446. selection.copy = "picture too large"
  447. Return cursor to proper place
  448. missing Application.FileSearch excel 2007
  449. Negative to zero code
  450. Would like to locate a text box based on a search string and copy
  451. Help to find and replace between sheets
  452. Going through Named Ranges in only specific Sheets in my WorkBook
  453. Get a list of open workbooks and choose one
  454. Converting a “Delete Column” Macro to a “Delete Row” Macro
  455. How do stop a 30 MB Excel file from freezing, while I am working i
  456. Sorting help !!!!!!!!!!!!!!!!!
  457. delete rows
  458. See if cell is in Range
  459. EXCEL
  460. challenging sumifs?
  461. validating dates on a userform
  462. Print all tabs to a pdf file
  463. help with a sub
  464. Combine 2 spreadsheets by parsing from one to the other
  465. LOOKUP function help
  466. Before Cell Exit
  467. Can I call a macro from a specific book
  468. Userform Help Please
  469. MAX Function in VBE
  470. Error of "application-defined or object-defined error" in Goalseek
  471. Run Time Error 1004 in Loop
  472. Altering Paste Data
  473. Merge data by macro
  474. how do i make excel pick words i start typing
  475. MS Query problem
  476. Copy data into multiple workbooks
  477. can i sort certain entries from a big excel sheet
  478. Can I open a combobox from my code
  479. How to Lock VBProject Programmatically without SendKeys (Note:- Idon't want to Unlock or crack the VBProject. Just want to Lock itProgrammatically)
  480. Find and delete rows
  481. Scrolling Caption
  482. .Seriescolection(n).formula - size limitation?
  483. Copy/Paste problem from another app to Excel
  484. growing excel database
  485. Find Length and Format and Compare
  486. Getting rid of the green triangles in XL 2010
  487. Identify when Excel is displaying ### in a cell? (contents>width)
  488. runtime error code 1004
  489. runtime error code 1004
  490. Using c# object in Excel VBA
  491. Update Directory Path in Code
  492. Run Time Error '1004'
  493. Force increased width of GetOpenFilename dialogue box?
  494. A macro to authorize a user to run another macro.
  495. Pull out lastname
  496. Run a macro upon saving
  497. Change Picture
  498. Call List Macro
  499. Issue with expired digital certificate ..
  500. Open workbook without running Workbook_Open Event
  501. Finding a range and performing a function
  502. SumProduct in VBA
  503. treeview control problems
  504. What kind of workbook function should I used?
  505. Custom Function for Pivot Table
  506. Add-in doesn't load properly
  507. macro based on text or number
  508. Renaming tabs
  509. Personal Macro Workbook
  510. How to define the default value?
  511. Macro for adding rows if two different columns have a value
  512. Move columns of data from one worksheet to another in open WB
  513. macro open tabs
  514. closing file
  515. macro to automatically send an excel spreadsheet by email
  516. Count Timer Pause and Stop button
  517. Count Timer Pause and Stop button
  518. sendkeys
  519. row striping with VBA
  520. Alphabetize Macros in a module
  521. Skip condition if cell is blank
  522. Skip condition if cell is blank
  523. Macro to delete entire row
  524. SendKeys with enter
  525. copying the objects from a sheet
  526. Insert a function through a command button
  527. Startup files open while login.
  528. How to ???
  529. Open files while login, Pls help
  530. Figuring out MAX LEN in a given column
  531. How to map a shortcut key to a routine in COM AddIn for Excel 2007
  532. Sort by one column then another.
  533. How to redistribute microsoft.office.interop.excel?
  534. Data Validation AutoComplete Help
  535. Please help with Custom Views
  536. Concatenate Macro
  537. Hide subsequent rows based on pull down list choice - macro
  538. Excel 2007: UDF can't reference row below 65536
  539. List Box + Sharepoint Navigation
  540. Case format for getting cell value from a worksheet.
  541. Running code from userform
  542. MsgBox; if 10-seconds, assumed 'No' Clicked
  543. Trying again for an answer.
  544. User selection of charts
  545. Unhide/hide based on drop down list
  546. MACRO TO COUNT ALL OPEN WORKBOOKS and print
  547. require cell input before macro can run
  548. Macro puts text if keyword is found in cell above
  549. Open Save & Close Macro
  550. AdvancedFilter property?
  551. Looping Macro - Run Time Error
  552. FOR EACH NEXT Multithreaded !
  553. Can not show scrollbars using listview on a userform
  554. Excel, How do I make column A renumber itself if I remove a row?
  555. Subscript Out of Range Error
  556. Display a filtered list in a "rolodex" format
  557. Passing Array to function
  558. Vlookup
  559. if else if...
  560. How to close excel worksheet after 15 mins? once it opened
  561. Comment in every 10 the row
  562. Conditional formating of cells
  563. Copying a variable nuimber of rows
  564. How do I check error result occurring by filecopy function in VBA
  565. Worksheet "slideshow" in Excel
  566. How to turn off standard control functions
  567. Copy range if column N is empty
  568. fraction udf
  569. Copy range based on input
  570. RE: Workbook sizing
  571. Excel Data Validations
  572. Pivot Table from 2 worksheets
  573. Macro help
  574. Itemize a colum and fill down
  575. data file size increase
  576. Data aggregation with multiple workbooks
  577. Find matches in different spreasheets then copy and paste to new s
  578. Copy Sheet to Desktop
  579. WebBrowser Navigate Path
  580. Custom Menu Bar in Excel 2007
  581. Text to Column and Transpose?
  582. formatting of txt file
  583. xlFillDefault, based on values in ColA to ColZ
  584. Adding/changing registry keys
  585. How to count drawing object (text box) in vba
  586. 2003 toolbars problem
  587. Comparing
  588. Exporting to text file in multiple lines
  589. UserForm Delete Sheet Columns
  590. Control-Home key behaviour
  591. How to copy a workbook
  592. Can I stop the footer from indenting?
  593. Remove Excel addin completely
  594. Prevent user input, if adjacent cell text is identical
  595. WordMerge
  596. BUY PORTUGUESE FAKE PASSPORT/GREEK FALSE PASSPORTS,ID CARD SALE/MALAYSIAN FAKE PASSPORTS SALE ONLINE
  597. copy row heights
  598. Unable to assign macros to a new button in the current worksheet
  599. Choose which cell to paste data
  600. Getting compile error on WorksheetFuntion.Sum line
  601. find largest column width and ...
  602. extracting data from one workbook to another
  603. Declaring Range
  604. Workbook Macro
  605. Private Sub Workbook
  606. How to run a macro if I don't know the name in advance
  607. Adding a decimal place
  608. Display currency as calculated
  609. Speciefie table and not cells to sum
  610. Dynamically Create and ID OptionButtons, then insert Row; Loop
  611. VBA troubles
  612. Array to copy columns
  613. Sendkeys
  614. Can I tellthe difference between 'Save' and 'Save As'?
  615. Set objListObject
  616. How to programme this??
  617. File Attributes Function
  618. Worksheet protection
  619. please help about handling "#NUM!" error !
  620. Search a sheet for a word
  621. Macros on Windows 7
  622. Select first cell in active row?
  623. List words starting with a specific letter
  624. Excel formula needed to round up a value to a whole number
  625. Loop in Excel
  626. Loop in Excel
  627. how to perform function (e.g. Sum, Average) on VB 3-d Array
  628. Delete Columns Macro
  629. Apply formatting through code
  630. Any help with inserting, copying and transferring data.
  631. How to copy ActiveX Controls which are locked on a sheet
  632. Combine two cells without losing data cell formats
  633. Referencing Merged Cells in VBA
  634. Selecting multiple sheets to print to PDF
  635. Checking Cell Value for a Date
  636. Excel 2003: Printing a worksheet and setting properties
  637. VBA for All cells in workbook
  638. Running Excel 12.0 Application on Office 2003
  639. Help with function VBA existing code.
  640. Any way to use "standard" Excel functions inside VBA functions
  641. copy and paste from workbook to workbook
  642. Linking Large Text Database to Excel
  643. Find percentage of sums
  644. Fire event code with Hyperlink and copy/paste RadioButtons
  645. Lost X-axis after resizing charts using VB - not sure why...
  646. Any way to show / hide sheets
  647. To determine the font of a cell and change it if required
  648. XL2003 to XL2000 code converson
  649. Macro that delets rows if keyword is found
  650. Display Math Symbols in UserForm
  651. Worksheet protection prevents Data Validation code from running...
  652. copy and paste data from different sheets
  653. use formula on external data range
  654. how to close Read Only file without prompt to save copy
  655. Windows key and keycode
  656. Code to save Word-document do not work properly
  657. Copy worksheet, trying to paste to new workbook error assistance.
  658. Re: Microsoft Responds to the Evolution of Online Communities
  659. Cell referencing in Macros
  660. how to get DateLastModified name with wildcard
  661. Limit due to selected cells
  662. Run a sub every time a function is used in a sheet
  663. Sub to freeze cols up to extent of data in col Q
  664. shortcut keys
  665. Possible disregard formatting in exception match code?
  666. Linking Large Text Database to Excel
  667. Excel 2003 and Gantt Chart
  668. VBA used to resize objects?
  669. Call Macro
  670. Sum - to end
  671. Non-matching cells
  672. Create employee attendance db using personal.xls?
  673. active window on top
  674. AfterUpdate/BeforeUpdate and SetFocus
  675. Trying to Modify Excel code; Pointing to SQL Server Instead of Acc
  676. remove duplicates
  677. Removing Command Button
  678. Lookup Table
  679. ScreenUpdating
  680. insert a dash
  681. range calculate in vbe
  682. Problems executing commands on one file from another
  683. Create Tab delimited file with no quotes in Currency fields.
  684. MACRO BASED ON A NUMBER OF CHARACTERS
  685. Last Column With Data
  686. With Sheets("wildcard")
  687. transfer data range from criteria in 2 combo boxes
  688. I want to format lines in my footers
  689. Need Help! Need to Change Linked Source on Several Workbooks.
  690. Parsing thru columns to find the last number
  691. Referencing Defined Name in another workbook
  692. using VLOOKUP in a text box
  693. Screen repainting issue
  694. Copy varaible no. of rows to another woorkbook
  695. vbe command for making excel in the active window on top
  696. Locked problem when using .Clear
  697. remove crlf
  698. How to delete numeric characters in a cell with alpha numeric char
  699. Why is Excel 2003 changing the names of my macros??
  700. Find value in a column and insert rows above
  701. A generic "find" function
  702. Get Column Header Value
  703. Updating another workbook
  704. When extracting from column A no data
  705. "fixed objects will move" warning
  706. Autocomplete doesn't function properly
  707. Process all cells in a (user) selection - vba
  708. splitting names from one cell to two cells
  709. Re: Microsoft Responds to the Evolution of Online Communities
  710. Concatenate then Fill Down
  711. pagesetup.printarea cannot getting infos from .xlsx file
  712. Web Query Multiple Variables on a Mac
  713. create a macro with the match lookup_array is changing everyday
  714. Automatically control the font of a cell when a function is used
  715. Re: Microsoft Responds to the Evolution of Online Communities
  716. Problem formatting date as "dd/mm/yyyy"
  717. sumproduct in UDF
  718. Displaying the arguments of UDF in the spertip
  719. Macro to "find" the next empty cell in a range
  720. How to bypass MkDir when that Dir exists already
  721. Re: Microsoft Responds to the Evolution of Online Communities
  722. Run-time error 91 Object variable [2003]
  723. Help with activating window from Application.GetOpenFilename
  724. Worksheet Change Event macro fails intermittently
  725. Arbitrary data to Textboxes in UserForm
  726. Can this be done?
  727. Insert copied cells above hidden Named Range
  728. changing a cell to different colors
  729. Color change for Column Chart
  730. limit range to unique values
  731. Date question
  732. Problem converting script from Excel 2003 to Ecel 2007
  733. Excel Heiarchy and Highlight rows where certain data lies
  734. custom color for font color and or background shading color
  735. trouble using checkbox26_DblClick
  736. SUMIF criteria
  737. potential bug in copy method
  738. Update Multiple Charts then Print to One PDF File
  739. Using the FIND function in a loop
  740. Z order problems
  741. dsget
  742. Working With Multiple Source and Destination Ranges
  743. identifying text boxes
  744. Select statement or me?
  745. Range References in vba
  746. To attach file to a workbook in a addin.
  747. Cell context menu in XL2007
  748. Drop down-list translation
  749. copy several rows
  750. how can i apply a footer in every .exl file
  751. Save excel sheet as html then save to web useing ftp
  752. Macros
  753. running Excel 2007 macro in Win7
  754. List details in another sheet
  755. Challlenging COUNT IFS?
  756. Amnesty Bill
  757. VB to delete columns except these...
  758. Cannot search forum
  759. Formula that checks balances
  760. Deleting rows
  761. RE: Cannot search forum
  762. finding unique values and removing all duplicates
  763. Unknown object in the Project Explorer in VBE
  764. WEIRD - Excel is Changing the name of my macro
  765. Referencing cell range in another workbook with a formula
  766. Array again limit
  767. Get column of named cell
  768. conditionally formatted list
  769. Chart events
  770. copy range
  771. populating neighbouring columns based on drop-down choice
  772. How do I access a sub in a New Class
  773. move item in multiselect listbox
  774. Change fill color of cell
  775. Get column name and data type from closed workbook
  776. copy the data to all the columns
  777. Macro executing twice??
  778. Help in VBA code
  779. import Excel worksheet to SQL Server table
  780. When recording
  781. need to sort 2 column "" as a dictionary ""
  782. Help with Regexp, please
  783. Ratio ??.
  784. Freeze the Title in Excel
  785. Two codes in one set.
  786. Column Width
  787. not enough resources
  788. How to look up each Excel workbook raw in another.
  789. How to close file and hibernate?
  790. Splitting a string into columns
  791. Array Limit
  792. refresh linked query
  793. UDF
  794. what besides displayalerts statement
  795. Picture Orientation
  796. Prevent copy and paste in one column
  797. Which textbox am I in?
  798. Problem Copying Charts to PowerPoint
  799. Web Query
  800. The VBA IDE will discard changes without warning
  801. Minor puzzle: some UDF calls respect mixed case, others insist on lower case
  802. Error message on opening Excel after deleting add-in file
  803. message "fixed objects will move" HELP!
  804. Shape.OnAction stops working after workbook closed and re-opened
  805. DO Until Loop
  806. Porting a macro to 500 users
  807. Accessing the Data Connection Strings and Command Text (SQL) in VB
  808. Lookup based on reference
  809. Macro Help
  810. Addin UDF Registration/Declaration
  811. Use UDF In Conditional Formatting
  812. Create CSV
  813. range loop? help
  814. Help with error on PasteSpecial
  815. Textbox Validation
  816. XL2007 (or 2003): Triggering SelectionChange event
  817. How to copy specific number of rows from cells to cells?
  818. Does IsMissing only work with Variants?
  819. Excel VB application
  820. Printer PaperSize returned as a String - How
  821. Simple code to find the empty cells in a range and cells with number
  822. Limits in SQL query
  823. Drop Down Box
  824. Drop Down box
  825. Search within a single cell for a character
  826. Critique a function to convert time, please
  827. Excel 2007 Macro Security
  828. Copy the contents of a range of cells to a single comment(indicator)?
  829. arrays
  830. array values
  831. Enable Spelling Check
  832. Need VBA for Conditional Format of Row
  833. Apparent Excel 2007 chart HasTitle race condition
  834. Getting Data Validation to execute when using Paste Special... Val
  835. Checking if some cells are empty when file is being saved
  836. referring cell in macro function
  837. Is there a way to speed up Calculation !!!!!!!!!!!!!!!
  838. Setting up a macro that can be ran from any excel file.
  839. Count Images in an Excel Sheet
  840. vba project password
  841. Moving Macros to the Application Level
  842. Macro that searches for keyword and replaces it with ...
  843. Can I display an open file dialog from a macro
  844. Validating that named ranges exist
  845. Can you speed up this code?
  846. Passing a variable from sheet code to a module
  847. Help with code please
  848. Column Array
  849. Stop text to date conversion
  850. Hiding graphics elements?
  851. format a specific letter by code
  852. Converting strings to numbers
  853. Copy to Named Range
  854. Copy filtered data (Values only)
  855. Insert Shape Based on Cell Changes
  856. Sort bug on Excel 2007
  857. Click Excel custom menu item via MFC automation
  858. find a non-empty cell
  859. Check to see if subtotal is expanded
  860. Problem with file links changing
  861. copy multiple rows
  862. Array problem? List comparison?
  863. Compare two lists and get differences
  864. Case Method & Range Object Problem
  865. Tweak to display autoshape
  866. Insert character using Regex
  867. How do I create a hyperlink with a macro?
  868. Pop up message asks if I really want to edit the live office data
  869. Sort Worksheets Numerically
  870. names in file name
  871. Who is in a network shared Excel file
  872. Using iserror with greater than
  873. Check for other open wokbooks
  874. complex formula
  875. Excel Export to Access via VBA
  876. Excel Export to Access via VBA
  877. Sorting question sort of
  878. Copy a Sheet to an AddIn
  879. Help with sorting data
  880. Textbox (Object) Right Click Menu - Disable Cut
  881. Pointing specific textbox
  882. Count the Colorindex of a cell with a conditional format
  883. Help with SORT property in xl2007 and xl2007 !!!!!!!!!!!!!!!!!!!!
  884. SUMPRODUCT is not working
  885. Using vba find
  886. VBA to open a PDF, print, then close - Stumped
  887. A macro for converting formulas to formula results only
  888. Macro to save a workbook
  889. Insert character in a cell using a keyboard shortcut
  890. Checkbox values
  891. Hide Columns Based On Date Value
  892. Color Definition
  893. auto copy and paste to another workbook by using specific titles
  894. force recalculation of function
  895. quicker cell concatenation
  896. Find date in row and move to cell
  897. Detect macro in excel file without opening it
  898. Save as vba excel
  899. Evaluate VLOOKUP in cells in column
  900. Selecting a cell according to the cell value
  901. NetDDE
  902. HOW: Click Formula Hyperlink To Trigger Macro
  903. Go to Date on multiple sheets?
  904. moved macros to new book now they don't work
  905. modify formula
  906. modify formula
  907. Autofit
  908. Calling one UDF from another in a different module
  909. How to find all UDF calls in all workbooks
  910. Establish if Offset RANGE contains text
  911. Application.ScreenUpdating = False doesn't work
  912. declaration help please
  913. Insert an autofiltered range into another tab
  914. hours / minutes
  915. hours / minutes
  916. programming 33 tabs with 1 chart on each, 9 series lines per chart
  917. automatic replacing of a VBE sub in all open workbooks
  918. Insert Formula based in cell user clicks
  919. Copy problem between worksheets
  920. Turn a range of cells into 'read only'
  921. Ignore Blank Cells
  922. VBA code to protect cells Outside a given range
  923. Loop Through Range
  924. Print Wide html reports using Excel
  925. Print only the used sheets in all open files
  926. 2 codes in one sheet
  927. Change cell font color when cell is clicked
  928. Wrapping entries in a ListBox
  929. VBA Code for Pasting Contents
  930. VBA Code for Pasting Sheets
  931. Call a Sub from another Worksheet
  932. Counting rows and inserting blank lines
  933. Macro not saving as
  934. Insert Pagebreak in Word document
  935. MSGBOX Run-time Error '13': Type mismatch
  936. Excel VBA 2003: subroutine to reorder conditional formatting rules
  937. Excel VBA 2003: how do I call an Analysis ToolPak function within
  938. Protecting range limits
  939. ADO connection Problems between excel worbooks
  940. Avoiding #N/A result
  941. Filter by error
  942. Inverse Matrix
  943. Column Coding
  944. Copy image in excel to publisher document using vba
  945. Comparing two worksheets
  946. auto_close give me additional information?
  947. is it possible to run code written inside a cell
  948. Formula- to create drop down down list based on diff criteria
  949. Combination to Two formulas with the Help of AND / OR / IF Functions
  950. Auto closing UserForm
  951. LoadPicture() error XL2007
  952. Fill Down based on count in another sheet
  953. Search multiple columns
  954. Save all codes in a plain text file
  955. Is the MSFT online help offline?
  956. Combo Box question
  957. Autoadjust range declaration coding when inserting rows
  958. moved macros to new book, now not working
  959. Worksheets and Events
  960. Slope from a range of cells
  961. Print all open files
  962. Autofilter question
  963. Open Multiple Files At Once
  964. Find and Replace using a Loop won't stop
  965. Can I get Excel to recalculate just one cell?
  966. lock first row and first column WITHOUT selecting Cell "B2" first?
  967. Show Application via Automation
  968. Repost - Updating Links on a network (original 4/9/10)
  969. Collecting data for MPG (miles per gallon) calculation
  970. Before right click:
  971. Lessons Learned
  972. VBA to export large tables from Excel to SQL Server
  973. Edit Query
  974. Open Workbook to Specific Cell
  975. How to limit number of Message Boxes on Validation Error?
  976. Add Information Box to Macro
  977. assigning variables
  978. Compare Names in a column and create single list with adjacent vla
  979. Color Variation
  980. Unlock cells based on colour
  981. Unlock based on cell colour
  982. Multiple reference locking/unlockng in formulas
  983. Automating a copy from Excel to Word
  984. Help, help! desparate for formula help!!
  985. Cannot write the contents of an Object to file
  986. Menu Add-in
  987. Initialise the registry values in a array and retrive the values asrequired
  988. Range Vlookup
  989. loop thru cells to find matching record
  990. moved code to new book - some doesn't work now
  991. Loop in Excel
  992. Adding to the cell value with a macro
  993. macro trouble
  994. Excel and Windows Live Mail
  995. C application connected to Excel
  996. Delete contents of cells in a range based on value of a cell
  997. Tagging formatting (cells with mixed formatting)
  998. Determine if the Excel Version is 2007 or previous
  999. Formula ?
  1000. loop VBA request