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