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

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