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

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