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. Macro: Altering cells in a range
  2. selecting current row plus the 2 above
  3. Looping through ranges
  4. Selecting Form buttons
  5. Add rows via a button on a protected sheet
  6. Indirect to a closed spreadsheet
  7. RE: Newbie: Problem with re-using a combo-box in userform
  8. Conditional Formatting of Cell
  9. RE: Newbie: Problem with re-using a combo-box in userform
  10. How I can save excel 2003 to excel 2007?
  11. using the enter to skip colums
  12. RE: Data transfer to/from workbooks - Excel 2003
  13. Can VB determine location of last cell changed?
  14. formula ?
  15. filling a table depending on header row name
  16. Parsing Data
  17. RE: saving as option
  18. Best Way to Understand Extremely Dense Nested Ifs in Formulas
  19. Edit a GETPIVOTDATA formula?
  20. T^2
  21. Day - Date problem
  22. Marco - I need to trim/move the text from the beginning of each ce
  23. Conditional Formatting of one cell based on another using vba
  24. Linking an Active X Listbox to a worksheet list
  25. RE: Get External Data
  26. RE: Get External Data
  27. Form Fields in Word have trailing spaces
  28. Retain original invoice format
  29. use vb to determine last cell changed
  30. Barcode solution in VBA
  31. Send email with 2 or more attachments
  32. Deleting duplicates between sheets
  33. Import External Data
  34. Data form not triggering Worksheet_Change event
  35. algorithm
  36. filling a table based on header row name
  37. Unprotect in a macro
  38. filling a table based on header row name
  39. I need a little sub routine
  40. How to specify path when using SaveAs ?
  41. Selecting columns to copy and paste
  42. If data in Workbook1 and Workbook2 put in Workbook3
  43. How to design?
  44. Macro to place quotation marks before and after text in all cells
  45. Bypass Auto_Open
  46. Delete summary rows programmatically
  47. Button on Userform to Stop a Macro
  48. vba to get file extension from col A file names
  49. Re: Recording Excel98 Macros
  50. Maintaing public array values in a user form
  51. How to determine the logic of a complex task
  52. Search ideas to by pass Bug "OnAction" with parameters XP/ XL2K SP3
  53. Finding first value in named range referred to in data validation list
  54. Moving files
  55. Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does
  56. names.add limits
  57. Re: writing strings > 255 characters to Text Box
  58. Indirect Accessing of Collection Items
  59. using SQL against Excel tables
  60. Copy row to different worksheet
  61. Select problem
  62. Check Box Help
  63. If statement giving syntax error when run macro
  64. VBA code for excel 2000 no longer works in excel 2007
  65. Clueless about using cut and copy with offset
  66. strSQL with CompletedDate
  67. Data Mover
  68. Call command for Excel Wizard
  69. Create a pivottable from a recordset?
  70. Compare cell value to items in string
  71. VB coding
  72. Unable to unassign macro from shape
  73. Formatting columns for Lat-Long
  74. Check active cell value without using macro
  75. Deleting Comboboxes
  76. Drop Down Won't Display Last Entries in List
  77. check
  78. Saving activesheet as csv in new workbook: I paste then save it butit saves it in sheet3 not Sheet1?
  79. Delete rows with macro not working
  80. Executing a macro from an add-in in Excel 2007
  81. Copy Cell Formatting to activecell with VBA
  82. Personal.xls macros only work in that sheet
  83. Open second Excel file with VBA
  84. Type Mismatch Error
  85. Renaming sheets - Performance problem
  86. Automating the Watch Window entries in VBA Editor
  87. Can the Application.wait method create a pause less than a second?
  88. Excel VBA to insert a break for 0.2 seconds then continue
  89. Activating problem
  90. Extract Values from PDF into Excel ?
  91. school timetable
  92. Nested With
  93. Left Header in 2007
  94. SETTING FOCUS TO A CELL IF SINGLE CLICKED
  95. Automatic Activation of Macro when Tabbing into a cell
  96. Deleting Cells with Duplicates
  97. Available Printer names to be placed in a range on a sheet and Force selection based on part of Printer name
  98. Delete cells below a certain rank
  99. Seperate Repeating Info into One Line while deleting others
  100. fails tospecify max Columns size in 2007, InteropServices.COMExcep
  101. Problems with transferring data into different columns in a workbo
  102. Macro to graph (or draw) a vertical line on the chart
  103. Dynamic Named Cell
  104. Discover the cell address of an attached comment?
  105. Populate a list box with all active workbooks except the current one.
  106. Last Cell
  107. Pass a Function Value thru several Subs
  108. CopyFromRecordset only returns first record
  109. is there a way to?
  110. VBA Automation of Internet Explorer Child Window
  111. Selecting Ranges to print
  112. Solver Automation Problem
  113. Scrollbar changing dollars
  114. Password protect select sheets in a workbook
  115. Macro sending sheet with not working hyperlink
  116. Conditional formatting - why doesn't this work?
  117. Macro not finding last cell in range
  118. Macro needed Appointment Scheduler
  119. "&" symbol in header/footer
  120. Copy / Paste / ESC Key ?
  121. VBA: Adding contents of a cell to a chart as a textbox (or image,
  122. 10 seconds to open excel workbook w/macros
  123. How to create submenus on Shortcut menus
  124. Re: Validate date in Excel as weekday
  125. RE: Validate date in Excel as weekday
  126. Macro-if condition met-copy and paste row to new sheet
  127. HELP: Web Query Vs Need to Log in
  128. Error on pastespecial
  129. Lookup difficulties
  130. Sorting, replacing data
  131. Problem with working days
  132. VBA macro to select a tab
  133. SaveAs XLSM question
  134. Open successive files in a directory
  135. Close all inactive workbooks without saving
  136. array sintax
  137. Sorting block of rows with empty rows between it
  138. Selective Ribbon load in 2007
  139. How to enter a formula (cell reference) to a shape instead of text
  140. Run Time error '1004': Application-defined or object-defined error
  141. Excel Formulas Treated as Strings
  142. Refers to active cell not working
  143. sheet tab value/nav menu
  144. Refers to active cells
  145. Import Table / Field Code Data from Word
  146. defined size lists
  147. Active workbook folder name
  148. code broken
  149. Maximum length of SQL
  150. Saving Workbook in a shared drive
  151. Saving a collection to an external file
  152. Sorting a Collection
  153. RE: Select Merged Cells and Unmerge Spread Merge Data To All Cells
  154. Concatenating Loop
  155. Removing a leading space in a numbered currency cell
  156. copy worksheet to another workbook
  157. sort routine puts in wrong order
  158. How does this code know which sheet to act upon?
  159. Date format in a listbox
  160. Re: Excel 2007 Macro Programing
  161. NOOB: Can someone write me some code?
  162. Use VBA to change &File Control in Worksheet Menu Bar
  163. Assign "Get External Data" from a VSTO Add In
  164. Automate finding every 15th record
  165. directory structure in VBA form.
  166. Excel cell by cell writing.
  167. Programming Challenges!
  168. Pivot Table Question
  169. Prevent Page Break across a Cell
  170. Leading Zero for Long
  171. Office 2007 SaveAs Issue
  172. Diasable Fill function
  173. Making a formula Work....
  174. Remove the right most 3 characters from a string
  175. Two Levels of Security in Database Tool. ASP Report Maker
  176. Getting a Macro from Word to Work in Excel
  177. What is the benifit to programming w/ Class Modules
  178. Child pivot table's source breaking from parent pivot table
  179. add items to a list box
  180. Linking auto filters to pivot on another worksheet
  181. Converting Time
  182. Compare & align like items from 2 Roaster columns of Employees.
  183. Excel 2007 conditional formatting - how to get cell color?
  184. overriding the Workbook Unprotect-function
  185. advanced filter
  186. VBA Programming: Cut and Paste Loop between 2 sheets
  187. Should it be Index or Offset ?
  188. Should it be Index or Offset ?
  189. Progam Pivot Table connection via OLE DB (vs ODBC)
  190. CreateTextFile method - Pagebreaks in the Text file
  191. selecting a cell
  192. Create sheets from Autofilter output
  193. next blank line
  194. Open excel file error in an ASP.NET (EventID 2001)
  195. change path to an add-in
  196. Disappering CommandButton Doesn't
  197. Copy Rows from master workbook & paste in other workbooks
  198. Re: Excel 2007 Macro Programing
  199. Highlighting rows in a range where ID code does not exist in secondrange...
  200. Workbooks.Open suppresses MsgBox Displays when Macro is run
  201. Macro needed
  202. Adding Input field from VBA form in an email
  203. Automatic Cond Formatting of multiple columns based of values of 1
  204. Excel worksheet shows reporting tool but code and underlying data notdisplayed
  205. TEXTBOX CUT COPY PASTE
  206. Code to read file in reverse fast line by line
  207. need help with a bit of proggraming
  208. How to repeat a lookup; copy & paste from 1 worksheet to another.
  209. Compare cell values in row for matches - support needed
  210. Email with attachment from range
  211. Pull Left & Right Text
  212. Blanks in a pivot
  213. locking cell
  214. excel formula question
  215. compare unsorted data across workbooks
  216. Alternatives To: FileSearch with TextOrProperty (Problem FindingPhrase Such As "An apple a day")
  217. Alternatives To: FileSearch with TextOrProperty (Problem FindingPhrase Such As "An apple a day")
  218. Pivot Table in a macro only bringing in One Field
  219. Re-size Comments Box
  220. Macro to Clear Cells and Delete Rows
  221. Window change event?
  222. Filter Items from a Pivot Field
  223. On Error Not Working...
  224. Vista -vs- XP
  225. Linking time values
  226. File Save Question
  227. Check existence of file if file name has a space in it.
  228. Custom toolbar's name
  229. Read Excel data from VB.net using range object - prob with 'undefi
  230. Open Workbook Add In with 2007 & 2003, Which Changes Ribbon & Tool
  231. Lookup
  232. Increase date field by 1 day based on current time?
  233. Dynamic Range & Offset code problem
  234. copy cell a1 to 1 of 2 wrkshts depending on the value of other cel
  235. customer tool bar
  236. Problem: FileSearch .TextOrProperty WIth Phrase Containing Blanks
  237. Loop error
  238. List Filenames and Date Modified
  239. Send xls file and enable macros
  240. Macro or VBA Code to return Multiple Rows?
  241. Forcing to load one file before another
  242. Pivot table rename
  243. I had this working a few days ago but now cannot get it to run
  244. Extend row down by 1
  245. Macro with column delete running very slowly
  246. Date & Time Calculation
  247. Using combo box to change color of tabs (xl 2003)
  248. Emailing reports
  249. Building the PageFields:=Array(
  250. DDE links cause excel 2003 autosaving after each cell edit
  251. Opening CSV File
  252. Changing the CurrentPage items in a Pivot Table
  253. Listbox
  254. Grammar check
  255. Trap a user to a cell.
  256. How to do this with VBA
  257. Excel Version Management
  258. Object hyperlink
  259. Multiple changed cells not detected
  260. random?
  261. Delete row if column A cell text length is not 11
  262. Hyperlink downloads
  263. use looping to update label
  264. Excel Interops for 2007 & earlier versions
  265. ColorIndex vs Color?
  266. purifying data
  267. Help with deleting Frames or checkboxes from a user form
  268. Re: Can I know what Folder I started from?
  269. 'Value_If_True' vs. 'Value_If_False'
  270. Reusing code
  271. macro file 'fShowTTODialog' cannot be found
  272. Excel 2007: Print Form Control on a full page graph
  273. Delay update of sheets
  274. Change macro to copy variable amount of rows instead of just 1?
  275. How to create a range in code
  276. How to add this function to Personal Workbook
  277. Importing multiple text files to 1 spreadsheet
  278. Can you check a show modal property
  279. Input Dialog Box
  280. using a form for cut and paste
  281. Getvalues Macro Help Needed
  282. adding a string of data to an array
  283. runtime error
  284. Excel 'Arrow' Symbol - Coding Help
  285. Help? Anyone see problem with this macro? Way to condense it?
  286. filter two worksheets w/ the first as a controller
  287. Infinite loop cancelling BeforeSave
  288. Can you type macro instructions on an excel page?
  289. Edit VBA to print Directory including file owner into Excel Spread
  290. How can I put a "slider" onto a spreadsheet (as a way of enteringnumbers) ?
  291. Additional Controls
  292. How to force Excel wkbk to close
  293. 2 worksheets compare a range of data, create 3rd worksheet w/diffs
  294. pivot table + fixed column fields
  295. RE UDF
  296. Can I find columns with #### in them?
  297. Exclude hidden sheets from formatting
  298. import multiple files larger than 65536
  299. help with syntax for copy and pasting rows across sheets
  300. Disable Error Checking in 2007
  301. How can I make Excel run faster?
  302. Analysis Toolpak - VBA add-in
  303. Modification of the validation list when copying Worksheet
  304. Run-time error '1004': Insert method of Range class failed
  305. List Visible Controls in CommandBars("Worksheet Menu Bar")
  306. Extending a selection
  307. Enumerating SpecialCells
  308. Replace quotes in notepad
  309. decile function
  310. Macros - Saving over protected worksheet using a macro.
  311. Dialog Box
  312. RE: finding pure pageheader text???
  313. Sharing variables between the macros in 2 open excel workbooks.
  314. populating a validation list
  315. link filtered sheets
  316. Macro to validate rows
  317. Stripping down excel
  318. Enable macros - security settings are at "enable all macros"
  319. Re: Trying to NOT import some records in a large text file
  320. Automatic macro
  321. RE: Trying to NOT import some records in a large text file
  322. Time limit
  323. Running macro on Open
  324. save excel 2007 worksheet as pdf in macro
  325. VBA code/form missing in Excel 2007
  326. Formatting non-contiguous cells
  327. Tick Box v Protection
  328. Sub or Function not defined message on finding Length
  329. UDF
  330. display userform for 10 seconds
  331. SAME NAME FOR ALL SHEETS
  332. problem with offset -how to re-write line?
  333. VBA Help Excel/Word
  334. vlookup where sheet name=cell value
  335. Importing from SQL as a Number instead of Text
  336. Set Cell value form ListBox.
  337. 30 CHECK BOXES to be disabled
  338. Hide Sheets when closing file
  339. Compile Error sending pdf as attachment
  340. debug keeps stopping
  341. Help with macros to manage a list
  342. Completly hide Quick Access Toolbar
  343. Filter a pivot table with large number of unique items in the filterlist
  344. Cancel Out of UserForm Return Focus
  345. Remove All Tabs from Ribbon except Custom Tab
  346. how do I auto number documents in excel
  347. Replacing information from one doc to another if conditions apply
  348. Re: Using an input box for multiple choices has display limits
  349. Excel Cell Formats
  350. Disable "Cut&Paste" and "Drag&Drop"
  351. Invalid Web Query Error
  352. single web query without adding to defined names
  353. Reading variable list of cells into array
  354. Creating Forms
  355. Update a word form from Excel - tips?
  356. Get Name of Icon using Face ID
  357. Rename worksheets
  358. Complex Sum, Reqd. codes.
  359. Assigning Macro to Form Button
  360. i need help on a program i am writing
  361. Use Selection.SpecialCells for cells with a particular value?
  362. SetFocus question
  363. If Cell2.Value = "#N/A" Then formula not working
  364. HtmlTextWriter - export to Excel
  365. Re: Programatically remove VBA Comments & Rename Functions & Routines
  366. RE: Modal or Modeless UserForm?
  367. Re: Programatically remove VBA Comments & Rename Functions & Routines
  368. RE: Programatically remove VBA Comments & Rename Functions & Routines
  369. Anyone up for what I see could be a challenge?
  370. Stop after IF Then
  371. Re: Modal or Modeless UserForm?
  372. Formatting problem
  373. Text from word to be pasted in excel
  374. Unexpected result
  375. Accessing other applications
  376. Re: Modal or Modeless UserForm?
  377. slightly confused - object reference
  378. Phone numbers
  379. time frame
  380. Sendkeys
  381. Set RowSource for ListBox
  382. Excel - how to record a function's result despite future changes?
  383. Applescript: get range of selection
  384. Combo box as an argument of an UDF
  385. Reformat phone to numbers
  386. Time format
  387. Macro - Deleting.
  388. Excel 2007 PageBreaks Question
  389. Question about For Each ws in Worksheets
  390. Activate sheet in another workbook by its code name
  391. VBA SETTINGS - WHAT THEY DO WITH DIFFERENT ERRORS?
  392. VBAProject (Personal.xls)
  393. Getting #VALUE in cells with User Defined Functions
  394. How to tell whether any cell within a Range has non-empty contents
  395. Trying to call a macro on selection of a cell in a range
  396. Macros failing when workbook is in shared mode
  397. macro to delete a row based on criteria
  398. employee scheduling
  399. Pivot Table from Filtered Data
  400. Line count in sheet determines paste range in another sheet
  401. Line count in 1 sheet to determine paste range in 2nd sheet.
  402. merging sheets to master without moving total lines
  403. What is wrong with this code?
  404. Loop Error Trap
  405. before close event
  406. Retrieve Center Header String
  407. Joining data from 2 spreadsheets into 1 sheet
  408. seeking the fastest workflow for converting bmp image into Excel orASCII table with numbers
  409. Comparing 2 worksheets & creating a Diff worksheet. Formula not wo
  410. conditional formatting based on cell contents
  411. All cells "occupied" during BeforeSave event
  412. How change cell to another character, add comma, & continue next c
  413. Can you make a picture grow by putting your curser on it in excel
  414. Add ROUND function to formulas
  415. VBA code to open 3D dialog window
  416. Copy data from Closed Workbook
  417. How do I calculate networkHOURS?
  418. Watch folder, lookup in sheet, rename - How do I approach this inVBA.
  419. Adding Hyperlink
  420. Setting Range value using a single dimension array
  421. How do I calcluate networkHOURS?
  422. Drag and Drop in Excel 2003 with C# and VSTO
  423. Launch MS Access DB from a button in Excel
  424. write a macro to print to search a list and print certain workshee
  425. navigate
  426. Obviate need for reference to Extensibility?
  427. validate url
  428. PPTApp.Activate does not work consistently in PPT 2007 (with XL 20
  429. Storing Formats of cells in Array and reapply later
  430. Problem with text in cell
  431. FileSystemObject does not work on SharePoint
  432. Sorting a worksheet with weird conditions
  433. For..Next Problem
  434. Sorting data
  435. ActiveX Contro
  436. open workbook for sharing
  437. Need a way-probably a macro for sending e-mails
  438. Macro formula for counting rows
  439. Application.Run and pass variables to Sub
  440. ReferesTo
  441. Counting numbers
  442. Multiple XMLMaps export to single document
  443. Turn off a filter before running a macro
  444. Status bar showing sum and count
  445. Excel template and default save name
  446. constrain the no of sub procedure executions per second
  447. Update - 4 - Re: Parsing, mid, left, trim or right to find specific word in string
  448. Charts -- drawing arrows to points
  449. Application.Inputbox question
  450. What is the difference in declaring a Collection in these Procedur
  451. RE: Save Fail on Excel Close
  452. is it the fault of the macros or what
  453. conditional formatting 1004 errors
  454. file owner properties
  455. Macro to insert data behind a certain date.
  456. feedback on charts advisor in excel 2007
  457. Forms help
  458. Data validation list drop-down values based on prior selections
  459. permission denied error when automating explorer
  460. Trying to insert rows in a Macro
  461. pulling data and autofilling fields
  462. japanises letters
  463. That's it. I've had enough!!!!
  464. combine two formula in one cell
  465. Calculating Age (in days) with multiple date formats (including ti
  466. turn multiple vlookups into one macro
  467. how can i move a scanned document from word to excel
  468. Is there anyway to find out which cell is being calculated?
  469. Add body message to auto-email code in Outlook
  470. Worksheet Activate event not firing
  471. Missing Expand All
  472. auto enable macros
  473. macro to add row in same worksheet based on 2 fields not having a
  474. Now Formula
  475. Excel formula in VBA
  476. Change cell after macro
  477. Check box
  478. Copy Excel chart to PPT that is already open
  479. Excel Table of Contents
  480. Copy and populate a worksheet when a new data line is added on ano
  481. VB code to run a Query in Access and paste results onto an Excelworksheet
  482. Printing Control
  483. general formatting
  484. function to re-calculate when cell format (colour) changes
  485. set toggleButtons to "pressed" by default
  486. Copy conditional format using formula to entire worksheet
  487. Help with Filter and FilterOn
  488. free text in combo box
  489. Macro Protection
  490. changing colours on chart series
  491. Weird Macro Behavior
  492. PasteSpecial fails
  493. Listbox Time Formatting
  494. Need Excel Macro
  495. Setting all the Chart Colours in VBA and also font sizes
  496. Macros...
  497. Hide Rows based on value of a cell
  498. system.Runtime.InteropServices.COMException (0x80020005): Typemism
  499. Trap Mouse Move event for Images inside the shape or Image control
  500. if fuction in data validation
  501. Two dinamic graphs in a worksheet
  502. How can I covert Indian Rupees to Word in excel 2007
  503. Sub to open n close .xls files in folders
  504. Renaming worksheets taking REALLY long... any ideas?
  505. Dialog box for Inserting Rows
  506. Capture an event for hyperlink is Excel
  507. Shapes Fill
  508. Change SourceData with ScrollBar for SheetChart Type xlColumnClust
  509. copy method of range object
  510. Creating a ratings spreadsheet?
  511. Macro to insert row in protected sheet
  512. range referencing
  513. Very Unusual Sort Rows Needed
  514. MACRO - INSERT ROW
  515. recalculating RAND() inside a VBA loop
  516. Macro fails on 1 out of 4 computers
  517. How can I seperate Imported text with delimeter as part of the par
  518. determine current theme in xl2007
  519. Bolding a Cell under certain conditions
  520. Premium Solver Macro Problem
  521. Numbers in combo box
  522. Re: Columnwidth in cm?
  523. filling a table depending on column heading
  524. Fill/Copy Up to fill blank cells.
  525. Is Sumproduct best for me?
  526. index and names of open workbooks
  527. Null value in excel
  528. Cell Reference
  529. More efficient code than this?
  530. How can I get Memory used by Current Excel Application?
  531. Automatically increment cell reference
  532. Get smaller range from within another range using VBA
  533. Excel 2007 Named Range - Naming convention
  534. Changing rows
  535. New to VBA
  536. Working with Excel via Visual Studio 2008
  537. disable macros in a worksheet
  538. Problems with ChangeLink Command in Excel 2003
  539. Excel 2007 - Workbook.Open Question
  540. Working with Excel via Visual Studio 2008
  541. Tick Quandry
  542. Fine Tuning
  543. Copy from Internet Explorer & Paste in Excel
  544. runtime error 13
  545. Export to Excel with different sheet names
  546. problems with calendar control
  547. RE: Excel VBA drawing Arcs programmatically - not lining up!
  548. need mulitple lines in a cell
  549. RE: Columnwidth in cm?
  550. Are links relative?
  551. add 1 to the value in a cell
  552. enter check mark with one click
  553. Up and then down VB code
  554. Object Library References Question
  555. Excel 2007 Add-ins
  556. I need help creating a macro
  557. Program to insert pictures
  558. Need to you quotations ("") in a string.
  559. Method 'Range' fails while using AllowEditRanges
  560. FileSearch on a remote server
  561. Tiny Charts
  562. Event Change code
  563. userform question on UserForm_Click()
  564. Problem copying formulas using VB
  565. Hi, i need help whit macros
  566. Lotus Notes VB code (yes, it works)
  567. Batch Delete VB code
  568. loop though numbers
  569. Problem when copying a range from closed workbooks (ADO)
  570. Calling a function within a macro
  571. Userform is blank
  572. Macro output as Text
  573. Inserting Comments with VBA
  574. error 13 when setting worksheet listbox
  575. Keyboard shortcut values displayed on custom ribbon
  576. data validation (multiple options)
  577. macro needed for saving
  578. excel macro to copy the word document to new excel workbook
  579. How to run Excel Macro on all files in folder
  580. goto next if
  581. .Refresh BackgroundQuery:=False
  582. List Box Select All Values
  583. delete unused rows
  584. Modifying a LARGE text file
  585. Standard numbering
  586. Excel as a data source for Outlook to email Word docs
  587. Why is my UserForm event procedure disapeared?
  588. Knowing what Folder I'm in when I open from a shortcut
  589. Required Columner Data
  590. Date Diff Help
  591. EOF Parse Text file
  592. finding the next empty column
  593. average of column
  594. Count number of like occurences across all worksheet within workbo
  595. VBA Newbie
  596. Workbook closing
  597. Header horizontal margin seems fixed, won't move
  598. Make sure all items in a Collection equal the same thing
  599. images for user form
  600. How can I locate image code in a worksheet object
  601. UDF or SUMPRODUCT with 51 named ranges?
  602. Determine if particular procedure(s) exist in module
  603. CustomProperties
  604. Using VB to change a defined formula within a pivottable
  605. Parsing, mid, left, trim or right to find specific word in string
  606. Exposed Workseet names
  607. Move downloaded bank transaction to a specific worksheet in same workbook
  608. Custom View Macro for Excel 2007
  609. Variable equal to values in a list
  610. Variable Address in Pivot Table VBA code
  611. Disabling Function Results in the Function Arguments Window
  612. Copying an entire sheet from 2007 to 2003
  613. UNABLE TO IMPORT A TEXT FILE HAVING 30 COLUMNS. LOADS ONLY TILL 26column.
  614. Application on my desktop
  615. Excel VB ListBox 'Height' Problem
  616. relative path
  617. Excel import data from old accounting systems
  618. Named Identity
  619. Using Form Buttons / Objects
  620. Link source - Need change?
  621. Record Comparison Between Two Databases
  622. Output file to My Documents
  623. Prevent SaveAs on Protected Sheet
  624. Macro is choosing by tab name?
  625. Macro (Modle) naming insight
  626. Problem with "Call was rejected by callee."
  627. Run-time error '1004', the macro xxx cannot be found.
  628. looping down 1 column then start agian at the top of the next column?
  629. Checking for duplicates
  630. ISERROR
  631. Changing the "From" field in Outlook using Excel macro
  632. Convert Range to Array
  633. Prorgram doesn't work on different computer
  634. End loop
  635. Hiding rows
  636. Window Caption
  637. Cancel Toolbar load
  638. Delete rows based on more than one condition.
  639. FileSearch in Office 2007 generates an error?
  640. Deleting a Worksheet??
  641. Quotation marks in a string
  642. How to copy data from merged cells to their individual cells?
  643. doesn't read all data from cells into xml file
  644. VBA Vlookup
  645. PivotField CurrentPage Change Event
  646. freeze or lock rows when using Auto filters
  647. Patek Philippe Calatrava Perpetual Calendar 18kt White Gold MensWatch 5140G
  648. Userform - placing
  649. Using IF to decide action
  650. Autoname a range
  651. Color sorting
  652. Autofilter-sorting from specified cell
  653. How do I create an organization chart in excel
  654. Common set of macros
  655. How to use SUMPRODUCT or SUMIF with 2 criteria?
  656. Macro to copy active worksheet from multiple Excel files into 1 fi
  657. Relative Path in Excel to a word document
  658. Pulling data from mySQL DB to Excel spreadsheet
  659. User form bug
  660. Search Form
  661. Launching PowerPoint from an Excel application
  662. Write filepath to file
  663. Problem with Naming Cells
  664. Find variable in a sheet
  665. Command Bar Excel 2007
  666. EDATE & #NA Errors
  667. Music files
  668. Tags for worksheets
  669. finding numbers
  670. use only part of window name in a macro
  671. mousepointer
  672. Can you use offset and empty in the same code
  673. Can you hide and unhide rows with a macro based on content of colu
  674. little mistery..
  675. Simplify Code help
  676. Importing to Excel 2003 - Code from Jean-Yves
  677. Add two cells if one cell is greater than 0
  678. Surpressing a Message
  679. Multiple ADO queries at the same time
  680. idiosyncracies of user form
  681. Changing printer defaults in Excel Worksheets
  682. Need code assistance to update pivot table from an ADO recordset
  683. Regional Language
  684. Re: Mail with "Lotus Notes"?
  685. Web Queries : Passing variables via POST method not working
  686. Converting xlsx to xl
  687. How to obscure functionality
  688. Help!!! Database lookup from excel
  689. VBAProjects still open for workbooks closed in Excel 2007
  690. Re: Using Variables in ActiveCell.Formula
  691. Re: Using Variables in ActiveCell.Formula
  692. help required to change format when converted from excel to xml.
  693. RE: Mail with "Lotus Notes"?
  694. Auto Filter
  695. excel macro to copy the outlook mail body to a new excel workbook
  696. Macro to delete on condition
  697. Excel 2007 - Textbox Formatting
  698. Offsetting to identify value in header row
  699. Assigning value to text
  700. User defined range for vlookup w/ loop
  701. Inserting a blank line
  702. Fill series event detection
  703. and + or
  704. XML export form a Excel
  705. Open Workbook Empty?
  706. code instead of functions
  707. For Next If help
  708. howto: disable date recognition?
  709. Image Control Question
  710. Force Save Folder Location on Network
  711. File closes without prompt to save!!!
  712. using an excel database function in Visual Basic
  713. Open a workbook from a written path
  714. Selection
  715. Select locked/unlocked cells
  716. 32000 chart limit warning
  717. Wildcard use in comparason.. Please help
  718. delay in msdos batch file
  719. Using 2 cells in the same row within a form
  720. multi threading
  721. Writing Data to cells
  722. Re Excel 2007 Trend Equations
  723. why do I have to have the table files.xls open in memory to query
  724. putting criteria directly into a database query, dsum, daverage, e
  725. Excel 2007 Shell Command Runtime Error HELP
  726. a way to make this more compact ??
  727. standby for parts of code
  728. Creating an AutoNumber ID as a primary key
  729. Data validation list limit
  730. Search and Replace Problem
  731. Can't Unhide Complete Workbook after adding code to hide it
  732. take fields from form to report
  733. How do I pass a value from an event back to my VBA Programming enviornment.
  734. relative reference between two tabs
  735. Setting Up a Dynamic Print Range
  736. Trying to Mimic an Array Function in VBA
  737. Print selection using check boxes
  738. Macro to create different groups
  739. End without Next Error
  740. use different string variables in FOR loop
  741. Position a user form next to selected cell
  742. Find and Replace Help
  743. Inserting a value based on another value
  744. Find and Replace Question
  745. relatetive reference-to perform a series of cal and return result
  746. keep last row added visible on the screen
  747. find a value in another sheet
  748. Get value from one row to another
  749. Accelerator keys
  750. How Can Make equation With IF X>Y>z