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 to copy and past a new row when the a row is filled in.
  2. Excel Lookups
  3. Combining Text in Columsn
  4. Excel cannot find file error
  5. Worksheet Protection
  6. Changing Formula References
  7. Manual Autofilter works, but recorded Macro does something else
  8. UNABLE TO PUT IN A LOOP
  9. Dumb Question
  10. Update remote worksheets
  11. Cut and Paste from Collection
  12. finding empty cell and enter data from right to left
  13. Get value in last non-zero value cell in column
  14. Assistance required
  15. Trying to activate/Select Sheet using the name stored in a variable
  16. Exporting data to EXCEL
  17. Worksheet Change Event question
  18. highlight locked cells
  19. Excel programming errors for copying and pasting
  20. Histogram Invalid Reference
  21. Macro execution speed in Office XP/2003
  22. Auto fill today's date
  23. find data in another workbook
  24. How to make the first cell in autofiltered list the activecell?
  25. DISABLE FORMULA BAR
  26. Imports Excel = Microsoft.Office.Interop.Excel doesn't work
  27. How to determine whether a protected sheet has a password?
  28. IF STATEMENTS FOR THE FOLLOWING RULES
  29. Input boxes
  30. Absolute reference
  31. Unselect shaperange object after drawing it with VBA?
  32. Can anybody help to fix this please ?
  33. Loop, Compare, Match & Total
  34. Cell Color
  35. Rounding 0.5 to 1
  36. Object Required Error, Excel 2000 & 2003
  37. Hide the X on a user form
  38. Shared Workbook
  39. compile error ADODB connection setup
  40. How can I run an Excel 7 Macro every 15 minutes?
  41. Need to sort text data to consecutive cells (w/ Macro?)
  42. default form behavior
  43. Workbooks Open = different result than actually opening Workbook
  44. Unable to write to a cell
  45. lookup source can vary -- how to code?
  46. Delete a worksheet
  47. If Search that Exits Sub or Ends If
  48. Creating a summary sheet
  49. Worksheet Row/Column Boundaries Question
  50. Union of possibly empty ranges
  51. CHOOSE & VLOOKUP; Weird Behavior
  52. Using a ComboBox Control in Excel
  53. For each File in Folder, open?
  54. CTRL-BREAK Mac
  55. Date Removal
  56. Select Printer Based on Criterea
  57. Copy&Paste variable range based on cell value
  58. Loop backwards through selection?
  59. Setting page length to 60 lines? (How do?)
  60. Count last non blank column and apply to formula
  61. VB Question re: text box entries
  62. HELP CANNOT MODIFY BUTTON OBJECT OR SEE ITS PROPERTIES....
  63. Find and Replace Question
  64. Getting formulas to stick during sorting
  65. assumption issues....
  66. Hide Rows using a returtn value in a column
  67. number of workbooks less 1
  68. Autoword Select
  69. Copy a Cell from worksheet to worksheet
  70. looking through entire sheet
  71. Excel Pivot Question
  72. Selection.Copy issue
  73. Cell value
  74. Inconsistent results with Query
  75. Please help -Columns Array in SubTotals
  76. VSTO HRESULT
  77. Adapting VBA Code
  78. After Update
  79. Error on ActiveWorkbook.SaveAs method
  80. error 438 on For statement
  81. Password style character masking
  82. Populate Combobox
  83. Help in code Steve G wrote to move data from 4 columns to 21 columns
  84. Union Function
  85. Copy data from Excel to Internet Explorer
  86. Start Up Functions
  87. How to Add or Manipulate Groups of Multiple Rows
  88. macro for adding copy of worksheet
  89. How to check a printer's availability
  90. 2 comparison operators in select case at same level without loss in precision
  91. repeating macros
  92. I want to create a Summary Work Sheet...
  93. Late Binding/Object Library Probelms
  94. Import txt file via makro
  95. (repost) Adding hyperlinks to VBA-generated worksheets
  96. How to make Combo Boxes not duplicate options
  97. Highlight blank cells
  98. Back door into locked form
  99. R/T error 40036
  100. security warning
  101. Link Excel with SAP MIS
  102. text Formula
  103. Change "-" from right first character to left first character to make a negative amount
  104. Go back to the cell that I started from
  105. macro to look down cells and if negative in the right of the cell change to left of the cell
  106. Very Unusal Question
  107. UK Floods
  108. VBA to highlight cells
  109. Locking majority of cells on a Worksheet
  110. Generate sheetnames and skip cells?
  111. I think this is difficult - can it be done?
  112. Changing Cell Properties Interfering with Clipboard
  113. Calendar Problem
  114. Error when code runs
  115. Need "Filename Equals" code help.
  116. Goalseek - loop range
  117. compare cell valeus and highlight row
  118. paste values from an array to a range
  119. Pull Out Numbers From String
  120. "Document not saved" error after typing a line of code in Excel VB
  121. macro to highlight rows that meet specific conditions
  122. I need this to copy only the range that has "Yes"
  123. HighlightChangesOptions and HighlightChangesOnScreen not saving?
  124. Problem sorting data
  125. ADODB.Connection not displaying when defining a variable
  126. New Window When Workbook is opened
  127. Calculation Satus for a Sheet
  128. Named Range COUNTA fails when 1st record deleted
  129. searching for slashes "/" in cells
  130. How do I remotely overwrite existing sheet with a new one
  131. Trying to close without the message do you want to save
  132. Permanently Attach Custom Toolbar?
  133. VBA Code needs to check for Shared Workbook
  134. Multiple goalseek - pls pls help
  135. Creating a custom Commandbar
  136. Calling a Stored procedure on SQL Server asynchronously
  137. Concatentating Multiple Worksheets into One
  138. MSForms 2.0 Combobox problem
  139. Macro to autofilter current month
  140. Returning the name of a chart
  141. Save workbook versions
  142. Macro Question
  143. Bring up the "find and replace" window
  144. I wnat to copy several Worksheets, Several Times...
  145. VBA Macro Issues after 2000 to 2003 upgrade
  146. Conditional Formatting Formula propogating incorrectly
  147. Public Variable - not defined?
  148. join/union tables by querytable
  149. Adding hyperlinks to macro-generated sheets from list of sheet nam
  150. Assigning Macros
  151. Unable to run the macros
  152. BeforeSave event problem
  153. Creating a Report
  154. How to run a macro upon a cell click
  155. Excel VBA Range Selection Error
  156. Hide Worksheets, Excel 200 & 2003
  157. Open "Function Argument Window" using a macro
  158. toolbar/ribbon hide/show macro
  159. Sort Worksheet Tabs
  160. Changing chart plot formulae automatically
  161. Excel VBA Drop Down boxes
  162. Userform help needed
  163. Multiple Goalseek - Range
  164. Exercise with Incrementing Years
  165. Macro to change sign on text file imported to Excel
  166. macro to delete spaces doesn't compile
  167. Finding a value in a table based on two drop menu inputs
  168. Replace information based on existing information
  169. programme error
  170. ActiveSheet.OLEObjects.Add resets globals to Nothing
  171. programme error
  172. Calculate Subsets with Specific Criteria
  173. A problem with cells name in a copy/paste process
  174. Automatically Update Delimited/Comma Seperated File .
  175. displaying "week of July 29, 2007"
  176. very hide
  177. VSTO 2005 Excel Addin
  178. Can you "very hide" a workbook?
  179. Manipulate textfile with VBA
  180. Find all possible combinations of unique letters
  181. Retrieving Data Range for Chart
  182. Issue with UDFs in Personal Addin
  183. calculating vacation
  184. Delete duplicates - Problem
  185. Need Help with code to "Paste into next available row"
  186. Another Newsreader Question
  187. Declaring Multi-Dimensional Arrays
  188. Vlookup in Userform - XL2003
  189. Macro works, then doesn't
  190. How to Undo Makros
  191. Get WorkSheet Name fails without a reason
  192. Script problem on excel spanish version
  193. Lost focus of UserForm
  194. Grab Data Validation selection instance without using Worksheet_Selection_Change Event
  195. return filename
  196. Problem with For Loop
  197. More Conditional Formatting Woes
  198. Disappearing Modules
  199. Automatically Update Delimited/Comma Seperated File Options
  200. Runtime error 9 - Subscript out of Range
  201. Excel Save as & Exit macro
  202. How can I check to see if there is a vertical break?
  203. Reading Email from Excel
  204. loop and vlookup
  205. Compile data on multiple sheets.
  206. vba offset program
  207. average and format range
  208. Checking for CR/LF in text file.
  209. macro to find based on multple criteria & perform a calculation
  210. XSLT XML Mapping Excel "Map Each Element" "XML Source"
  211. Run verb, macro with arguments
  212. Urgent! group objects in Excel
  213. Change of table name in access where Excel obtains pivot table inf
  214. cell size to page break
  215. Wildcard in SUM
  216. file losing shapes and format
  217. How all top level elements of XML into a Worksheet
  218. Populating a multi dimensional array
  219. Control how an Excel file is opened
  220. Display "week of July 29" in Excel
  221. Wanting to Learn to Write Simple Queries
  222. Print Causes Sheet Performace to Drop
  223. custom menus
  224. Missing Sheets
  225. multiple pages
  226. Color Cells by macro NOT conditional format
  227. Modify Scroll Bar Control Properties
  228. How can I convert a checked checkbox in a cell to text (True) in E
  229. trying to get out
  230. VPageBreaks.Count Refresh
  231. Export From Bookmarks To Excel
  232. Excel 2007 multiple Web Query problem! URGENT!
  233. Find/Replace XLThin Line with XLHairline
  234. Use Input Box to Name Adjacent Ranges
  235. Find duplicate values in column K then compare cells range of dups
  236. library set up
  237. Can any MVP take this up and help me??
  238. average of array element
  239. Urgent!!!
  240. Help with Right(Me.ListStoreIP.Column(0), 2)
  241. Paste into next blank row in a different worksheet
  242. Loop Macro
  243. Specify a target range in Function arguements
  244. Insert Symbol from Wingdings
  245. Why does this loop only NEARLY work?!
  246. Complex Pivot table formatting
  247. Using Like Statement in Select Case
  248. Error Msg: Can't open anymore databases
  249. How to "clear" all previous ShortcutKey Assignments
  250. How do I use R1C1 Reference Style in a Macro?
  251. Excel 2003 - Weird behaviour in VBA editor
  252. Copy Hyperlink from one cell to another using excel programming
  253. Auto start Function Wizard
  254. trying to use sum with range & offest
  255. problem inserting pictures in excel 2007 using macro.
  256. Excel Alarms
  257. Reversing cells
  258. Help with Arguments
  259. validation for three input fields
  260. Range's Address: How To Change via VBA?
  261. Combobox - MatchRequired does not work?
  262. New to macros
  263. Searching: Many variations of one word
  264. Fastest way to store each word in a cell in a diff variable
  265. Range ("1:7") With Variables?
  266. opening folders within a folder
  267. List Active Macros?
  268. Macro Code Help
  269. Vlookup probelm
  270. LOOKUP Function
  271. Move active cell?
  272. VBA "1004" error when .Refresh BackgroundQuery:=False
  273. Stop a workbook from Opening
  274. Microsoft Tips and Tricks for beginners
  275. Standard Page Layout
  276. Newsreader Set-up Question
  277. Nothing Happens
  278. find next NOT empty cell in column
  279. Excel 2003 - Wizard Template
  280. EXCEL: REMOVING A SPECIAL CHARACTER IN A STRING OF ALPHA/NUMERICS
  281. Step through a range?
  282. chart name
  283. Transpose macro
  284. excel graphics
  285. how to remove cached results in excel
  286. Creating a Table within a UserForm
  287. Reading current opened Excel book(file) into streams
  288. spreadsheet control
  289. How can I make Excel give me a warning message?
  290. Background refresh not working
  291. VB Code to determine if a Column has data
  292. Calling Subs in other WB
  293. select a cell with specific value
  294. IRR DLL
  295. stock returns/average/formatting
  296. Can we disable main Office button in Excel 2007
  297. How to disable the insert worksheet(Shift+F11) icon in 2007 using
  298. Get Button Info/Location in when its clicked and pass to macro
  299. Get Button Info/Location in when its clicked and pass to macro
  300. Pivot table field list sorting
  301. Hyperlink is staying with cell when data is moved
  302. Programmatically insert a graphic?
  303. Add color variable to bubble charts
  304. add a timer to my template
  305. Craeting a relatively complex macro - need help - looping
  306. Opening Access Only Question
  307. Column/Row Indicator
  308. Can't delete forms using code
  309. Saving One Sheet as One Workbook
  310. Finding text in a selection
  311. Google Getting Flaky?
  312. define names in excel
  313. User Defined Array Function
  314. VB code for following lookup, thanks
  315. Compile error: Method or data member not found
  316. I've misplaced a macro <g>!
  317. How do I display the ASCII code of a key
  318. To the demigods of SUMPRODUCT, HEAR ME!
  319. Turning on TrackChanges in Excel 2003 from c#?
  320. MaxVal InCol "or" Compare Cells InCol Highlight Max
  321. Excel Programming/Visual Basic Training Course
  322. ComboBoxes in VBA
  323. Is this possible?
  324. Pro grammatically Inserting data to Excel Sheet
  325. Running a macro based on cell value that is updated by formula
  326. Why is this loop not working?
  327. Cycle and Count
  328. Columns(i).Hidden not changing
  329. Splitting a cell in a macro?
  330. select fields names with "dot"
  331. Pivot Table problem with MissingItemList
  332. Simple Macro?
  333. access data from a closed wb protected with password without openi
  334. Test a named cell in a macro
  335. How to enable macros automatic?
  336. PasteSpecial xlPasteFormats
  337. Find char in string and mark
  338. EXCEL 97: Can anyone check slow execution??
  339. Sheet Change Event (Insert Row)
  340. (repostex2) Code to refer to 6 pivot tables on same sheet
  341. Control Excel from Word
  342. Comparing Object References
  343. A question about Trusted Publishers...
  344. Can sounds be played when cell value changes?
  345. RegExp - String in VBA
  346. Remove space from text in cell
  347. for the change that change event cant detect
  348. Programs hangs when deleting elements with ADO DB and Oracle
  349. VBA Runtime error 14: Out of string space... help!
  350. Userforms, selection based on sheet and password
  351. Excel links
  352. How to assign value back to a dropdown combo
  353. Merged cells & column widths
  354. sumIf
  355. Help with Formula needed
  356. If Statement
  357. Pivot Table custom formating & user changes to selections
  358. Google Earth Placemark: Film Director : Suyash Raj House's.kmz
  359. Opening & Reading file in notepad then pasting into excel using VBA
  360. How do I add a web reference in VBA in Excel 2007?
  361. inactive sheet clear content
  362. Automatically Update Delimited/Comma Seperated File Options
  363. Change Location of VBE References with VBA
  364. Hide Folder Macro
  365. Please help...formula problems
  366. Formatting cell backgrounds based on cell contains
  367. Convert "" to real blank cell
  368. Can you handle another SORT problem?
  369. DataGrid Control OCX and other files?
  370. Sheet Insert Row Event?
  371. Digital Signature
  372. Merging styles
  373. Pop-Up Dialogue Box/check boxes/deleting worksheets
  374. column offset problem
  375. Invoice aging - custom function
  376. Insert Excel Object in MS Word
  377. Novice's Question re Chart Programming
  378. Generating a new workbook from two separate but similar ones
  379. ?? Create a Public SUB with an array as parameter. ??
  380. How to disable the "ESC feature" of a ComboBox?
  381. Best Way to Share Custom Buttons?
  382. Practice Math Problems
  383. Copy Workbook
  384. macro to divide by zero
  385. TrackChanges differences between Excel 2003 and Excel 2003 SP2??
  386. Expiration plus permanently activating by key
  387. Calendar Control
  388. Send data to a specific worksheet in a closed Workbook
  389. James Latham or someone else who can help
  390. Don't Replace existing Cell
  391. If Statement help
  392. Quick question
  393. macro populated sheets is very good yet something i may miss here.
  394. UserForm ComboBox
  395. Range.Average Problem
  396. Keep Text Together
  397. Stop TextBox Clearing Cell
  398. How to override a hyperlink
  399. alpha character not populating in DBA table
  400. Email Worksheets---Please HELP
  401. How to call "Hide Comment" from VBA???
  402. Need to create function to find first day of following month
  403. Shortcuts for toolbar buttons/view code of toolbar buttons
  404. Shortcuts for toolbar buttons/view code of toolbar buttons
  405. Format Tel Number
  406. Selecting Various Ranges
  407. Formula Help
  408. mismatch error
  409. DateDiff ("m", StartDate,EndDate)
  410. Autorecover
  411. Finding the difference between 2 times
  412. Best method for form distribution and data collection
  413. excel tp pdf
  414. combining operators
  415. VB code to copy a row with absolute cell ref and also relative cel
  416. Excel Macro to copy, paste and then update web queries
  417. Text in Web query truncated due to < and % symbols
  418. Macro runs slowly only on new laptop
  419. Adding a value in the comment field (little red triangle)?
  420. Error 6: Overflow 32767 Rows
  421. String with Cell Reference
  422. Attach reference/ library to file sent to users
  423. hide rows with zero balance
  424. Getting a the position of a single item in an array
  425. Setting Range by calculation
  426. Percenatge Format in TextBox
  427. How do I activate the first worksheet?
  428. information box
  429. Conditional Formatting Strangeness
  430. Select specific # of rows below selected cell - please help
  431. Record user actions in VBA script
  432. dynamic charts- Naming problem and ....
  433. using macros to chart data
  434. Copy Cell, Paste based on a match.
  435. Calling a Sub in a Worksheet
  436. Apostrophe problem
  437. add "paste values" to right click menu
  438. Button needed in worksheet to invoke word doc with linked values
  439. Very Minor "Cosmetic" Question
  440. OpenText method
  441. Clearing listbox
  442. Sorting Problem
  443. Appropriate Object To Hold Memo-Sized Text?
  444. Using VBScript to list all folders in a directory and files ...
  445. (repost) Code to refer to 6 pivot tables on same sheet
  446. Page Break: Format Row
  447. Set other worksheet range --- runtime error 1004
  448. Find function bypass
  449. Adding References using VBA
  450. .txt to .csv
  451. Storing numbers in text fields
  452. how to add Hyperlink in list box
  453. how to add hyperlink in list box
  454. Map drive to open a file with code
  455. Copying data fram a number of excel sheets to one sheet
  456. FileCopy Question
  457. Problem updating nested IF statement results
  458. Pivot table/summary for multiple sheets
  459. Sorting Issues!
  460. selecting a specific excel instance
  461. generate Odd row numbers in VBA
  462. Comment that won't go away
  463. Add picture to Excel without using file system
  464. Hidden File Extensions generating errors
  465. VB code to set VBA References
  466. Active x Initialise prompt
  467. code to go down a column and find the last cell with data before an empty cell
  468. Import data "Hangs", A "time out" is needed. Help! :)
  469. variable declaration
  470. Attach a formula to a word.
  471. Parse a date
  472. How do I refer a macro on a new sheet i just created?
  473. hide/unhide
  474. Can I write a function like matrix function?
  475. ComboBox RowSource
  476. Need excel formula to calc time i.e.08:29:29am-23:21:32pm=9:07:57
  477. retrieve a picture
  478. writing in vba
  479. Copy row/column size, print area...to other tabs
  480. Run-time error 1004
  481. To choose several sheets for synchronizing
  482. WHAT COULD BE THE REASON FOR VB SCRIPT REGULAR EXPRESION TO WORK O
  483. Formula using one out of five cells from the other row
  484. Print specific pages of a Database
  485. How to create a new worksheet from a template?
  486. internet connection via excel macro at timed intervels & save data to excel file.
  487. Imbedded buton to run macro?
  488. Can a variable be used when declaring an API call ?
  489. Can't get save as to work
  490. Can I evaluate a function parameter(string type) as VBA souce code
  491. VBS/VBA difference
  492. Automatic Solver
  493. Pivot Chart VBA Reformat
  494. Is it possible to put two different validations into one Cell or a workaround
  495. Attach Macro to button?
  496. Vba tips and help
  497. WHILE AND FOR LOOPS
  498. date stamp based on word input.
  499. Date Format Thingymabob
  500. Macro to delete rows with cells less than user-inputed time
  501. Can't find project or library (Mid Function)
  502. Run- time error 1004
  503. Confusing Runtime Error
  504. linking buttons
  505. find first empty cell in column and start transpose next row in that cell
  506. Validation
  507. different sheets (ledgers)
  508. conditional query
  509. CREATE AN EMPTY ROWS
  510. Opening Access database
  511. Special Control Needed - Please Advise
  512. problem column (B)
  513. SQL Insert Statement to return "13620 row(s) affected."
  514. Rename worksheets of workbook - Error code
  515. edit combo boxes
  516. Column Width for Each Column
  517. optimized way for copying formats and values
  518. Blank Cell
  519. QueryTable Null Import Quirk / Problem
  520. rs.filter "Filter cannot be opened"
  521. RefEdits
  522. VariantType.Empty error
  523. Combine two worksheets into PivotTable
  524. Disconnected Range to Variant
  525. Set worksheet range ---runtime error 1004
  526. first go around inputbox
  527. (Tom?) Pivot tables, code to refer to all pivot tables on template
  528. Keyboard shortcuts for COM Add-ins?
  529. Data validation on multiple worksheets in the same workbook
  530. can somebody pls. look @ this idea & tell me if it's possible?
  531. adding cell comment via VBA (bold font?)
  532. How to know get the color index for the conditional formatting?
  533. how to perform regression in excel
  534. VBA: cannot figure out code
  535. ActiveX Control Return Keypress MsgBox Loop
  536. adding RTF control to Excel 2003 forms?
  537. Populating listbox with only one data
  538. Retrieving Data From JET Back End
  539. Code Works on Windows 2000 but not on XP
  540. I want to Split & save the data in different workbook
  541. Call user form from ThisWorkbook; close file if form closed
  542. Is possible to automate Trust Acces to VBProjec Object option?
  543. F9 breaks Shift-F9 for XLL functions
  544. Possible to have only one value in a listbox
  545. UDF returning a 2 dimentional array
  546. HELP!!
  547. Calculating Only Visiable Data
  548. Help with Formula
  549. Macro to activate cell
  550. end if without block if
  551. VBA Function running order
  552. inputbox syntax location
  553. Move form results to next blank row in diff worksheet
  554. formula with two different variables
  555. Importing Comments From MS Access DB: Cell, TextBox object, or something else?
  556. Last column
  557. How to check the existing of a printer?
  558. Can Excel VBA search for and read URL
  559. pop up box
  560. Excel Automation Add-in #NAME workbook corruption
  561. What is Enterfieldbehavior
  562. Export rows to new sheet based on value from list of cells
  563. countif/sumif question
  564. Spell Check ignore repeats
  565. formula needs modification
  566. Detecting When User Deletes a Sheet
  567. An error causeed by printing interrupted
  568. Carriage Retunr in the Caption property of a CommandButton control
  569. Re: Progress Bar - Help needed
  570. InputBox: Separate CANCEL and 0
  571. How to unprotect target xls-sheet in VBA using advanced filter?
  572. Help with Formula
  573. problem with VBA web query
  574. Duplicate in A copy value in B (loop?)
  575. Help with Formula
  576. Class Module vs Normal Module
  577. CodeModule not saved when created through automation.
  578. multiple ledger
  579. Loop to determine number of rows range
  580. Alarm timer in Excel
  581. how to get the first used cell position in VBA?
  582. .RowSource by row range
  583. Re: "compile error in hidden module"
  584. Multiple web query
  585. statusbar indicator for progress of macro running
  586. opinion on code / formula reiult
  587. Two CSV file data to new excel file
  588. Problems with the IsNa Function in VB
  589. Pivot table dialog boxes
  590. Tracking Time of different city in comparision to Indian Standared Time
  591. Tracking Time of different city in comparision to Indian Standared Time
  592. Guidance on automating the creation of Excel files from Excel
  593. Excel Macros with Forms
  594. ribbon
  595. Arabic Dates - special feature!
  596. Comparing Columns of Text
  597. Need Help with AutoFit and Blank(Null) Cells
  598. script runs but doesn't delete
  599. Changing path for import file
  600. Plain English Please
  601. why "..." would interpret as "?"
  602. Need code or just guidance!!
  603. how to interpret "ALL..." as text
  604. PUBLIC APOLOGIES
  605. Supressing the ctrl-c and other keys during word automation in automation
  606. a column got changed and now the macro doesn't work
  607. Supressing the ctrl-c and other keys during Word automation in aut
  608. Determing if user input is on list in Combo Box
  609. combo box help
  610. add formula next to corresponding cells
  611. Udf resets on 3rd workbook
  612. 2 Excel "truisms"
  613. Changing the name of the workbook when sending it in email
  614. Macros and Toolbar
  615. Linking combo box and spread sheet
  616. Automatic names in workbook
  617. OnTime Application Newbie Question
  618. Variant Array affected by AutoFilter?
  619. Excel front-end and Access back-end?
  620. pastespecial from excel to existing word doc
  621. Insert Special Characters into Footer
  622. Hiding Objects Along with Rows
  623. Combobox showing spread sheet
  624. Replace legend with Range of Cells
  625. Hiding Blank Rows in a Range
  626. multiple dates on calendar object
  627. Loop worksheets workbook
  628. R1C1 format and variable ranges
  629. VB NEEDED TO SHIFT INITIALS FROM BEGINING OF THE NAME TO END OF THE NAME
  630. Importing external data
  631. Yield function
  632. not getting it in right place
  633. Distributing Workbooks
  634. Error Trying to add Calculated Items to a pivot table
  635. names starting with !IDX
  636. exporting from sql query results to a excel workbook
  637. Big Array from several worksheets
  638. Get range in list from combobox value
  639. Emailing a worsheet from a button in Excel
  640. Loops and Insert row troubles
  641. error 424 runtime
  642. Transpose to different sheet
  643. Information Box
  644. Import Data / Edit Data / Export Data in Excel
  645. Can this function be made more efficient?
  646. Go to last column
  647. Working with PPT files through Excel VBA
  648. landscape printing
  649. Screentip in Worksheet User Defined Function
  650. Information box
  651. help with a range
  652. Accessing Custom Doc Properties on Closed File
  653. Reuse a script to change the range to rows 1 and 3 only
  654. Help with a macro to gather information
  655. Format page border on print
  656. Interactions between Communicator and Excel causing Macros to stop
  657. Hyperlinks property return a relative path ...
  658. XL07 - How to conditionally determine Workbook file format compatibility in VBA?
  659. VBA colorscale and color #
  660. how to define a range
  661. how to define a range
  662. Mouse point
  663. Transpose problem
  664. how to define a range in VBA
  665. how to define a range
  666. Problems with MkDir
  667. AutoFill question
  668. Hope to stock data at every single update&all the sheets stocking synchronized
  669. password problem
  670. List folders but not sub folders
  671. Create list of folders
  672. Hope to stock data at every single update&all the sheets stocking synchronized
  673. AutoFit Looks Terrible
  674. Hope to stock data at every single update&all the sheets stocking synchronized
  675. HOW CAN I UPDATE DATA OF SHEET1 TO SHEET2
  676. Using custom properties
  677. Import data from Outlook 2003 to Excel 2003
  678. Current Time
  679. Ignore formula
  680. Empty/Delete Cells in a Column
  681. apply Macro to all sheets in workbook - loop
  682. How to Track Current Time of different GMT
  683. Add subtotal formula to empty cells
  684. Control search/replace dialog startup values
  685. Tracking Time Zone
  686. Getting VB List Box Selections to show in an excel spreadsheet cel
  687. transpose skip 0's and blanks
  688. How to get the path where a shortcut of an Excel sheet is located
  689. Stupid Dancing Forms Controls
  690. Help Importing using GetOpenFilename
  691. while deleting rows it finds an error - error trapping
  692. minimize workbook
  693. How do I get solver to excute more than one time
  694. only deletes first row with a blank cell in column "M" con't
  695. minimize just opened workbook window
  696. only deletes first row with a blank cell in column "M"
  697. Pulling Data From PivotTable
  698. Replacing Code with words using vlookup
  699. Outlook/Excel return code to know if Sender pressed the SEND butto
  700. script does not delete blank rows
  701. conditional formatting
  702. Naming Worksheets and Footers
  703. Array with OR condition and multiple criteria tests
  704. Sheet Tabs.
  705. Pivot Table
  706. I want to Protect VBA Code
  707. How to conditionally determine Workbook save compatibility in VBA?
  708. runtime 1004 error on deleting rows with blank cells
  709. CAN ANYONE GIVE ME VB CODE TO REMOVE INITIALS FROM A NAME AND ATTACH IT TO THE END OF THE NAME??
  710. VLOOKUP Woes
  711. Autofill macro help!!
  712. Listbox AddItem problem
  713. Macro to autofill text help!
  714. How can I print Excel worksheet to Word doc?
  715. Data logging with a DDE link and VBA
  716. Clear cell data using Combo Box
  717. delete rows with null values in "M" column
  718. Save As Part 2
  719. macro print area
  720. Sheet Tabs.
  721. delete a cell with a null value in column n
  722. replace method using ReplaceFormat .....
  723. Determine qty charged per month
  724. Help with Formula
  725. Grab PivotField Data When Not in PivotTable
  726. Formula Help
  727. Changed Linked Cell
  728. How to retrieve the activesheet of an Excel file using OleDbConnec
  729. Getting the User Name
  730. Statistical summary of bucketed data
  731. Help setting PivotItems...
  732. 2-character limit on InputBox
  733. VB Editor References
  734. Creating a series from multiple columns and (multiple) files
  735. UDF returning a 2 dimentional array
  736. Corresponding Data From PivotTable Field List
  737. slope function with matrix columns as arguments
  738. UDF returning a 2 dimentional array
  739. runtime error '1004' application or object defined error
  740. Listbox
  741. Error indexing worksheet
  742. Deleting contents from merged cells from VBA
  743. Flush Memory/Cache Clear:
  744. Help with VBA
  745. Help with VBA
  746. Help with VBA
  747. Double click item in Listbox to select item and close Listbox
  748. getURL or open
  749. Help with VBA
  750. a range of cells to UserVal...