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