PDA

View Full Version : Excel Help



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

  1. Moving data in sequential order
  2. automatic run module
  3. Solved: Delete Certain Columns
  4. Autofilter Field
  5. Code help: dialogue box to add a toolbar
  6. Solved: highlight same model
  7. how to close an excel file from command line?
  8. Scroll Bar/Control Toolbox/Forms
  9. making calculation easier through data organization
  10. Solved: Manipulating Activesheet Shapes?
  11. Solved: Renaming Worksheet during Copy fails
  12. Delete row based on Data in two Columns
  13. Inputbox format
  14. How to exit loop
  15. Solved: function help
  16. Solved: add data in one cell based on condition
  17. misbehaving DirectPrecedents
  18. Solved: Loop problem
  19. Auto Save
  20. Need data from another ss
  21. Multiple User sheet protection and access
  22. dynamic reminder
  23. Solved: Solver querstion
  24. Challenging project - Date
  25. Solved: Open a Web Page on Validation
  26. help: Nested function as simple as UDF, but faster in calculation speed
  27. Solved: Create duplicate workbooks based on list
  28. input same value in multiple cells
  29. Solved: Multiple Tab Data to Chart
  30. xlVeryHidden in WorkBook_Open
  31. Disable link prompt from showing
  32. Keyboard
  33. Copying active worksheet to new workbook with module to go
  34. Solved: powerpoint paste
  35. Date Update
  36. Solved: "save as" subroutine and checking for saved status
  37. Solved: Find all instances of and then count
  38. Open minimized & save report (Newbie!)
  39. Pull data from web
  40. turn formula to value
  41. Export data to new WB and Add sheets
  42. Connection String in Excel VBA
  43. Keystrokes from Office Macro into third party App (SolidEdge 2D free)
  44. Solved: How to keep number value displaying fractional value
  45. Change Focus to non-office window.
  46. Solved: Copy Range and paste it into a insert comment
  47. Looping Through an Array
  48. Relational Lookup
  49. automatically delet pictures
  50. Solved: Duplicates
  51. Solved: hide columns based on value
  52. Solved: Delete row range based on criteria in multiple columns
  53. Excel 2007- Who is Using and Is it worth upgrading?
  54. Solved: Copy entire sheet to a new workbook
  55. Date & time problem
  56. Solved: creating a summary report based on column data
  57. Removing a cell from a selected range
  58. extract text in strings
  59. Solved: Empty Cell Highlight
  60. Solved: Dos Command in excel: "COPY " & file1 & " " & file2
  61. Add sheets and copy data
  62. how to create file open dialogue box for consolidation
  63. Need help transfering data into another workbook
  64. Sending E-mail from Excel via Comman Button
  65. Test if column has only one value?
  66. Solved: Deleting Columns on Conditions Matched with an Array
  67. Find & Rename Text
  68. Working two worksheets into a third worksheet
  69. Problems with winhttp
  70. Solved: Deleting rows with odd conditions
  71. Solved: Summing Problem
  72. Breaking up a cell
  73. Excel locking up when trying to delete all cell contents or select columns
  74. What IS the purpose of "Design View"?
  75. Capturing a list of files (for email attachments)
  76. Solved: Change Powerpoint Textboxes
  77. Solved: Mapping Excel Links
  78. Set the default file path and Extract the last value in nth occurence
  79. Solved: Compatibility
  80. apply this VBA code to work in two worksheets in one workbook
  81. Need help combining two sets of code into one sheet
  82. Solved: Another Array Question
  83. Use FIND, skipping one
  84. Calculation keeps getting changed
  85. Solved: Solver in 2007
  86. Read Only to Read/Write and back again
  87. Creating a List Array for use in an ADO query
  88. Setting up an array
  89. Hide Row if cell has specified word
  90. How have spreadsheets changed your work?
  91. Need VBA urgently......
  92. Solved: check for add in progmatically
  93. Compare same number in sheet1 and sheet2
  94. Find the "False" words in the worksheet
  95. Countdown timer in VBA
  96. Solved: Match & Fill
  97. Excel 2007 auto install add in
  98. Solved: Remove Custom Menus
  99. Solved: solver.xla excel 2003 help
  100. Solved: Code fails to run on Non-ActiveSheet
  101. Solved: Pop up box when clicking a cell
  102. Remove duplicates from Multiple columns than tally results
  103. Importing Web Page with Hyperlinks into Excel
  104. How to stop a running macro by user click event?
  105. Help:Left Function Library
  106. REMOVE ROW SUBJECT TO STRING VALUE -please review code
  107. Help to get last cell of selection
  108. Solved: Logic Puzzle hints
  109. Call a form in a other workbook
  110. simple loop
  111. On Error GoTo Again: Erase Array
  112. Solved: Data being reset when cell content is changed
  113. Solved: macro to print cell comments
  114. Solved: Assist. Placing Code in Correct Location
  115. problem with a macro
  116. TALLY MULTIPLE COLUMNS AND OUTPUT TO NEW WORKSHEETS
  117. delete umatched items from two seperate worksheets
  118. Should This Code Work
  119. Problem w/ block of code- Formatting Fractions
  120. Solved: Unprotect with input box
  121. Solved: Protection
  122. Solved: Last cell selected
  123. vba code.... change column width on selection of pivot table
  124. CheckBox and ListBox Problem
  125. Solved: Byref argument type mismatch
  126. Solved: Find and Replace *
  127. Copy Visible cells code
  128. Update Pivot table
  129. Image Preview
  130. text box
  131. tying cells together for automatic updating
  132. How to limit SQL right and left number
  133. Solved: Get data from sheet
  134. Amend Code -
  135. Extract data problem in the sheet
  136. Save sheet as a separate file based on cell vale of main sheet
  137. Which year in the period
  138. If two cells match from any given row then...
  139. Solved: Sum across worksheets VBA
  140. How to speed up loop
  141. Code to pick a workbook and add a code to it
  142. Solved: flaw in my code - creating a summary report
  143. Solved: merging worksheets based on unique identifier
  144. Names of cells linked to Control Sources
  145. Need help with an Excel VBA ado query
  146. Solved: Default file name in Save As dialog
  147. Macro to advance filter Data
  148. Solved: Onkey to insert symbols
  149. Solved: Trying to have text box in user form display cell contents
  150. If Problem
  151. Use the 2 colors to differentiate the Run File and Undo File in listbox
  152. FollowHyperlink problem
  153. Solved: Distributing data among sheets
  154. Main 2 ListBox problem into my vba program.
  155. Parameter query using excel range
  156. Solved: Userform Restart Sub
  157. use looping to replicate data table functionality
  158. Solved: display results only
  159. Error showing userforms
  160. ComboBox .List problem
  161. Solved: Quick question for anyone with VB
  162. Solved: Subscript out of range
  163. Transfer ListBox1.List to ListBox2.List
  164. Sheet Name Problems
  165. Solved: return value on column selection
  166. Progress Box
  167. Run Once @initial Startup
  168. Convert First Sheet in Workbook to PDF
  169. Solved: SaveAs Text File Changes Display Value: Stop This
  170. restore comannd bar .control
  171. Using sheet references in VBA on a VLOOKUP
  172. Excel file doubles in size
  173. disable an inputbox
  174. Changed Named Range of Chart
  175. Solved: Early loop exit
  176. Solved: UserForm questions
  177. Progress bar code help
  178. chart object change
  179. Solved: Same Value and SUM
  180. Validation Issue (Excel 2003)
  181. Solved: Workbook Code Module Excel 2007
  182. Kakuro
  183. Solved: Code is clearing clipboard
  184. Copy Range and paste it into a insert comment Part 2
  185. Excel ComboBox - Setting Value
  186. Reopened: Cell contents erased by user form
  187. Solved: Update a cell based on another cell.
  188. Solved: Balance 2 columns
  189. combo box
  190. merge ajacent cells
  191. Reduce size of Excel file
  192. Assign Custom Toolbar Button to XLA Sub?
  193. Solved: delete all sheets not in array(1 to 4)
  194. activate sheet
  195. csv to multi-column listbox
  196. Solved: Suppressing a message box
  197. Solved: Creating and naming a file
  198. Saving selected worksheets in VBA
  199. Error Message, Warning Message: List/Database
  200. Help: Dynamic Timeline Chart
  201. Send worksheets in body of email(outlook)
  202. Disable Virus Scanner Check?
  203. Custom Toolbar Help
  204. Solved: Add a comma after last name
  205. Solved: Search Excel data from JScrpt web page
  206. Not able to go beyond 9
  207. UDF to Calculate the Month
  208. Excel Sheet "Save As" Text File without altering active document.
  209. Solved: loop not working
  210. Time Tracking
  211. Using Access Queries in Excel
  212. Solved: Dealing with numbers with leading 0's
  213. Solved: detect which version of excel is running
  214. Solved: Bypass "Enable macros" warning
  215. Solved: How To Find "Max Value Of A Collection" ?
  216. copying data extact match vba code
  217. sumif across multiple sheets
  218. Solved: Clear cells in column A if column B has a zero
  219. Paste excel table into Word and then format?
  220. Solved: Moving data from sheet1 to sheet 2
  221. Solved: Help with Autoformat pls
  222. changing sheet tab colour
  223. Solved: Basic Question: EntireColumn Property statement
  224. Solved: application/object defined error when .IsAddin is true, but not false
  225. Run a Private Sub from a Keyboard Shortcut
  226. Solved: Install Add in and set reference
  227. Short cut keys won't run entire macro
  228. Solved: Quarter Hours?
  229. Formatting table in Word using Excel VBA
  230. Solved: Selecting the one row above with the relative range
  231. Copying Excel charts To Powerpoint via VBA
  232. Solved: How to initialize scroll bar w/o active object
  233. Relative scales
  234. Solved: How do I get the formulas to work on my userform
  235. Help with sorting data
  236. My first userform
  237. Copy and Paste data from multiple cells
  238. Stumped with XL 2007 Add-Ins Tab
  239. Solved: Create pivot table help
  240. Amend code - Important - Please
  241. Open text file and delete lines.
  242. Checking for Optional Argument
  243. Solved: Test if a Column Field Exists in Pivot Table
  244. Solved: The Macro "macroname" Cannot Be Found
  245. Read cell contents from a closed file?
  246. New to VBA - Importing data based on a cell value
  247. Solved: How Can I Disable A Macro from Another WB?
  248. Determine if a file has been updated
  249. Hyperlinked List of Directory Contents
  250. FSO Properties