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

  1. VLookup on more than one column
  2. Conditional transfer of data
  3. Solved: how to display a special character in a message box?
  4. Solved: Userform updating worksheet incorrectly
  5. Clean way to create popup help balloons
  6. get first blank row and paste formula and format from range
  7. Solved: drop down list forced selection
  8. VB Code for saving a workbook with duplication prevention
  9. Solved: floating button
  10. list box
  11. Solved: Nested ifs Check Changed by val
  12. Altering the Series Formula in a Chart
  13. Converting normal cell into DropDown List
  14. Solved: Combo Box loses all entries after running code
  15. Logging in problem again.
  16. Solved: Close Excel?
  17. Copying data from multiple sheets to one - feedback Req.
  18. Fill text to two sheets on entry
  19. Calendar with comments
  20. msgbox help wanted
  21. Menu Editor
  22. Solved: Data from Userform to spreadsheet
  23. Solved: Working with Filtered Data
  24. Find Excel workbooks in many SubFolders
  25. Solved: Add new row to spreadsheet
  26. Existing data shuts down VBA
  27. Problem with Calculated fields in the Pivot Table
  28. Solved: Spreadsheet Printing
  29. Solved: Search and copy question
  30. Worksheet_SelectionChange Now I can't Cut and Paste
  31. Hiding Spreadsheets
  32. Inserting names from address list into user form
  33. Using excel to read pixel color in .bmp files
  34. Copy and pasting format and formula for new range.
  35. Solved: Interest Rate
  36. Solved: Selecting Value from List based on Multiple Criteria
  37. Solved: SaveFileName As Concatenated Value
  38. Userforms
  39. Solved: Message box code
  40. Solved: Data validation cell change - message box
  41. Dodgy array and loop - this might be very bad...
  42. Solved: Dynamic placement of buttons
  43. Solved: Email multiple attachments using a column range in excel
  44. Solved: VBA Code to Concatenate
  45. Solved: Sheet Security
  46. Delete or ClearContents ends sub prematurely
  47. Solved: Selecting a folder interactively
  48. Solved: Date Formating?
  49. Solved: find data in a closed workbook?
  50. Solved: Text Compare - pattern match
  51. Solved: Fixed Cell/Column Width - when reached move to cell below
  52. Solved: Loop in Excel
  53. Solved: Can you put a smilie in a msgbox?
  54. Solved: Select Range of all rows
  55. Solved: Formatting headers
  56. Solved: Get portion of search results
  57. Solved: Clean up some code
  58. Solved: Get Tabs Back
  59. Highlight formula results that have a blank value
  60. Advice on a sort of client-server app
  61. Solved: Paste last row into master sheet.
  62. saving userform textbox as a number in worksheet
  63. Hyperlink - Parent and Child
  64. IF Formula with colour
  65. Solved: Menu options on Microsoft Visual Basic
  66. Solved: Combo Box Help
  67. Solved: bar diagram
  68. Solved: Autofilter Question
  69. Taste of my addin
  70. Solved: Opening a doc
  71. Solved: Line Number in Error Handler
  72. Summary worksheet
  73. Create ActiveX Form from Delphi7
  74. Counting Clicks?
  75. Getting the Excel's name from folder!
  76. copy cell content depending on value
  77. Excel persisted range to SQL Server 2005
  78. Toolbar...
  79. summ aumont with interesec two index....
  80. Sudoku setup
  81. Restrict to single selection in Multi select Listbox
  82. Mail from Excel via Outlook
  83. Solved: excel cursor turns into black box
  84. VLookUp or ....
  85. Solved: Need a blank cell as a result
  86. Solved: CLOSE WORBOOK AT SPECIFIED TIME
  87. Solved: send email using outlook to diff people, diiff attachments and using diff email ids
  88. Solved: Help with the formula
  89. GetObject method in Excel 2004 for MacOs
  90. Solved: XLSTART Directory
  91. If null or if is not null question ...
  92. Worksheet Formula Finding Duplicate Names?
  93. Get Active IE Contents Into Worksheet
  94. Solved: Sheet names in an array
  95. Solved: Cell range as a variable
  96. Solved: Export to Text File
  97. Solved: Macro Problem
  98. Need macro help
  99. Where is it the written cell????
  100. Worksheet ReadOnly?
  101. Compile error: Variable not defined
  102. Solved: Make add-in compatible with Excel 2007
  103. Solved: Export/Import Range to Text File
  104. Charting question
  105. convert to number alert msg
  106. testing/quizzing
  107. Creating Common Connection object to use across many modules
  108. Solved: Which Runs Quicker???
  109. Breaking a name into characters
  110. CTRL F on more than one WB
  111. Zygote Assistance: Search by Font, Copy to New Worksheet
  112. Adding Controls to Pages programatically
  113. Solved: Message Box Obsolete
  114. Solved: assign macros to the controls of a toolbar
  115. Need help with macro to insert rows and copy data
  116. simple loop backwards
  117. Solved: When Application.UserName is blank ...
  118. multi match
  119. Code Printing
  120. Solved: Page break at each change in customer
  121. Making a textbox display a default value
  122. Solved: Formula if Product is the same as above
  123. Data validation pull down not recognized
  124. Solved: delete rows which are not completely filled
  125. Outlook data checked against a spreadsheet
  126. Solved: Working with Dates
  127. Getting a feel for excel functions
  128. Solved: Array & cbos?
  129. Solved: Store Application.Vlookup Value in Array?
  130. Images copying to another cell
  131. HELP With Code
  132. Solved: Hide my "Personal"
  133. Browser History to Excel
  134. coding OptionButton to show message
  135. rename excel files using text in it
  136. one sheet print
  137. Solved: Naming Sheets
  138. Returning External Data from MySQL Server
  139. zoom in to the pasted area.
  140. Solved: I need to debug, Can you help pls?
  141. Automate IE download from jsp web page
  142. world war 2
  143. SS not accepting dates past 1/20/06
  144. Dependant comboboxes
  145. Compare one cell with a range ....
  146. Summing largest amounts - Formula limitations?
  147. Pivot Table Default Selection
  148. Shift if "Invoice Date"
  149. Solved: Populating a user form, editing the data, then saving it back to the spreadsheet
  150. conditional addition of row
  151. Solved: Date in all Caps
  152. complex if statement.. need help.. thankyou
  153. Solved: Precedure that works on one sheet and does not on another one
  154. Group Cut and Paste
  155. autofit without unhiding
  156. Copy data from one sheet to another in the same workbook
  157. Converting from: Send Key Event to: different event
  158. Solved: Update Matched Items
  159. Solved: Using wildcards in a formula
  160. Copy Outlook data to Excel
  161. Cells method advice
  162. PivotTable.Refresh woes
  163. Solved: Moving data and deleting duplicate rows
  164. Hiding rows in a protected worksheet..
  165. Solved: view/page break preview
  166. Solved: XCOPY Command Using VBA?
  167. Date Format Error
  168. Copy data from Excel to Internet Explorer
  169. close all but activeworbook
  170. Loop involving list
  171. Passing a variable into a Private sub
  172. Solved: Delete Any Numbers that are less than 1
  173. Import data
  174. Last Row
  175. Solved: pasting with formulas - problem with macro
  176. Extend Code To Other Worksheets
  177. save a worksheet
  178. Open Workbook based on today's date
  179. Number of days in current month
  180. Solved: Timer Delay
  181. Solved: 2007 Personal.xlsb info
  182. Copying a Module and Updating Links
  183. Solved: User Form / List Box Help Me!
  184. Solved: Copy Large Cells
  185. Control with time
  186. Locking cells in excel
  187. Data Input in Excel
  188. Solved: Problem with Formula to Determine the Max Row
  189. Format of date in text box differs from the corresponding cell.
  190. Get inner Text string Value
  191. Restrict Data in Cells
  192. Use Variable in ComboBox name?
  193. Solved: how to make a solved thread, unsolved again?
  194. Solved: Copy and Paste Problem
  195. Solved: Help With INDEX-MATCH-SMALL...
  196. Solved: Formula for sheet name
  197. Consolidating data from multiple workbooks grouped by first column
  198. Find Next Error
  199. Solved: [solved] Help with Email active worksheet example
  200. Solved: Cut and Paste using Offset and Vlookup
  201. Solved: titles in scatter graph
  202. Solved: Adding new sheets with the pre-define names
  203. recursively add button and code
  204. Version incompatibility?
  205. macro to open a folder with explorer
  206. Solved: Adding a row of unlocked cells
  207. Solved: Worksheet Protection
  208. Solved: Pivot Tables from External Databases - Average formula incorrect
  209. Unexplained ?NAME? Error in Formula
  210. Solved: Flashing cell (sheet_activate)
  211. Check for memory leaks in Excel VBA
  212. Custom Document Property Defaults
  213. VBA Code Security and Sheet Protection
  214. Solved: Specifying path using Environ(UserName) = Runtime Error 5?
  215. Chart Series info in tipbox?
  216. collecting particular type of fileds
  217. Solved: Splash screen While Macro Runs
  218. repeate open event
  219. Solved: Excel Sorting Help
  220. Report from Excel
  221. Solved: Advance Filter problem copying filtered range to different workbook?
  222. Copy just certain data from a cell
  223. How to copy vice versa? ..
  224. Solved: What Quarter is the Date?
  225. FinalRow
  226. Solved: Overflow Error #6
  227. Solved: Formatting Time Values using VBA
  228. Solved: Summing time in a dynamic range?
  229. Open emails from excel.
  230. Solved: Form Locations
  231. Solved: Range Reference Quickie
  232. Excel Macro Help
  233. List uniques from multiple worksheets
  234. SQL Loop Error '3021'
  235. Solved: Range Union
  236. Auto Run a macro from PERSONAL.XLS
  237. Solved: Help understanding CONCATENATE formula
  238. Import Text File to Different Worksheet
  239. Solved: Help with Textbox and label
  240. correct formula syntax in macro
  241. Hours Between dates & time
  242. re: Cannot Add Uniqe Items to a collection
  243. Use animated gif in userforms
  244. inserting optButton value into worksheet
  245. Text to columns Destination
  246. help with old code now work has changed output formats
  247. Solved: The Lifetime of the "Application.Iteration" Setting
  248. Solved: Showing filtered range in TextBox on UserForm?
  249. Help with consolidating Invoices
  250. EnableMenuItem function help