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

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