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 163 164 165 166 167 168 169 170 171 172 173 174

  1. Sleeper: Cleaner Code
  2. [SOLVED:] A challenge for someone
  3. [SOLVED:] Arrrgh! My Excel Toolbar Is Corrupted!!
  4. [SOLVED:] Listbox multi select issue
  5. [SOLVED:] Time in VBA
  6. [SOLVED:] Code runs on Office XP but not on Office 2003
  7. Sleeper: Self saving workbook
  8. Sleeper: Sort columns by cell color
  9. [SOLVED:] "CutCopyMode" . . . What Is It?
  10. [SOLVED:] Stop Userform Events
  11. Solved: UserForm & Spreadsheet updating problem
  12. [SOLVED:] Selecting Sheets by TAB Colour
  13. [SOLVED:] Time in userform listbox
  14. Sleeper: Change color of variable
  15. Draw Line Arrow VBA,VBE,MACro
  16. [SOLVED:] Characters
  17. Sleeper: Custom Toolbars
  18. [SOLVED:] Duplicate Comboboxes
  19. [SOLVED:] Extract numbers from a range of cells
  20. [SOLVED:] If current sheet is...
  21. [SOLVED:] Hyperlinking from Excel to Word bookmarks
  22. Sleeper: Unique values when compare
  23. [SOLVED:] Ensure at least one workbook open
  24. Sleeper: VBA Controlled Passwords
  25. [SOLVED:] Hiding Columns
  26. Sleeper: Reducing file size
  27. Sleeper: How to hilight duplicate ROWS in excel(plz read message)
  28. [SOLVED:] How to highlight duplicate ROWS in excel
  29. [SOLVED:] Making code as reusable/simple as possible
  30. [SOLVED:] How Beneficial Is "Destination:=" to Copy?
  31. Sleeper: Securing workbook as an add-in
  32. Sleeper: Count same values
  33. [SOLVED:] ShowDataForm
  34. Sleeper: Looping checkbox in excel
  35. [SOLVED:] Protecting sheets using names from a "Defined Name"
  36. [SOLVED:] Enable use of "Grouping" with Excel 2000
  37. [SOLVED:] Insert Rows / Find Cell based on Shading
  38. [SOLVED:] Configuring the VBA Editor
  39. Solved: How do I "save as" with a predefined filename?
  40. Sleeper: Change the Filename before emailing?
  41. Sleeper: Where is the download
  42. Sleeper: Hide unhide rows
  43. Sleeper: Code for browse button
  44. Sleeper: Copy column
  45. [SOLVED:] Randomize
  46. Sleeper: Font and Colour of Generated File
  47. [SOLVED:] How do I code a userform
  48. Sleeper: Dr J's Progress Bar problem
  49. Sleeper: Bordering rows help (again)
  50. [SOLVED:] Conditional Formatting
  51. Sleeper: Formula question
  52. [SOLVED:] How Do I Execute an Addin I Just Loaded??
  53. [SOLVED:] Need Formula Help
  54. Sleeper: Code for Formulas & Input data via Userforms
  55. [SOLVED:] Prompt windows on Save
  56. [SOLVED:] Guide for VBA functions
  57. Solved: Keep userform on top at all times
  58. Sleeper: Sort by interior.colorindex
  59. Sleeper: VBA macro instead of IF statements?
  60. Format Functions Excel Add-in!
  61. [SOLVED:] Copy Multi WorkBooks To master
  62. Sleeper: Emailing Excel Tabs
  63. Sleeper: Email Worksheet
  64. [SOLVED:] Multi Email idea for you
  65. [SOLVED:] Formula time as text
  66. Sleeper: Delimited file: Assigning names to sheets,charts
  67. [SOLVED:] I want the path of the Workbook
  68. Sleeper: Creating own formula
  69. [SOLVED:] Rounding to the nearest whole or .5
  70. Sleeper: Open/save VBA projects
  71. Sleeper: Small problem
  72. Sleeper: TAB color revisited
  73. [SOLVED:] TAB color
  74. [SOLVED:] Return value in cell
  75. Sleeper: Formula calculate value
  76. Sleeper: Excel Statistics add-in
  77. Sleeper: VBA script to open, refresh pivot and save the file
  78. [SOLVED:] Disable ComboBox event?
  79. Sleeper: Can I loop this ?
  80. UserForm & Spreadsheet updating problem (I am Back)
  81. web queries
  82. [SOLVED:] Read textfile contents into user form
  83. [SOLVED:] If statement for Scatter Chart
  84. [SOLVED:] More Info on Program "XLAppRest"
  85. [SOLVED:] Change worksheet name according to cell
  86. Sleeper: Kill excel instance
  87. Sleeper: Using intersect method
  88. [SOLVED:] Remove Named Range
  89. [SOLVED:] Application.Calculation
  90. export data from ERP database
  91. Solved: Error Numbers
  92. [SOLVED:] Hide rows based on values within range
  93. Sleeper: Simple (but hard for me) excel problem..columns
  94. Sleeper: How to add a formula at the bottom of a pivot table?
  95. [SOLVED:] Copying a workbook to selected folder
  96. [SOLVED:] Populate Combobox with Named Range
  97. [SOLVED:] Copy InputBox
  98. [SOLVED:] Add-in for stock price update
  99. [SOLVED:] Delete a folder
  100. Sleeper: Search Function Problem
  101. [SOLVED:] Select listbox item on userform through vba
  102. [SOLVED:] Importing Sheets
  103. Sleeper: Problem with changing filenames
  104. Excel to Word Label Mail Merge
  105. [SOLVED:] Outbox Outlook
  106. [SOLVED:] Protect Sheets But Allow Data Entry From UserForm
  107. [SOLVED:] etting VBE Options Programatically
  108. [SOLVED:] Trim?
  109. [SOLVED:] Writing to an xlveryhidden sheet
  110. [SOLVED:] Exporting VBA Modules
  111. Sleeper: Deactivate workbook after 3 login attempts
  112. Solved: Methods to update an add-in
  113. [SOLVED:] How to launch a procedure on one another sheet?
  114. [SOLVED:] Deleting a sheet without a prompt
  115. Sleeper: Function Question
  116. [SOLVED:] Copying merged cells
  117. [SOLVED:] Finding 1st NonBlank Char in String
  118. Sleeper: DateTimePicker Control not displaying
  119. [SOLVED:] Multiple Instances of Excel
  120. [SOLVED:] Input Box problems
  121. [SOLVED:] Listview
  122. Sleeper: Using Userforms
  123. [SOLVED:] Modified Move Files from one hard drive to another vba
  124. [SOLVED:] Move Cursor in Text Box
  125. Sleeper: Copy worksheet
  126. Sleeper: Probleme with the position of values
  127. Sleeper: InputBox Error
  128. Sleeper: Checking for ColorIndex following Conditional Formatting
  129. [SOLVED:] Help with required entry before copy macro works
  130. [SOLVED:] I need Help with format date and data
  131. Sleeper: Selecting row through active cell
  132. Sleeper: Macro to print area problem
  133. Sleeper: VBA Function to total expense
  134. Populating a LISTBOX based on sheet name
  135. [SOLVED:] Conditional adding to a tree view
  136. [SOLVED:] Dynamic Combo Box
  137. [SOLVED:] MsgBox text...bold???
  138. [SOLVED:] Deleting from tree view
  139. Solved: VBA - Excel - XP - Ping
  140. [SOLVED:] Macro or conditional formatting???
  141. Sleeper: Troubleshooting Add Command
  142. [SOLVED:] If data entered then prompt
  143. [SOLVED:] Retrieving old Target Value
  144. [SOLVED:] Pass Variables
  145. Sleeper: formula calculate time
  146. [SOLVED:] Can you password protect the macros
  147. Advice: Tony Jollans' Clipboard Article
  148. [SOLVED:] Workbook Activate vs Select Revisited
  149. [SOLVED:] Sheet1(MyTab)
  150. Sleeper: How to add a formula on one row directly below a pivot table?
  151. [SLEEPER:] Unchecked' references
  152. Sleeper: Cancelling a browse box.
  153. Sleeper: Excel Macros
  154. Sleeper: Result a search in a list box function
  155. Sleeper: Moving cotents of a cell
  156. Sleeper: Address from global and contact list in text box
  157. Sleeper: Exporting data from Excel into MS Project
  158. [SLEEPER:] Remove hyperlinks
  159. Solved: select a cell and filter data automatically
  160. [SOLVED:] Play Movie in Excel
  161. [SOLVED:] Macro to write code INTO the VBE
  162. [SOLVED:] Divide and place remainder in separate cell
  163. Sleeper: On date account
  164. Sleeper: Cant get this code to work
  165. Sleeper: Pivot Tables
  166. Sleeper: Input Box - Exit Sub on Cancel
  167. [SOLVED:] Select from userform listbox
  168. log into an internet site
  169. Sleeper: Treeview selection problem
  170. Sleeper: Conditionnal copying rows
  171. [SOLVED:] Forced-In negative value
  172. [SOLVED:] Building a Sickness Spreadsheet
  173. [SOLVED:] Count Rows Error
  174. [SOLVED:] Hidding a row from a function
  175. [SOLVED:] Reference to cells
  176. [SOLVED:] Something wrong with Microsoft Excel Community Newgroups?
  177. [SOLVED:] Double Lookup Formula
  178. [SOLVED:] Can VBA do what cannot be done with Advanced Filtering?
  179. [SOLVED:] Select records that meet criteria in column E
  180. [SOLVED:] Worksheet Delete event?
  181. [SOLVED:] Updating Menu
  182. [SOLVED:] Help with percentage formula
  183. [SOLVED:] Passing arguments/variables to Forms
  184. [SOLVED:] Can VBA force an Excel file to open as read/write?
  185. Sleeper: Display files being searched
  186. [SOLVED:] Manipulating a string in the form 11:22:33
  187. [SOLVED:] ExcelDiet
  188. [SOLVED:] Cannot open file (Error 53) for writing
  189. [SOLVED:] Number to date
  190. [SOLVED:] Web Query To Jpeg w/external VBA/VBScript Code
  191. Sleeper: Recalc cells if macro code has changed?
  192. It's Official
  193. Sleeper: Follow up question on "Solved" thread
  194. Sleeper: Update macro
  195. [SOLVED:] Selecting cells off a button
  196. [SOLVED:] Array of Controls
  197. [SOLVED:] Problem with ActiveSheet.Shapes
  198. [SOLVED:] Input Box text to display Asterisks (*)
  199. Sleeper: Is there a Calculator user Form such as the Calendar
  200. [SOLVED:] I fell off the truck
  201. Sleeper: Find values and copy areas to another sheet
  202. Sleeper: AutoFilter and criteria inarray
  203. Sleeper: Adding code from XLA to workbook (Excel 2000)
  204. Sleeper: Subtotal
  205. Sleeper: Printing very hidden sheet?
  206. [SOLVED:] Separate 2 last digits of a number with comma.
  207. Sleeper: Circular reference in a macro
  208. Sleeper: "statistical" function to randomize..
  209. [SOLVED:] Count item in array
  210. [SOLVED:] Disallow workbook to be opened
  211. [SOLVED:] AutoRunning User Defined Formula
  212. Sleeper: Copy stock symbols from one sheet to another
  213. [SOLVED:] Set multiple Print Areas
  214. [SOLVED:] Can you call a Sub from a Function?
  215. [SOLVED:] Translate to Named Range
  216. [SOLVED:] Clearing shapes
  217. [SOLVED:] Using only names found in combo box
  218. Sleeper: Pivot table showing text values
  219. [SOLVED:] Spelling out numbers
  220. [SOLVED:] Find cell address
  221. [SOLVED:] Deleting rows where value in column AN = certain value
  222. [SOLVED:] Cannot delete worksheet from userform...Why?
  223. Sleeper: Search cells for no Hyperlink
  224. [SOLVED:] List Files from target directory thru all subdirs
  225. Sleeper: Draw Lines & Arrows UserForm VBE
  226. Sleeper: Importing a worksheet
  227. [SOLVED:] Further to previous solved, deleing rows in AN
  228. Sleeper: Check CC validation (in excel).
  229. [SOLVED:] Matching two sets of numbers with duplicates
  230. [SOLVED:] Problem with save
  231. Sleeper: Match values on multiple sheets
  232. [SOLVED:] An Ify statment in macro module
  233. [SOLVED:] Modify Code to Unprotect Workbook Prior to Deleting Worksheet
  234. [SOLVED:] How to Construct a Column Variable for Range
  235. Sleeper: How to assign macros from workbook module to Option Buttons Automatically
  236. [SOLVED:] Selecting named columns
  237. Draw Line arrow to Scale VBE
  238. Solved: Refresh date fields on data form in Excel
  239. Solved: Conditional Formatting
  240. Sleeper: Code to add comment when value of cell is changed
  241. [SOLVED:] Cut and paste
  242. [SOLVED:] Using ADO to copy form a closed WB to a new WB
  243. [SOLVED:] Converting amounts to fixed-length
  244. Solved: Mystery to SOLVED: Forced-in negative value
  245. [SOLVED:] Using Union Method
  246. [SOLVED:] Could this possibly be a problem in Excel 2000
  247. Collect data and send mail
  248. Solved: Inserting '-' in cell items
  249. Sleeper: Tagging a Cell
  250. [SOLVED:] Intersect method question