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. Help needed with Complicated code (For me !!)
  2. Error 1004 when setting a Series Collection.Values as Array via VB
  3. What are the reasons for ""ActiveSheet.Paste Link:=True"" failure
  4. ODBC MS Query - chinese character issue
  5. which range staement is preferable?
  6. Saving images in VBA
  7. Pivot Table Page Field
  8. AutoFilter - Lack or Experience
  9. Change default Save As file type
  10. If statement question
  11. Help on editing a function using a macro
  12. Cannot Reset a Protected List
  13. Addin vs. Embedded references
  14. UNIQ EXPEREINCE: PROCEDURE WORKS FINE USING F8 BUT GET ERROR WHEN COMMAND BUTTON IS CLICKED
  15. Excel 2007 slow
  16. How to handle Blank Cells?
  17. Measurements in Excel?
  18. Import sharepoint data to Excel 2007
  19. Loosing values when working on different functions and modules..
  20. Work out years from entered Date
  21. Need help with slow AutoFilter
  22. Search from the bottom of a Range up
  23. Workbooks("Mappe1").Activate trouble
  24. Copying formulas situation
  25. Error in vba module
  26. viewing specific columns
  27. seeking a smarter lookup function
  28. combine number and string
  29. Converting doubles to text ot string
  30. Using named range intersection in a sum funtion
  31. How do I extract part of a text in a cell?
  32. HPageBreaks.Add
  33. For Next Loop to Make A4 in Each Sheet = Name of Each Tab
  34. Make a combobox equal to part of a cell value
  35. Code a button and Macro to Insert data to an Oracle Database
  36. ShiftJis to UTF-8
  37. populate cell looking at last valued cell
  38. Intermittent Pseudo "Break Point" on First Run but not Subsequent Runs
  39. Excel table in userform
  40. User prompt for data connection
  41. Data lookup function in Excel
  42. comparing strings on seperate worksheets
  43. Some fields required question
  44. . and , while working with User Forms
  45. Data Selection for a Graph
  46. Assigning custom commandbar buttons FaceID numbers
  47. excel.h - How To? Add a new worksheet c++
  48. Coordinates of Cell
  49. many types of loops
  50. Ignore Blank Cells on AutoFilter
  51. SUMIF HELP
  52. I need to set up a simulation
  53. Loading/sorting array of Longs (> 65K rows)
  54. Code equivalent to Alt + Tab
  55. Match() how to workaround identical Lookup_values
  56. Date Format in UserForm textbox.
  57. How can I turn off the OLE warning when merging cells?
  58. Autofit rows where a cell contains results of formula
  59. Color Coding Findings
  60. Embedded Excel Problem with Menus/Commandbars/Toolbars etc
  61. The Information cannot be pasted Message
  62. Querytable and pivot table refresh problem
  63. paper size by name
  64. Names.Add
  65. File constantly defaulting to previous version of Word Object Libary
  66. Printing an existing excel file in C#
  67. Embedded Excel Problem via c++
  68. Printing a Dynamic Range
  69. Printing an existing excel file in C#
  70. Using DSN-Less Connectino from Excel to SQL
  71. Named Ranges
  72. copy and paste question
  73. Selected cells not updating
  74. Read Text Form Fields from Word Documents
  75. office 2007 and vsto
  76. right click hide
  77. SendKeys
  78. How to select cells in specific Columns?
  79. count no. of times a text appears in a sheet.
  80. How to return the address of a cell found via VLOOKUP?
  81. Resize any selected object
  82. Change PivotField Properties with Empty Cache?
  83. how can I fix Broken Links
  84. Application.Run with variable number of arguments
  85. Fed value to unhide rows in another sheet
  86. Option Buttons Off When Program is opened
  87. adding a self destruct feature
  88. Expand selection
  89. numbers (like invoice numbers) in Excel worksheet
  90. Date range
  91. Best Way
  92. Search a column, enable input fields, save to row & columna, reset
  93. Where is My Data
  94. ".MatchTextExactly = true" not always the case, please help.
  95. WorkSheet or AutoFilter Problem
  96. Operation is not allowed
  97. Force save with timestamp
  98. combining two columns into one-Excel 2007
  99. Trying To Push Code For Worksheet_Change Into VBA-Created Workbook?
  100. Enter Data
  101. Macro - Find Next Change In A Column; then insert row
  102. Newbie: Dimming a variable.
  103. printer page length
  104. Returning focus to a user form after getting message box response
  105. print macro dependent on conditional format
  106. Pivot table, average, upper/lower control limit
  107. Shift-JIS to UTF-8
  108. there's got to be a better way...
  109. Changes Macro from WorkSheet to All Books
  110. sort question
  111. Top of AutoFiltered Range?
  112. List file name only
  113. Adding values from two different worksheets from workbook
  114. Array formula in memory
  115. VBA REQUIRED TO TAKE VALUE FROM EACH CELL FROM A RANGE AND FIND THE VALUE FROM A DIFFERENT RANGE
  116. Import Query from Access - Bug
  117. Popup box help?
  118. Disabling scrollbars for an excel's built-in form (Autoform)
  119. Problem with AutoFilter
  120. What type of loop?
  121. User entry in a cell unless conditions are met?
  122. Generating random lognormally distributed numbers
  123. vlookup not working with defined name
  124. Runtime error 91 on website login
  125. Ghost code from User-defined Add-Ins
  126. Problem saving file as xls
  127. Edit Closed XLT
  128. Run Tab Macro
  129. inserting three rows
  130. printing number of copies
  131. .Net via COM Interop in VBA
  132. Need loop help.
  133. Searching certain ranges and stopping when finding no match
  134. IF statement failing
  135. Opening a Succession
  136. Bringing upanother WorkBook (Sheet)
  137. ThisWorkbook.Activate Question
  138. Before sheet copy
  139. How do I determine if a workbook is a template?
  140. stupid me - search across row
  141. Data from another cell
  142. Tab Names
  143. Using excel built-in form, through VBA, script to initialize it
  144. Bootstrapping in Excel
  145. "Available Resources"?
  146. ranges as arrays
  147. Named Ranges
  148. Destroying All My Work
  149. S/W to aid in debugging "Next w/o For" or "If w/o Endif"?
  150. Userform, Excel 2000 & 2003
  151. Which runs faster
  152. Code to track changes by row and store
  153. insert every other column from other excel cells
  154. Unprotect all sheets
  155. Close all internet explorer windows
  156. How can I enter a workbook password automatically
  157. Move Data From Active Sheet to New WorkBook
  158. Date problem
  159. unprotect next sheet
  160. Can I pgrogramatically access Track Changes?
  161. How to Prompt a user to select a Folder.
  162. Debugging a function
  163. Code to show if a cell has met conditional formatting
  164. Delete rows containing Vendor Total A,B,C etc
  165. Time Formatting - Obtaining the Meridian
  166. Editing Text Boxes
  167. code for text
  168. .onaction, passing arguments
  169. run time error 1004 general odbc error excel 2003 vba
  170. Save Time With Heading Functions in Excel
  171. Referencing checkboxes on a worksheet from a form
  172. Copy data from one worksheet to another
  173. Make macro run on all worksheets except the first
  174. Using Powerpoint inside Exel program
  175. Copy Worksheet from Macro
  176. Sumproduct between and
  177. Can you pin ribbon tabs in Excel 2007?
  178. Print one cell to one page
  179. Implementation Guidance - Onclick or Hyperlinking
  180. Excel running when user is not logged in to windows
  181. litter square caused by ALT + Enter
  182. Folder access rights
  183. Multiplying non consecutive rows, then adding it.
  184. Testing for empty sheet
  185. Attaching a xml schema to a excel worksheet
  186. Selecting only from index for combobox
  187. Procedure Name as a property?
  188. Compare Column to Inbput Box Variable
  189. Calling Public Variables between diff Modules
  190. Automatic copying of results from one sheet to another on same fil
  191. HOW TO: capture the event when a row group is expanded or collapse
  192. global variable not seen
  193. Run time error 91
  194. Date calculation
  195. Creating delivery notes from a spreadsheet
  196. Migrating VBA to Excel 2007 - AutoFill & Excel Object Error - ExcelFrom AutoCAD 2004
  197. Forcing a selection
  198. Paste text to userform
  199. "Tutorial for Userform Controls?"
  200. offset every other row down a column (2 merged rows)
  201. How to make a data validated field refresh
  202. Need Recommendation
  203. Using Subtotal: How to update TotalList:=
  204. Email notification
  205. reorder info
  206. Command Buttons Outside Spreadsheet
  207. Codepages and displaying euro sign
  208. Background colours...
  209. copy the font color
  210. File exists but cannot open from Excel
  211. "floating" button
  212. Absolute reference problem - Excel 2007
  213. make selection in listbox html with vba
  214. How to insert rows as value?
  215. Code to add Formulas with new records
  216. Pivot Chart - Disassocoation from PivotTable
  217. Get rid of all displaypagebreaks in whole workbook
  218. Macro in Excel 2007
  219. Convert String Representation of Excel Constant to Actual Value
  220. about worksheet_change
  221. Newbie sort problem - Please help
  222. Compare values in a column
  223. Macro to change cell colour based on words
  224. Help with conditional formating
  225. Checking two cells
  226. UDF to reference the cell with the function in it
  227. Print multiple worksheets into separate pdfs
  228. Worksheet_Change fires even when no change?
  229. Where do I find Visual Studio Solution Explorer
  230. Counting Consecutive Numbers
  231. Listbox, fill by format
  232. Retrieve Data from a pivot table
  233. Count some of the numbers in a cell
  234. conditional format question
  235. how to import an excel table into sql server express?
  236. Excel crashes on copying macro using VBE.VBproject
  237. Autofilter and formatting
  238. Task pane best practices
  239. Workbooks.Open Filename
  240. AutoFilter with protected sheets
  241. How to create "modern" controls on a worksheet
  242. Pause a Macro
  243. Searching through text - Speed issue
  244. Skipping a tab when with this macro
  245. Excel Chart Add Series with VBA
  246. Why won't this work? Syntacs?
  247. Search all directories for .mdb files
  248. Cell drives combo box change
  249. Run macro automatically
  250. Subtotaling a Varied length Spreadsheet
  251. With Me statement
  252. How does Collection.Item search
  253. Need help with text to column code
  254. ExportAsFixedFormat?
  255. Totals rows dynamically moving to accommodate amount of informatio
  256. weird problem with an excel file, asp.net and IIS
  257. Workbooks.SaveAs - How to have it saved with .xls extension?
  258. ChangeLink spends a lot of time
  259. Populate Combo-box from Multiple Sheets
  260. Can't create macro - Excel 2007
  261. Code help?
  262. Is there a way to compare all columns in a Row and flag difference
  263. ListBox Home Stretch!
  264. Excel 2007 worksheet visible problem
  265. Turn Off Sounds in Macro
  266. Preventing cutting/pasting
  267. variable dimensions
  268. An algebra/programming question
  269. Activate Sheet Best Practice (Y/N?) when xFer data between sheets?
  270. Last Row In Named Range
  271. missing functions
  272. Excel programming - scanning values, populating cells - please hel
  273. Count series in chart
  274. copy excel to word
  275. Find Copy Paste
  276. I need Help Please
  277. Textbox in a toolbar
  278. Excel program 2007 does not allow use the majority of commands....
  279. Removing "Contains Macros" popup
  280. errors on linking for *.def file
  281. Print macro help
  282. How to test : files are already opened or not
  283. Worksheet_Activate - conditional use
  284. color change in a table
  285. Using MyValue in SaveAs Fname
  286. Selecting Populate Cells
  287. Roger Whitehead contact details
  288. Copy values only
  289. Hyperlink to folder not opening
  290. Borders
  291. Application.WorksheetFunction.VLookup (Plz Help)
  292. indices in named range
  293. Passing variable to and from a form
  294. Different Zip File Size for Excel with and without Workbook Protec
  295. Move File to new folder - Problem
  296. Macro - highlight rows
  297. Login date & time to the VBA application.
  298. Difference between Userform Activate and Initialize
  299. Export worksheet in New File by VBA code
  300. Combobox Help
  301. running a macro, while programming in vba at the same time
  302. How can I password protect a single worksheet within a workbook
  303. To Place Button in Excel
  304. Jaccard Statistic
  305. Unique values from date range
  306. Removing space characters
  307. Implementation Guidance
  308. Macro to create a new worksheet that is a copy of an existing one?
  309. Sendmail with a named cell value as recipient
  310. Relative path
  311. how to program in excel
  312. complicated macro
  313. Macro program protect
  314. Add-In UserForm Crash
  315. Excel newb needs help writing a macro
  316. Determine If A File Was Specified When Starting Excel
  317. Stock Quotes
  318. refer to one userform from another
  319. Is it possible to open only form when an excel file opens...
  320. How do I continue a routine while showing a userform?
  321. unwanted reinitialization of global variables
  322. Dynamically sorting a range
  323. Clear rows with no data?
  324. Auto Populate Combo Box When Opening a Worksheet
  325. "Which control to use in a UserForm?"
  326. List Reference
  327. Work with only objects in a frame...
  328. For...Next or Select Case Statement
  329. Creating a folder using Visual Basic HELP!!!
  330. Animating charts
  331. Copying columns to new sheets
  332. Lock cells but allow sorting and filtering
  333. Programming Formula for Cond. Format yields different formula
  334. Macro Help
  335. Extremely Slow Code
  336. web site query
  337. Delete Blank Rows in a pattern
  338. array question
  339. Trouble with VBA code for Excel.
  340. Why this code crash Excel?
  341. concatenate with vba
  342. Worksheet vs. Worksheets
  343. Conditional formatting with decimals
  344. Loops for copy and paste
  345. setting range names
  346. Resize Sumif formula parameters for added data
  347. Syntax or Something is KILLING Me
  348. Conditional Formatting
  349. Worksheet.opentext....???
  350. How to automatically stock Dynamic data?
  351. Specifiy Chart Data Range
  352. References
  353. Show All Data
  354. Need Direction
  355. macro to automatcially delete a worksheet
  356. Selecting a range defined in a cell
  357. Save userform values in excel sheet
  358. Conditional Formatting using VBA in Access
  359. adding right click menu to textbox
  360. Excel 2007 statusbar hWnd
  361. Automatically Update Delimited/Comma Seperated File
  362. VB: If Solver found no feasible solution
  363. VBA Codes Protection
  364. Problems deleting columns
  365. Getting Summary Data From A large Data of Files in a Directory
  366. OR statement VB
  367. Compile Error: Method or Data Member not found
  368. OpenText method - how to check if file exists
  369. Easypdf
  370. Import All Sheets from Closed Workbook
  371. Fail to open unicode txt file in excel
  372. Microsoft Charts
  373. Open password workbook not working
  374. Right-Click Sheet, Move or Copy, & Class Module
  375. sum
  376. UDF Question
  377. Excel 2007 is asking me to download VBA converters
  378. Variable in one sub which refers to an input box in another sub.
  379. Copy Auto-filtered data to new sheets
  380. printable area size
  381. Sort Combobox Items in Userform - shahzad
  382. 5 schifts
  383. missing something
  384. def numbers
  385. Clearing Empty Cells.
  386. how do you name a range?
  387. Coping ranges of cells
  388. Ensuring Autofilter arrows are visible at end of macro
  389. Transpose and VBA Resize command
  390. Excel Workbook for Multi User Access
  391. can't move UserForm with the mouse
  392. Basic Questions
  393. Automating Text to Columns -- can I auto-click "OK" on the message
  394. Initializing Multiple Combo Boxes
  395. named cells
  396. separate two strings
  397. DLL question
  398. VBA (or Excel) crashes if Count of Visible Rows in Autofilter Range = 1
  399. MIDI sound playback
  400. Change the code in another worksheet
  401. Macros: Moving data into separate worksheets or spreadsheets
  402. auto-indent in vb editor
  403. need formula for stair stepping commissions w/ diff %per step
  404. how do I...
  405. Opening Powerpoint from Excel and Word
  406. Macros: Copying from different document, saving in multiple forms
  407. reset "on error resume next"
  408. Need "grep" like function to search multiple workbooks
  409. Excecl VBA: When a Dialog Appears that requires you to press "OK"
  410. Problems with .find code
  411. Select Case Statements
  412. Menu Restoration
  413. Prevent macro calculate if text in the range
  414. When a web query fails.
  415. export Hyperlinks
  416. Deleting the empty rows in Excel
  417. Enter Range value and get report
  418. UserForm - Disable the 'x' button
  419. Cannot find file - code error
  420. VBA code ok in Excel 2003, but crashes Excel 2002 & 2000
  421. Dos command
  422. "Using A Variable On Several Sheets"
  423. Need look up of month to get total for the month
  424. Error 59 Bad record length
  425. VBA code for tab exists
  426. Macro or VBA process varible row data
  427. Macro to find and replace text in a worksheet
  428. send mail on value
  429. How Change Powerpoint Embedded Chart Values?
  430. Merging Column Data
  431. array structure
  432. Changing the From: in an email
  433. Posting Recordset to SQl Server
  434. How do I stack columns?
  435. updation from another workbook
  436. insert doen"t work: version 2
  437. My VBA Script
  438. Drawing a Circle if a different cell has data
  439. Slow generation of Word Documents
  440. Excel 2007 slow saving with defined names
  441. combining subtotal(9,) with an array formula?
  442. Delete Rows with Autofilter and partial cell.
  443. Open .xls files listed in .txt file and generate report
  444. Hiding Pivot Table Wizard
  445. AVERAGE / STD of groups in a table?
  446. Sum of 15 random +/- integers always greater than or equal to zero
  447. Paste formula into macro
  448. Format "0000"
  449. insert doesn't work
  450. Change username for file transfer
  451. Stop (halt, break) my vba code please...
  452. For next loop and copy and pasting VBA
  453. autofill empty cells with a macro in excel
  454. forecast using Pivot tables
  455. MultiSelect ListBox Help
  456. RE: Logical test
  457. #VALUE when trying to sum numbers
  458. how can I make a macro prompt for a portion of a file name?
  459. Compare 2 sheets and copy matching data
  460. Excel Interop with in-memory document - no file system
  461. Modified worksheet macro, where if Yes portion works but not else
  462. copy,switch,paste,erase
  463. identifying PivotTables
  464. Error proof way to find first blank Row after Autofilter Range
  465. Doing a copy-paste offest between 2 workbooks
  466. adding comments to a cell and not using comment box
  467. VBA Cut and paste into other workbook
  468. Using Readpast to skip records
  469. printer trays
  470. Code to open Notes database and find a specific doc
  471. debugging and programming
  472. Click Event
  473. Excel VBA - SQL to .dbf date problem - GETTING DESPERATE
  474. copy cell to next open line
  475. Worksheet Speed
  476. Run program between 2 separate excel sessions
  477. Conditional formatting
  478. Slow Macro
  479. Message boxes
  480. How do I change a Worksheet_change event to a beforesave event?
  481. cannot see the error line when error message appear
  482. Absolute beginner
  483. Delete Rows based on not existing in range
  484. Run Business Objects Report from Excel using VBA
  485. My VBA does not work!!
  486. Unable to set the Display Alerts property of the application class
  487. Message box & close worksheet
  488. Messagr
  489. tom igilvy\gary"s student\mike h....
  490. Custom Sum Function
  491. VSTO 2003 and 2007 Add-ins
  492. batch hyperlink
  493. Get info from a file that is already open
  494. Copying ranges to various locations
  495. Compatibility Checker causing headaches
  496. cell.find not working
  497. How to hide toolbar automatically when I switch to other worksheet
  498. How to stop VBA in a Loop
  499. Create Outlook event/appt in non-default calendar folder
  500. Use formula from cell in UserForm?
  501. copy and paste values
  502. Assign number to autoshape
  503. Rounding Problem
  504. Imported and Manually Entered Data
  505. Write/Paste RTF or HTML string into one cell??
  506. Msgbox preventing workbook save
  507. Update/Refresh Sheet?
  508. option button and userform question
  509. Finding cell matches
  510. How Capture Cell Value Before Change Event Fires?
  511. Please help with db query
  512. run an OQY
  513. tom ogilvy\gary"s student....... pls!!!!
  514. RTD Real Time Data
  515. Copying Named Ranges based on ListBox Results
  516. Comparing dates
  517. Right click Drag and Drop context menu
  518. Call API from vbscript via excel.
  519. Call API from vbscript via excel.
  520. Call API from vbscript via excel.
  521. Userform comobox equal to first 3 digits in a cell
  522. Pausing a Macro awaiting user input
  523. Copying data from a network file - many problems
  524. Excel Suspend / Resume Layout
  525. object variable are not set error
  526. Excel Used Range
  527. seek next line (more detailed desc)
  528. Excel Drag and Drop
  529. Unable to call Command Button's Click() method from a different sheet
  530. personal.xls
  531. functions in 'personal.xls'
  532. ActiveCell.Formula to equal a specific cell
  533. make a combo box repeat for entire column?
  534. Match Entry Complete for Data Validation
  535. disable toolbars
  536. seek next line
  537. Font Information for a cell with multiple color and size
  538. Formula - Dynamic Range
  539. Counting Or Summing Autoshapes?
  540. Excel template behavior
  541. Listbox MatchEntry Property
  542. Hyperlink Copy
  543. Inserting Row(s) After Finding A Match
  544. importing XML files
  545. Excel 2003 in a WEB SERVICE - would like some input :)
  546. Excel 2007 Weird Image problem
  547. Looking for a Macro to erase particular rows in a given pattern
  548. application.match with multi-dimensional arrays (syntax request)
  549. Macro that will run from Excel but act on Excel, Word & Access
  550. SumbyColor Function
  551. Error Message regarding .TextFilePlatform = 437
  552. Automatically Answer Prompts
  553. Updating Macro File
  554. Auto Update Formula Rows
  555. Recalculation problem
  556. Mirroring worksheets
  557. Excel 2002 and IE7
  558. _filterdatabase
  559. Dates In UserForm Textboxes
  560. updating formula when a worksheet is added
  561. Convert a range t ype to a string type
  562. Last Column and Last Row
  563. Automatically Turn on Normal text to hyperlink
  564. how to covert numbers into text
  565. Cell colour doesn't delete
  566. Mail one sheet from Excel without using a new workbook
  567. textbox issue
  568. Help deleting fields in SQL table
  569. Macro to Check Two numbers and insert a line
  570. vba code - help
  571. Macro doesn't capture all data
  572. pop up memo on a user form
  573. Setting a variable to range of cell values
  574. induce sleeping time
  575. Copying ranges
  576. Urgent help on plotting a X,Y graph...
  577. userform combobox questions
  578. Validate Entry
  579. Retrive Records in UserForm and Edit - from shahzad
  580. Sort Excel objects by their creation order
  581. Printing several worksheets as on page
  582. CopyFromRecordset method
  583. pause/re-run macro to enable DDE updating
  584. Togglebutton to change Checkboxes
  585. Counting Cells which have Bold & Red Strike Effect Through Conditional Formatting
  586. Nested if statement and vlookup problem
  587. Conditional Combo Box Fill
  588. Excel Convert Multiple Rows into Multiple Columns
  589. How do I create a computer admin'd multiple choice test in Excel?
  590. Grouping Date Data in a Pivot Table
  591. SUM formula for data from one column when another is populated
  592. How to sort pivot table by Data Items
  593. copy from sheet 1 to sheet 2 values
  594. How do I check if a cell has a dropdown
  595. Help Improving VBA to update Chart Formats
  596. Scroll bars in a user form
  597. How to select named range list dependent on another selection
  598. Load text file into memory for searching?
  599. .selection.find not working via automation
  600. vb Command seems simple but...
  601. How to add data into a text file without overwriting existing data
  602. How do I remove a UserForm from a workbook?
  603. Macro loop problem
  604. How to Construct a Formula Based on Text In Changing Cell
  605. Hanlde "New Workbook" Task Pane Events
  606. Screen Flashing
  607. Complex Copy/Print Macro
  608. Truncate value of a cell
  609. Transferring data from one worksheet to another automatically
  610. Print_Title start in middle
  611. XLS 2007: Icons or Colors in a dropdown list ?
  612. Duration problem
  613. Delete an entire row if a selected row doesn't have a specified value in a cell
  614. Insert Picture Into Form
  615. How to Autofill HTML code into Excell spreadsheet
  616. UserForm
  617. Find all 6/1/2007 in the Workbook, Sum Corresponding Dollar Figure
  618. UserForm help
  619. Excel 2000 Opens, but spreadsheet cannot be seen
  620. Scroll bar (control) doesn't scroll!! ???
  621. XLL Internittently Fails to Load
  622. How to submit data from one sheet to another with a macro and butt
  623. Splitting Excel file into many workbooks
  624. Refedit Retaining Focus
  625. Macro to cycle through worksheets
  626. Personal marco workbook
  627. How do I exchange data between worksheets?
  628. Getting special formatting to apply to all worksheets
  629. assign formula to a cell
  630. Relation between hide(orunhide) and protect
  631. How to generalize sorting range in macro???
  632. Jagged arrays - Cannot Define with Arr1()() as integer = New integ
  633. How to select all sheets in front of a particular sheet???
  634. Creating Excel Documents from Scratch.
  635. Does excel macro automatically enter data by date?
  636. How to obtain cell address of a succesful VLookup?
  637. How would you set this up?
  638. Removing Hotkey Assignment
  639. Problem with a function that accesses dll's
  640. Class modules Custom initialization Line
  641. vlookup, change aray if
  642. Hanging Instance of Excel
  643. Columnheads...
  644. Macro terminates upon opening text file
  645. Creating Server Certificate for Excel Macros
  646. Open Access Macro, then put a value into a parameter field
  647. Getting a reference when a value is less than 0
  648. Adding a Button
  649. Project or Library missing
  650. Multiple range selection issue
  651. Form/Module Code Question
  652. Excel Macro - Speed increase suggestions needed.
  653. Cell Colour depending on Value in Range
  654. ODBC Connector Help
  655. clearing an advanced filter
  656. Delimit using 2 spaces instead of 1?
  657. Set Errors
  658. WorkBook_SheetChange for non-Active worksheet
  659. Issue Recalculating VB Formulas in Excel 2003
  660. Date Selection
  661. Testing for Valid Macro Name
  662. User form question
  663. Code for searching & copying Text from 1 text file to another
  664. Print Preview XL2007 still not working properly
  665. Return Column of Found Data
  666. Digitally Signing Excel/Word Macros
  667. How to count number of Cell have Strike Through Effect & Bold as font style.
  668. object invoked is disconnected from its clients
  669. Clear content of textbox in userform
  670. Using Application.Inputbox with shapes
  671. VBA that finds the bottom of the sheet
  672. VBA to find the bottom of a sheet
  673. Saving a File to a Name That Already Exists
  674. Web Site Lookup
  675. Find last row in a column
  676. To let us choose the file
  677. Protecting the code using code
  678. Command button error
  679. Conditional format : return to default format
  680. {=max(if(........))} Array Function not working after range length of $A1:$A339
  681. RE: UDF
  682. Number format of textbox in userform
  683. Linked Tables Dilema using Excel 2000
  684. RE: How to define a range using variables
  685. How to define a range using variables
  686. character limit in formula
  687. Re: UDF
  688. RE: UDF
  689. UDF
  690. select instruction is not able to work with a sheet
  691. How to streamline this macro
  692. Start reading text file at line 3
  693. Fill in formula with dymanic address
  694. Editing multiline textbox
  695. Problem with and Excel Add-in installing on customer's machines
  696. Conditional Formating for Time Sheet
  697. combine rows of data to one row...tough one
  698. workbooks.open - another option
  699. How do I remove the ' from the begining of value in a cell
  700. Textbox
  701. Merge csv file from many folders
  702. Make a Zip file from Excel
  703. Automatic Population of one Column
  704. VBA print character on chart
  705. IF Function testing a range and a cell
  706. Signing VBA Project Using VB.NET
  707. Format a Double to have one decimal place number?
  708. How to stop a msgbox pop up from another workbook
  709. Monthly Total report based on 2 or 3 criteria. VBA or Formula
  710. excel programming
  711. Array in VBA
  712. Organizing Information Using Excel Macros (or any other solution)
  713. IF FORMULA....
  714. Excel Progress Bar while Calculating
  715. Createobject for FTP
  716. How to create a function that fills the current date in an adjoining cell
  717. List AutoFilter Changes to "All"
  718. Data from Worksheet to Worksheet
  719. VBA put number on bar chart
  720. Date Range (Starting & Ending Date) - syed shahzad
  721. Order of Files Opening
  722. unhide columns in named range
  723. Setting up a way to track accountability and where they are going
  724. List AutoFilter Changes to "All"
  725. set of numbers ranging from 0 to 240
  726. access internet through VBA
  727. Find string in Data
  728. Design a Form for Excel
  729. Delete worksheet in collection
  730. Soap problem
  731. How do I compare 1 excel file to another and save what is a match
  732. What is default property of name object
  733. Deleting Rows based on hierarcy
  734. Opening a .pdf file with Adobe Reader 8.0
  735. Project Still Open When Workbook is Closed
  736. Need a program that gets excel file's name and deletes the first row.
  737. Excel Macro
  738. VBA to find the bottom of a sheet
  739. Macro to copy data
  740. Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet
  741. data structures
  742. Excel QueryTable Refresh Causes "Choose Profile" Dialog to Appear
  743. Grouping Date Data in a Pivot Table
  744. reference disappear
  745. Check box in a text box?
  746. delete spaces
  747. Importing large text file ERROR
  748. If statement and exit macro
  749. insert a row when theres change in a row.
  750. Automate cut paste