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

  1. Prevent sub routines from running
  2. Solved: Changing Date Format in an Array
  3. Select unique value
  4. Solved: Changing Date Format
  5. Solved: Comparing a list between two worksheets
  6. Cell on Click Event?
  7. Data from Web page / IE into Excel
  8. getting worksheetnames as links
  9. -2147417848 Object Disconnedted from client
  10. Solved: Printing different columns
  11. Cell Reference in another excel file
  12. Solved: How to protect macro code..
  13. Individual Dates To Consecutive Dates
  14. The sampler should give transactions of
  15. Copying chart parameters from one chart to another
  16. calculation state
  17. Start Range down 1 Row
  18. Write Reserved Error With Save As Macro
  19. Solved: resetting a variable to empty
  20. Solved: Eliminating the "Data May Exist in the Sheets Selected for deletion" window
  21. Solved: Merging Worksheets into one Master Sheet
  22. Solved: Selecting Non-adjacent columns
  23. Solved: Combobox Value in Userform to a textbox in an activeworksheet
  24. Using the MATCH command
  25. nesting a vba function
  26. lotus email problem
  27. Solved: Rename tab
  28. Solved: Form Radio Buttons
  29. Solved: Excel Template and Excel Database
  30. Best loop to use?
  31. Listbox Values to Select ppt Shape
  32. 1004 error
  33. EXCEL MACROS: Convert Absolute Reference cell into Relative one
  34. Excel userform pass values to SQl query
  35. Solved: AutoFilters: need simple tutorial, and differences (?) for Mac users?
  36. Solved: For Each Loop- Multiple columns?
  37. UCase Help
  38. Solved: Delete Empty Rows
  39. Solved: SUMPRODUCT WITH COLUMN()
  40. Copy "X" number of records to new file
  41. Set up table to search Web for specific Item details
  42. Compare and Print with VBA HELP!!
  43. Solved: Macro to AutoRun at Night on Network - will it work?
  44. Solved: Auto Date Populate in form
  45. Data Validation - Combo box using Named Ranges ? INDIRECT
  46. code to close workbook
  47. copying a worksheet that is hidden?
  48. Solved: link to return to form
  49. Solved: Using the EOMonth Function
  50. Solved: Matching Date Types
  51. [SOLVED] Refresh Pivot with larger cache
  52. adding date with double click
  53. Mouse Icon over Cell Change
  54. Switch to workbook if already open
  55. Solved: Work Sheet Naming
  56. Read Only File
  57. Pivot Table events
  58. Solved: USEFORM COMBO BOX VALUE USING IF
  59. Exporting data from Access to Excel
  60. Where does code go
  61. SaveAs: Keep original copy open?
  62. Save copy.
  63. Solved: Auto Comment
  64. Solved: UserForm Navigation
  65. Open Bloomberg
  66. Solved: ROUND OFF TO NEAREST INCREMENT IN 25
  67. Tabbing Issues
  68. Inputing Userform data into spreadsheet
  69. Solved: Scrolling in Form threw rows
  70. Checking date in cell A1 Monday or not
  71. worksheetname
  72. Recognize other programs running
  73. Solved: Changing Date Format Within an Array
  74. Solved: Highlight control in UserForm
  75. Export Excel Range to Access
  76. query does not work
  77. toggleButtons
  78. how to delete the column when the shape is deleted?
  79. Solved: Excel User Forms with multiple selections
  80. Solved: Conditional formating
  81. Solved: Searching a very specific Value
  82. Solved: Re-writing my VBS into VBA Excel... minor bug
  83. Solved: Prevent Duplicate Date in Validation Code
  84. Solved: Design of reformat macro
  85. Help with query
  86. Solved: Help:Switch automatic changing case ON/OFF?
  87. How to have a macro run by itself
  88. Array size limits?
  89. Solved: Change Link Source in a protected sheet
  90. Solved: Error Checking against opening file
  91. Finding the Folder that the working file is in
  92. DELETING SYMBOLS
  93. Userform To Act As A Login With A Password To Use The Spreadsheet
  94. serious problem re: cut copy and paste
  95. Import data from Text file using macros
  96. Solved: user access
  97. Solved: Column Number
  98. Solved: Setting Window height & width
  99. Exit Excel Macro
  100. VBA: Append letter "JS"
  101. Import Access table to Excel
  102. Solved: Sheets Problem
  103. Input data into web form write to Excel
  104. Cut and Paste Problem
  105. Solved: SETTING USER TO CLOSE WORKBOOK IN A BUTTON NOT IN WINDOW
  106. switch cells
  107. "Reset" Lastcell
  108. Variables and Chart Series
  109. Solved: Populate boxes on form with value from 1 cell
  110. Web Query -- URL Dynamically post
  111. Sorting Columns
  112. Whole row of active cell should be bold
  113. transfer of data from userform to sheet
  114. Web Query Questions
  115. Solved: Whole row becomes shaded / highlighted when selected
  116. how to write if a=b in VBA?
  117. Formatting text in a formula
  118. Solved: Code help
  119. Solved: Forming a variable name
  120. Solved: calling a sub in another add-in
  121. Solved: Tabbing Issue
  122. Solved: reducing size of Excel files
  123. Solved: create new workbook B from subtotals in workbook A
  124. Create Image of selected cells and save outside of Excel
  125. Solved: Test if Autofilter is on
  126. Macros do not work
  127. Solved: WB + WS vba headache
  128. run macro for an entire folder contents
  129. Assist in creating loop w/ multi-variables
  130. Deleting a formula from a cell once the result is given
  131. Solved: Dealing with multiple columns with variables
  132. Solved: Cell formatting
  133. Solved: Debug.Print
  134. combining two Worksheet_SelectionChange(ByVal Target As Excel.Range) correctly
  135. Sheet Protection - Which has precedence?
  136. Copy values from one sheet to another
  137. Column Exists
  138. Select Row Copy anomaly
  139. Solved: Cell reference in global declaration
  140. Handling Array Error
  141. Solved: Code works on step through, but skips when run...
  142. Solved: Goto a worksheet selected by the user
  143. Solved: Determine is Sheet exists based on list
  144. Send as Attachment - Change coding from Excel 2003 to Excel 97
  145. populate data based on a list
  146. Sheet selection + Shortcuts
  147. Solved: Multi stage sorting and subtotaling of Excel Data Base
  148. Run Time errror 1004
  149. How to protect the macro code?
  150. Solved: protect formulas
  151. Solved: Hiding Command Toolbars
  152. Only locking particular cells without protecting the whole sheet?
  153. Solved: Deleting file at end of code
  154. excel and sharepoint 2007
  155. Classes, Instance, What is this all about?
  156. recopy value in column without dupes
  157. Solved: Simple formula not working
  158. Solved: Track File Usage
  159. Importing a Text File
  160. Using 'Ontime'
  161. Is this code correct?
  162. Solved: Dropdown list problem
  163. Convert Excel Workbooks into Text files, Compare them & store result back ito Excel
  164. Solved: Excel VBA Email to more than one recipient
  165. Solved: Copy paste special
  166. Cell format
  167. Solved: Gather tab names from workbook
  168. Hiding blank rows below Pivot Table
  169. Solved: Formulas, entered by macro
  170. Solved: POP UP MESSAGE
  171. Solved: Chart Formatting
  172. textbox events?
  173. Solved: Sum of columns
  174. Solved: how to check duplication of columns?
  175. Formulas that do not run
  176. Combining code to make smaller
  177. Changing Date Format in an array
  178. Search and Replace Special
  179. Userform checkbox captions to a cell
  180. Can you tell me why it sends two emails?
  181. why can i see it and other can't?
  182. Solved: A function that pulls earliest date based on multiple criteria
  183. double click
  184. Solved: Format problem
  185. Solved: #NA problem
  186. Solved: Table customisation thru Pivot Table
  187. Solved: Function - Lookup sub for file path
  188. Data Form in Excel
  189. Solved: Input Box help
  190. Combining Code Part Deux
  191. Solved: Why does one work but not the other?
  192. VBA to minimize file size?
  193. Solved: Create User Defined Text File
  194. Auto start macro problem
  195. Solved: This works horzintally but not vertically?
  196. User Form Won't show
  197. Custom Views/Hidden Row VBA Solution?
  198. Solved: Debugger anomaly
  199. Solved: test for Add-Ins, prompt to activate if not
  200. if file size larger than X KB, run zip/mail vba .... how?
  201. do i need vba to do this? (regarding dynamic range)
  202. weekly count
  203. Why won't this (simple) VBA work??
  204. Macro In .xlt File Won't Work In .xls File?
  205. Sleeper: Recover information
  206. select case
  207. CM
  208. force a workbook save
  209. right click
  210. copy current sheet
  211. Solved: a VBA code example for Right Click Menu On a ListBox
  212. Solved: With End With Copy PasteSpecial Help
  213. problem with Textalign
  214. [SOLVED] How To Work With Boolean Values
  215. Solved: SaveAs Macro Code
  216. Solved: Theory/Explanation/Benefits; Filldown vs. Copy
  217. Solved: How to create a drop down list?
  218. Help writing loop
  219. Solved: Application.FileSearch Excel 2003
  220. [[URGENT]] VBA help with the Taylor Series on Trigonometry
  221. Solved: Using all Spreadsheets in a folder to create table
  222. Dynamic pivot data
  223. Sum using match feature with multiple criteria
  224. Rearrange the Worksheets of Two Workbooks
  225. ListFillRange
  226. Solved: Using VLOOKUP with array in different workbook and referencing the filename
  227. Pass a variable to a built-in dialog
  228. Solved: Modifying a User form
  229. Solved: Loop help
  230. Transpose
  231. Solved: How can I enable a right click on this code?
  232. Remember Toolbar Position
  233. Solved: Setting using Personal workbook to store settings
  234. Solved: Issue with running Solver in VBA
  235. Solved: Pulling hair here... :D
  236. How to create a summary out of 2 columns
  237. Some problems with checkbox
  238. Why won't this work?
  239. Creating Shared Workbooks destroys hyperlinks?
  240. Help! Insert row based on row values...
  241. VBA Code to read the structure & data of an excel sheet having merged rows & columns
  242. Copying down and out of memory problem
  243. how to add a control to the aditional controls available?
  244. Solved: match loop up help
  245. Solved: Custom Format hh:mm producing odd result?
  246. How To Filtering Datas On a ListBox By First Date and Last Date?
  247. Opening all worksheets in a workbook
  248. Solved: Forcing Conditional Formatting to Check Cell's value
  249. Solved: Show text from textbox on worksheet in textbox on userform
  250. Inserting Table into word from Excel VBA