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

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