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