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. Userform Question
  2. How do I check for data
  3. Solved: Converting all files in a directory using VBA
  4. Number Comparison
  5. Restoring a worksheet using a Macro
  6. Disabling save/as in a specific workbook
  7. add comments to documents summary
  8. select active printer
  9. Solved: Print text box contents in a userform
  10. Formula explanation
  11. Replace Name of Source Workbook in Target Code
  12. Solved: Disable an option in a menu
  13. Automatic Row insertion
  14. Solved: macro to edit links
  15. Solved: Passing objects into procedure
  16. Solved: help with test Calculator in a useform
  17. Solved: Conditional Formatting problem
  18. save workbook without macro's ?
  19. incrimental save
  20. Save Conct to Variable
  21. Rows in selection
  22. Search Internet
  23. Solved: Add column to a report
  24. Make a logfile with all Variables in the Application
  25. Same code produces two different sets of results
  26. Macro Match Destination formatting
  27. How to change contents of a cell depending on adjacent cell
  28. Listbox questions
  29. Solved: Substitute Sheet Name in SUM if Function
  30. Solved: Button to save selected sheets to new workbook
  31. Solved: Error handler in sheet add event
  32. data extract
  33. Creating a floating button?
  34. Blinking Title Bar in a User Form
  35. Help:How to creat matrix bar chart
  36. Solved: New calculator Basic Formulas
  37. Perform SaveAs and Delete Original Copy
  38. Solved: Possible error- VBE does not Change to Uppercase Syntax.
  39. Changing Short-cut key
  40. Help converting Addin to library...
  41. Macro Cell Borders
  42. Listbox Display
  43. problems using the Shell() function
  44. Solved: Insert Header problem...
  45. Solved: Useforms Active Cell Selection
  46. Formating Macro
  47. Solved: TextBox and Label Calculation
  48. Pasting issues
  49. Solved: Force to go to page based on condition
  50. Solved: Referencing a Sheet w/ Sheet Index Question
  51. Solved: Clearing Color Formats
  52. VBA to return ID of person logged on
  53. linking two set of data
  54. macros buttons & toolbars
  55. Create report code help
  56. Solved: Move rows to second worksheet based on value
  57. Solved: Formula needed to match dates with MIN & MAX values
  58. Select Case Construct Help
  59. Is it possible to.....
  60. Help: Defined Array Formula In chart
  61. Solved: MySQL Excel file uploading
  62. Solved: Formula help please!
  63. Set TempCell : Object variable not set
  64. Solved: Put quotes around text in cells
  65. Solved: how to detect white/blank space in a row?
  66. Creating one list by comparing two list of different formats
  67. Reducing workbook size.
  68. Solved: csv file problem
  69. Joining text in selected cells
  70. Copy losing data
  71. get data macro
  72. Opening the Save As Dialog in a Specific Directory
  73. Send ectivesheet in body of email(OUTLOOK EXPRESS)
  74. Excel Workbook & Tabs List
  75. Check the order
  76. group column and sum column
  77. Zooming in and out of a graph
  78. turn a chart
  79. Need Assistance on VBA Code
  80. Chart problems with MS Excel.
  81. Solved: Control Chart Window
  82. Solved: Run time error 91
  83. use excel to import another excel file
  84. Newbie question
  85. Splash Screen
  86. Solved: Application.Wait question
  87. query error
  88. How to prevent copying of cell data
  89. Solved: Execute macro every n minute
  90. Assistance with code
  91. Back to it original location
  92. OLE to RGB conversion
  93. Cut and paste question
  94. change the vlookup via a macro
  95. Solved: Loop To Populate Formula
  96. Solved: Extract data from different worksheets & multiple workbooks using certain folder
  97. Calculation problem
  98. Importing Text Files
  99. Multiple Range Loop
  100. Solved: Automatic change in Title Bar
  101. Solved: charting help needed
  102. Need help with finding duplicates per column
  103. Solved: Loop problem: Trying to write data to 5 cols
  104. Solved: multipage userform adding pages
  105. Disable Ctrl key actions
  106. Help: How to keep indirect() function unupdate value...
  107. Solved: Macro auto change name in VBE
  108. Solved: Working Code not finding server folders
  109. Solved: Loop Problem
  110. Solved: Split large data into various column
  111. List of Worksheet Tab Names
  112. Copy/Paste macro
  113. Solved: What's wrong with this picture
  114. Userforms
  115. Automation Error - Object has diconnected from Clients
  116. Help: Set Chart Source
  117. VBA code for Vlookup in 2 wkbooks and import to master
  118. Solved: www.youtube.com
  119. Unlocking the Pasword Protected File
  120. Solved: Copy Filtered list from Sheet 1 to Sheet 2
  121. Solved: Percentage in VBA
  122. Solved: countif query & more...
  123. How: to check whether an element in chart is exist or not
  124. chart with vba
  125. List of all open workbooks
  126. Solved: macro to format cells
  127. master detail filtering
  128. Solved: left loop
  129. Solved: help for selective highlight of rows
  130. Cell comparison
  131. Find Last Used Cell of Visible Cells
  132. Locking a module rather than the whole project
  133. Auto Sort Entries
  134. Delete Data if Less then Yesterday
  135. Convert Formula from R1C1 to A1
  136. Solved: Method of 'Range' failed error
  137. Replace #DIV/0! ERROR as blank cell
  138. Solved: ayto formatting
  139. Solved: Remove last two characters from string
  140. how to run when print is cancelled
  141. Solved: save user selected sheets into new workbook
  142. Generating data using a loop
  143. Solved: auto sort 2 columns after second column input
  144. Solved: Delete specific word from rows, add specific words to others
  145. Solved: Row copy
  146. Solved: Extremely Slow Performance
  147. Amending VBA Script
  148. Conditional autofilter based on form
  149. Excel Sheets Opens Itself Again After ADO Query !
  150. Deleting row when a condition is met
  151. code for all possible cases
  152. New VBA Code needed
  153. Format Specific Rows
  154. VB How far backwards compatible?
  155. importing data from other spreadheet
  156. Autonumbering
  157. loop that copy sheets in the same workbook
  158. Solved: Filling a simple array
  159. Reversing the process
  160. Solved: Deactivate workbook close button
  161. Solved: WINAPI problem:project:control any sw from vba(with sendkey+mouseclicks)
  162. List Controls on Worksheet
  163. Solved: Read 'live' LOG file
  164. Solved: Relative range for advanced filter
  165. Excel behave like a multi-user database?
  166. Solved: Row count of non-Active worksheet
  167. Help with CreateObject function
  168. Userform Validation Issues
  169. Solved: Update Userform after changes have been made on another useform
  170. Getting the value that WAS in the cell just deleted
  171. cleaning a cell
  172. Solved: Does sumproduct work with OR
  173. Finding the sum value of permutations...
  174. Coordinates for my shape and placing the cursor
  175. How to Prevent Insertion / Deletion of Worksheet
  176. Cutting up a table
  177. how to parse through pivot filtered items
  178. Solved: Copy Certain Rows into Master Workbook
  179. Nested Loops?
  180. Performing an operation on several cells at once
  181. Solved: Run Time Error 91
  182. Solved: Run macro in other sheets.
  183. Any help to tweak the following code much appreciated
  184. Solved: List Box Selection To Text Box
  185. Solved: Sheet names
  186. import data to update charts
  187. Finding correct blank cell
  188. Solved: Apportioning Query
  189. Mkdir
  190. Solved: Macro Record: What Module does it store it in
  191. Solved: Subscript out of range on .Find
  192. Solved: Check Outlook version
  193. Solved: Run-Time Error 5 Invalid proc. call or argument
  194. formatting macro in VBA
  195. Solved: Macros wont run even with security set to low
  196. finding merged cells
  197. Solved: Generating numbers in excel
  198. Copy and paste based on two criteria
  199. Solved: Write a Small Procedure for me please?
  200. Sending Info from Excel to Word
  201. Solved: How to maintain control as nested subs exit?
  202. Solved: auto copy and sort on change 2 columns
  203. Formatting issues
  204. Pivot Table Calculated Field
  205. Pivot Table with ADO
  206. Relate 2 Tables in Excel Database
  207. Formula to find last significant value in string
  208. Solved: Your Opinion, Please
  209. Solved: Inserting Day of the week on a userform TextBox
  210. get min and max from array...
  211. Delete data starting from specific row
  212. Automatic Opening, Saving Closing a Workbook...
  213. Highlighting changed cells
  214. Naming a selected range
  215. ActiveCell not working the way i'd expect
  216. Solved: Find last filled row IN PARAGRAPH
  217. Magnify /Zoom sellectecd cell
  218. Auto adjust
  219. Solved: What happened to this sheet
  220. Investigating the selection
  221. what type of sheet
  222. running slow
  223. UserForm has Color but when print must only print in Black
  224. How to print 1st page of several excell workbooks
  225. Solved: Loop: IF Condition is getting skipped
  226. Solved: Join 2 formulas to work as 1
  227. array
  228. Solved: Clearing a multi column listbox
  229. Running FTP commands from Excel Macro
  230. Changing/retaining format of cells
  231. Macro to unsort data back to its original format - exact copy
  232. Automatic open, save, close problem.
  233. VBA Objects (getting a combobox)
  234. Solved: Entering only values that are different to a list box
  235. Solved: UserForm Show Input error Message before proceeding
  236. Copy data fields macro
  237. Solved: Display Animation While Random Numbers procedure
  238. Select issue
  239. Solved: Pivot Table Creation: Error 438
  240. Drop down lists problem
  241. Copying data from one sheet to another
  242. Solved: find last row and add border to bottom > Resize selection?
  243. Solved: Check if user has selected more than one cell
  244. Solved: naming a dynamic array with 7 columns, fluctuating rows
  245. Solved: Select Case Construct Help
  246. crashing on closing
  247. Solved: VBE and continue
  248. Solved: Help with case statement
  249. Unload userforms
  250. Solved: copy, cut, paste: on a hidden sheet, possible?