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

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