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

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