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