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. How to hide the workbook while exeuting macro?
  2. Solved: Find Empty column
  3. Challenging Macro to reverse the function of an existing macro
  4. Extract certain data from file.
  5. Formula help for counting indexed cells?
  6. Finding Unique ID Number & Fill the Cells
  7. Format Msgbox
  8. Merge all unique values into one in a required column
  9. Data Extraction
  10. Solved: Problem in auto loading toolpak add-in
  11. need help protecting source code..
  12. Refresh Data
  13. Datediff in vba
  14. Solved: Merging two columns as a unique column
  15. Grabbing the cell value before it is changed (or on cell selection)
  16. macroto recreate fucntion of grey ADD/REMOVE button onto blue ADD/remove button
  17. Solved: How to make the mouse Scroll locked
  18. Excel
  19. Solved: Copy a file to the users desktop
  20. Copy a sheet from all workbooks in a folder
  21. [SLEEPER:] Write To Web Page
  22. Solved: Validating a textbox
  23. How to disable the selection of Workbook
  24. Validating an entry against a database
  25. Disable 'Save' and 'Save As' dialogs
  26. Trying to call access functions in excel
  27. Solved: trying to import csv in macro from web.
  28. Solved: Password Protecting particular rows in excel
  29. Solved: move records
  30. Subtotal calculation using Macro
  31. Solved: Sumproduct (Formula not working correctly)
  32. 2nd Userform amend posted worksheet to not show UFC Column B
  33. Ideas to speeds up PivotTable VBA
  34. removing 0's macro based on columns
  35. [SOLVED:] If cell = "" then highlight cell
  36. Solved: Replacing Text
  37. DRJ's conditional formatting
  38. Showing Formula with values in other language
  39. Looping/Copying/Other
  40. Solved: Matching
  41. Save File Without Showing Window
  42. Solved: Charting Macro Problem
  43. Alignment of new data and add boarders
  44. Workbooks.Open using network path
  45. [SLEEPER:] Copying Data to Specific Tab
  46. insert comments from countif
  47. Solved: autofilter question
  48. Compare Sheet1 and Sheet2 Results in Sheet3
  49. Cell Formatting
  50. Solved: Check and copy rows
  51. Solved: send sheet
  52. Conting consective cells based on criteria
  53. Solved: Edit MP3 tags in Excel / VBA
  54. determining user domain account (AD) from VBA
  55. Solved: Using For Loop to get info from Text box
  56. Solved: How to loop through the columns???
  57. How to check the data column and empty column???
  58. Solved: The use of [] brackets for assigning values or arrays
  59. worksheets order + protection
  60. workbook_open: simple question
  61. compile error
  62. Clear constants in a selection
  63. Solved: Match function
  64. Select last 30 cells
  65. Solved: Formula in VBA code - modification requested to avoid Error
  66. Solved: Floating listbox to navigate within a single worksheet
  67. Solved: Process checklist
  68. Check if a Dynamic Array has been ReDim'ed...
  69. [HELP] Charts.Add and Range
  70. userform review function
  71. Display HTML code in Form textbox
  72. problem with filter condition
  73. Append File Names to an Existing List of File Names
  74. Un-wanted audio alert
  75. Solved: Extract info of a point on a chart
  76. [SOLVED:] To edit data using UserForm
  77. How to plot on a image file embedded in excel
  78. creating a chart using VBA
  79. Do While Loop Help
  80. Solved: Search Form Help
  81. Solved: Check contents of cells in header row
  82. Code to install addin feature
  83. Solved: copy data in sheet1 and paste in sheet2
  84. Solved: Reverse code on a macro
  85. Solved: Use a variable to reference a control?
  86. Solved: Advance Filter & Last Rows Sum
  87. detele unnecessary rows
  88. Solved: Using Treeview Control
  89. Userform as a variable and moving data
  90. Solved: Removing All Duplicates
  91. Solved: Scrollbar Control Reverse counting
  92. Solved: Refer to Range Names on Different Worksheets
  93. Solved: past due report
  94. Solved: Filter Combo Box Value
  95. Solved: Use textbox to display data related to the child node
  96. Solved: MenuMaker - disabling menu items
  97. code tweaking
  98. Solved: VLOOKUP resuts
  99. Show user form
  100. excel programming issues
  101. Loop thru range, find and copy data to matching sheets
  102. Solved: How to Identify Worksheet Name for Each Range
  103. Permutation two
  104. Solved: Extracting specific data
  105. Solved: How to Rename a Defined Name
  106. insert data in dialog box...
  107. Query data from two databases
  108. Solved: Help in finishing the code
  109. Solved: Problem with Date Format
  110. Advanced Filter Creating Named Range?
  111. A sound on conditional formatting
  112. Solved: Run Time Error 13 & Format Func in userform
  113. ADODB, SQL, INSERT - force the type of inserted data
  114. Solved: Enter password as *****
  115. Control Treeview
  116. [SOLVED:] Ungrouping all Row and Column ranges in workbook
  117. Solved: Set Worksheet Name and Locate Range Info
  118. Update macro to add tan border as shown in worksheet example
  119. Solved: Sorting by month of year
  120. Solved: Highlight the entire row on click
  121. Solved: Get average table for each month in Column L
  122. Attaching Objects Code
  123. Solved: Hide Columns Form
  124. Solved: Using String in a cell as reference for a cell
  125. Convert data for Pivot Table
  126. Sleeper: Copy data to new sheet to remove duplicates
  127. Solved: How to get a URL address from the cell value
  128. Solved: file generation + naming from a variable
  129. Solved: CountIF based on logical operators
  130. Solved: How to Format Font in Middle of String?
  131. Solved: range question
  132. Solved: VBA - Get Range of a Range ??? How?
  133. Solved: Mousemove event with shape
  134. cannot createobject using "internetexplorer.application"
  135. Solved: Tool allocation forecast with multiple IF statements
  136. Listbox RowSource Requires Range or String
  137. Open multiple files as workbooks
  138. VBA macro code to find last worked row or column
  139. Filling Mandatory Cells in Excel
  140. Show running time of macro
  141. [SOLVED:] Remove commas and spaces in the middle of a string
  142. Solved: Count tabs in Workbook
  143. Macro to generate random number then User needs to guess that value
  144. Solved: List box items selected but wrong message
  145. COUNTIF for more than 1 thing on the same formula
  146. Close out without saving
  147. writting sum function in VBA
  148. nested If statement
  149. making define name ranges to work for other worksheets
  150. Solved: Fill down formula
  151. Solved: Last used cell
  152. Solved: Help with macro
  153. [SOLVED:] Incorporating a version number (incremental) in filename
  154. Macro to ask to find file
  155. Solved: Top 3 highest values in range
  156. 2 different color at the same cell?
  157. Flashing Cell
  158. Tidying up the code and adding functionality
  159. Solved: Index / Match Multiple Criteria Issue
  160. Flow chart
  161. Solved: Hide Buttons in code?
  162. Text to Columns question
  163. Reading Word files and search for key words
  164. [SOLVED:] Save location
  165. find data from one workbook to another workbook
  166. Solved: Preventing a user from saving a file as a different name.
  167. Solved: Incrementing to next record
  168. Solved: getting the file not found error
  169. Reposting as original attachment was corrupt
  170. Solved: Workbook_Open view in 100% zoom
  171. create moviedatabase, search IMDB.com
  172. Formula for cell value
  173. Running macro periodically
  174. Extracting Unique Values from a Column
  175. Macro replacing text in each row by column
  176. charting with vba
  177. Blink Control
  178. Error Checking
  179. creating graphs from vba form
  180. Solved: Copy Cell Values from Non-adjacent columns
  181. How to obtain properties of graphical "line"
  182. Make decisions
  183. Solved: Looping through Columns
  184. Format display in the comboBox
  185. Add week ending date to newly created and renamed sheet?
  186. Working with Multiple Appls Simultaneously
  187. Solved: Extract and convert Data to new sheet
  188. Return top 5 From a tabel of data
  189. Open files with wildcards
  190. Solved: VBA code to create / insert macro
  191. Solved: worksheet_change event does not trigger on copy/paste
  192. Enter File Path in Webform then Submit
  193. Automation error - Element not found
  194. Solved: can't name darn worksheet!
  195. Solved: Searching specific text in cells in a column
  196. Protect excel workbook
  197. Use Do While instead of For/Next
  198. Solved: How does this work?
  199. howto convert a excel file to a htlm file inclusive macro's
  200. Solved: Disabling cut copy paste on certain cells
  201. MACROS
  202. Sumproduct Error
  203. Last Active Row - Help modifying for Column
  204. [SOLVED:] Make me look like an Excel/VBA Rockstar....
  205. Error message when combining all excell wkbks in a folder using macro
  206. [SOLVED:] Desperately need VBA code help
  207. [SOLVED:] email via outlook from excel
  208. Fill Remaining Chart Percentage
  209. Solved: Getting data from web site
  210. Macro screw ups
  211. Solved: Need help removing a menu bar created in excel 2003
  212. more than 2 dims in an array?
  213. question on a constant + loop on a range
  214. Compare Data
  215. loop + array: complex for me :(
  216. Solved: Updating Charts in VBA with listbox
  217. Solved: Populate Combobox in userform
  218. Solved: How to pause a macro
  219. How to add a row in different files?
  220. Solved: Inserting Formulas With Loops
  221. Solved: TextBox formula
  222. if any cell in a row = > 70 Generate email Alert
  223. Solved: Insert row with formatting and formulas
  224. stop macro from replacing existing price and UCF cost assigned to a customer to zero
  225. Sort excel and get top 10 and bottom 10 rows
  226. Excel send to mail recipients help
  227. How can you stop users from opening a file twice.
  228. [SOLVED:] Excel vs Access VBA
  229. [SOLVED:] Converting Criteria Listed in Excel For Data Validation
  230. Report on a Count of Colours Cells by Unique Row and by Column.
  231. Merging two worksheets
  232. New column through existing ones
  233. Solved: Combine Cells in multiple sheets into 1 sheet
  234. Solved: How can I delete all Queries in workbook?
  235. Solved: Data input from message box
  236. Solved: Download EXE files using VBA
  237. retrieving data in a list according to 3 criteria
  238. Solved: Disable One Procedure While Another Runs Then Enable Again
  239. Reversing a Macro
  240. Solved: Saving a copy of a spreadsheet, external file?
  241. Checking entries to see if it is a valid entry
  242. Directory/Folder listing
  243. Copy and Add to Range
  244. Little help with Autofill please
  245. Lookup code - I am missing something from my code!!
  246. [SLEEPER:] Import multiple files into a single sheet
  247. Solved: Copy subtotal values
  248. Solved: Code Modify
  249. Delete Rows : urgent
  250. Solved: Dynamic Conditional Formatting