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. Solved: Dial and Gauge Charts for Excel 2007 and 2010
  2. Solved: Bulk Insert of Names for Ranges/Cells?
  3. Solved: What is this EXTRA bit of code - date format)
  4. Solved: Code to unprotect only one worksheet
  5. Solved: Sending an Outlook message from Excel
  6. Counting the filled cells
  7. Unique items and renaming of sheet issues
  8. [SOLVED:] Problem with setting Range, and calculating SUM
  9. Change arrow key behavior
  10. Solved: Creating a Dynamic Nested ForLoop (ie.variable number of nests) Recursive functions?
  11. Solved: Help with VBA subtotal and remove subtotal
  12. change font color for disable textbox
  13. Looping through a batch of workbooks
  14. Excel/VBA date compare not working
  15. Complex data output into html
  16. [SLEEPER:] Workbook locking up
  17. 3 cells to another sheet next row
  18. Solved: Print Page Numbering by Tab index in Footer
  19. read write access using VBA
  20. Solved: VBA to to unhide sheet
  21. web browser control focus trouble!
  22. pivot labels
  23. Populate a combobox & textbox in a userform with data from a dynamic table
  24. [SOLVED:] Excel crashes
  25. Formating table
  26. Duplex printer needs help
  27. How to select Random Rows after Autofilter??
  28. Crashes When Saving
  29. Check cell range contains data if adjacent cell is not blank
  30. How to select a range of cells which are filled in not an active sheet.
  31. How to record a deleted row value in excel
  32. Macros that can translate from English to Spanish.
  33. converging data
  34. How to record delete event in excel
  35. Solved: How to write imported file's name in a cell?
  36. Solved: loop varaible
  37. Calling Function with 2 args results in "Expected: =" compile error
  38. [SOLVED:] Turning Checkboxes into Numeric Values
  39. FORM - goto first text box if not found
  40. How to save an SQL file using Save Dialog in excel
  41. Solved: Command Buttons fire 'Runtime 438'
  42. Solved: Loops that write specific data to file
  43. Solved: Delete range based on 3 cell values?
  44. Merge two data inputs
  45. Solved: test filter and delete row in OLD and NEW office
  46. [SLEEPER:] Permuations
  47. Solved: Target.Offset(0,2) & Run-time error
  48. Fill a combobox from a spreadsheet?
  49. Border war
  50. Solved: Averages of column and formatting
  51. Module question
  52. Solved: Excel Concatentate formula...
  53. Reg : Merging of cells
  54. Solved: How to obtain two cell data from each worksheet in an Excel file?
  55. [SOLVED:] Range = index() + textBox.value
  56. Controlling the display of a text box
  57. Personal.xls???
  58. Merging Cells Using Excel-VBA
  59. Userform/Checkboxes Formatting
  60. Solved: How to run macro for 2 event changes
  61. Solved: Control Workbook from another Application Window
  62. Solved: Worksheet_Change not running right
  63. [SOLVED:] Open new message and populate To: Box in outlook from excel
  64. Find dupe row, move one of them
  65. Solved: how can i use the userfrom to replace the value in sh
  66. Merge workbooks sheets
  67. Copy files, from a given list!
  68. Issue with the macro which downloads the files from internet.
  69. Solved: check if anything in userform changed
  70. Need to make DTPicker invisible based on another cell's value.
  71. [SOLVED:] Called sub not working
  72. [SLEEPER:] Replace dots with commas
  73. Solved: VBA Highlight row
  74. remove text from an unmerged cell
  75. Dynamic hyperlink formula won't link to file path when saved to new location
  76. Consolidate data to one master workbook
  77. 2 colors in one cells.
  78. Show Formula Value
  79. Multiplying an arbitrary number of polynomials
  80. open file from outlook
  81. Pivot Table keeps showing wrong results
  82. ListBox1 populates Listbox2 upon selection from a sheet?
  83. Solved: Excel Macro for trade reconciliation
  84. Solved: How do you count this?
  85. Solved: Extracting words in Uppercase
  86. Solved: return which Option Button was clicked
  87. Excel 2007 Saving issues
  88. COPY
  89. combine
  90. how to set import defaults?
  91. Solved: Select Case
  92. Using VBA to download a file from a website
  93. How to wrap comment.text in vba
  94. Solved: repeating a vba code in excel
  95. Solved: Merger and Unmerge cells
  96. Solved: Custom diagram dots in excel 2003
  97. How can you read with a VBA Excel Sub a vector from the worksheet?
  98. [SOLVED:] Delete value for some column
  99. insert
  100. Import from text file and format data in excel
  101. Tired Of To Many Cut & Paste
  102. Sleeper: Login internet and import image
  103. [SLEEPER:] Batch processing SQL query strings in VBA
  104. Solved: Duplicate Combobox Entries on Reset
  105. Solved: help w/ ONTIME
  106. Solved: Subtotal header row
  107. ExcelDiet() For Excel 2007
  108. convert text numbers to real numbers, partial Cell deleting, deleting rows between se
  109. Excel crashes when saving - emailing
  110. Solved: Syntax question
  111. [SLEEPER:] Dynamic Ribbon Button
  112. Solved: Dynamic Capacity Analaysis
  113. delete entire rows
  114. Dynamic Ranges for Charts
  115. Ignore blank cells in a named range when using dependent data validation
  116. search text
  117. Solved: Limit to 4 decimals in textbox using VBA
  118. write
  119. COUNTING
  120. Solved: Clearing Option Buttons
  121. Solved: Populate Drop Down Box with SQL Query
  122. Solved: Duplicating a worksheet
  123. Streaming via xmlHTTP to DOMDocument
  124. [SOLVED:] How to change the color of the columns in the chart?
  125. Sleeper: Conditional Formatting
  126. Text overlay
  127. Solved: logic help
  128. Macro To Not Allow Printing When Specific Fields Are Left Blank
  129. Creating a loop within a loop?
  130. concatenate text with .offset
  131. Solved: Unable to update data in db using ADODB connection
  132. how to replace part of r1c1 formula with cell value?
  133. Loop Through Subfolders And Copy Sheet
  134. Help with variable cell range
  135. Loop textbox to cell
  136. Solved: VBA for # of Rows Limit
  137. VBA for Formatting Worksheet
  138. Excel 2007 - Can not set link update to Manual
  139. Insert picture in cell comments
  140. Solved: Copy button to second sheet causes error
  141. Events planner
  142. pivot table
  143. Solved: Insert one blank row after sort 3 columns
  144. Solved: Make a Sound When a Cell is Changed to a Certain Value
  145. Solved: How to e-mail 2 worksheets?
  146. Solved: VBA Code for Protection of file
  147. [SLEEPER:] Please help with VBA project
  148. macro for selecting all rows with a specifice font colour in the cell and copy/paste
  149. [SOLVED:] Dynamic Variable within formula?
  150. Please help a fellow out! Feeding workbook, macro not working cuz some obscure reason
  151. Solved: Password protection for Macro enabled sheet
  152. Setcurrentdirectory not using API?
  153. Solved: Compiler error: Object required.
  154. Wait for a cell to be selected...
  155. Select Row Based off remote cell value
  156. [SOLVED:] Canceling a BeforeSave Event
  157. Solved: Use text from a cell reference in vba code.
  158. run time error 1004
  159. Combobox
  160. VBA Macro For Column Header & Deleting Column
  161. Use VBA for totals for Pivot Chart
  162. Solved: Refering Sheet without using Sheet name in VBA Code
  163. Solved: I'm new and need some help with some cell editing in vba (Excel)
  164. Solved: 3 mulitilink comboboxes
  165. Lock the column in sheet irrespective of sheet either in protection or unprotection
  166. I need to use a list rather than hard coding criteria and duplicating the code
  167. VBA: Blank Cells Based on Value
  168. Solved: Type mismatch "rumtime error 13"
  169. Solved: Write out class data
  170. Solved: comboboxes on a worksheet
  171. Solved: Help with a formula please
  172. Solved: move between cells on a filtered list
  173. Solved: What are good effective ways to error handle and bug fix a macro in ms excel?
  174. Position ListBox scrollbar
  175. Pull info from Outlook to Excel
  176. How to create Login & Log out Spread sheet in Excel with automated Attendance sheet
  177. Solved: Disable the move or copy sheet
  178. Help with Sort macro based on Data Valiation value
  179. match backwards
  180. Solved: VBA to post data to a servelet?
  181. Solved: how can a textbox with date returns to the same textbox after error handler.
  182. Macro To Not Allow Saving As When Specific Fields Are Left Blank
  183. Macro to link more than one spreadsheet and automate
  184. Strange Date Formatting!
  185. Solved: Chart
  186. Solved: Copying data from another workbook which name is unknown
  187. Solved: Adding two month to the current date.
  188. [SOLVED:] String with String
  189. Solved: Help Needed in debugging
  190. Solved: Conditional Concatenate?
  191. Solved: Changing Ranges
  192. Solved: Write data from sheet into DBs, then into files
  193. Compare Rows from 2 diff WSs and combine on 3rd sheet
  194. append specific cell values from multiple identical sheet in a single excel file
  195. Underline two besides laying cells in table
  196. Solved: "Attaching" and sorting arrays?
  197. Use VBA to add text from a cell to an existing freeform shape
  198. Excel Database
  199. [SOLVED:] Automate Grouping
  200. Help creating macro
  201. use VBA to create a custom marker for a plot or chart
  202. Solved: Small Update For Solved Changing Ranges
  203. Solved: Macro adding cells together containing the same text
  204. [SLEEPER:] Conditional Formats "Cell Colors"
  205. Solved: columnstacked chart problem
  206. Solved: VBA Search
  207. how to create login id and password
  208. [SOLVED:] get server time
  209. text in ColumnHeads
  210. Solved: Toggle button to hide/unhide worksheets
  211. How to Indentify ODBC drivers installed on a Machine using VBA
  212. Loop formula to remove last letter of productcode if it is a letter
  213. Function returning multiple values
  214. Solved: Duplicates... How to Count and Add Them.
  215. Solved: bypassing the Compatibility Check in Excel 2007
  216. Graphic Getter and Code Creator
  217. [SLEEPER:] Unique Only Count
  218. Pivot table Help
  219. Getting on track with array's
  220. VBA Conditional Formatting
  221. Solved: Conditional Formatting with VBA
  222. Macro for Special Copy Paste Format
  223. Macro inserting rows between two columns containin a specifict text
  224. Looking for coder, easy project
  225. Solved: array function help
  226. VBA code to email different attachment to different person using outlook
  227. Accessing Object methods/properties error
  228. Solved: Copying files to specific folders, determined by file prefix
  229. Strange lag when using classes
  230. Excel Macro not working correctly HELP!!!
  231. Programmatically creating Hyperlinks to File Names/locations from VBA & Excel
  232. VBA to create folder and Save As the file
  233. Convert Rows to Columns
  234. Solved: Search within a string
  235. Only highlight wrongly capitalized
  236. loop through range upload to database
  237. VBA: Entire Row Color
  238. Solved: Hidden Ribbon
  239. Solved: Macro: Delete Highlighted Rows
  240. Solved: Explain Code Please
  241. how to convert row range to column range?
  242. Range of Cells Color Change depedent on another Cell!
  243. [SOLVED:] Autofill Rows Dynamically
  244. Solved: How to Insert Code into This Workbook Mod
  245. Sleeper: Code issues
  246. Force enableventes=true
  247. Store data in DB
  248. Copy filtered and non filtered data
  249. Time lapse
  250. Date Picker