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: Help using the RefEdit Control
  2. Solved: Looping through workbooks instead of worksheet
  3. select/use active pivot, vba
  4. Code crashes when closing workbook
  5. Find and Replace Loop
  6. Solved: Manage similar events with textboxes
  7. PDFCreator Problems with Excel
  8. Solved: Excel Division
  9. Solved: Changing Number Format of Variable Values
  10. Form Opens Multiple Times
  11. Solved: ListBox ,select wbkb, open in Sub
  12. erase #value!
  13. Code Error's
  14. Protected Worksheet - Excel bug?
  15. Solved: Match across 2 columns
  16. detect changed cell in a column
  17. Solved: Copy Method of Worksheet Class Failed
  18. Solved: Listbox - Double Click to add data into userform field
  19. Macro causing Excel 2003 to crash (code included)
  20. Solved: CommandButton on a worksheet
  21. Making command buttons visible
  22. Cheap Code Writing Digi ID besides Verisign
  23. Solved: Copy Rows w/in a Range Only if Condition Met
  24. Schedule Event on First Business Day of Month
  25. Solved: Cell Reference
  26. Solved: On Error Goto Failing
  27. Copy/transfer data from one sheet to another
  28. Stop Excel Showing
  29. Lost - asFormula2 = asFormula2
  30. Group by string value and perform operation
  31. Solved: Summing same row twice.
  32. For Next Loop problems
  33. Solved: Vlookup , not working, returning wrong values
  34. Solved: Disabling Messages In Excel During Macro Runtime
  35. Shrink VB Code
  36. Solved: counting unique in vba
  37. Delete if duplicate
  38. Use cells for network paremeters in formulas
  39. Select a range by using a input box as a number
  40. Solved: Simple loop not working properly
  41. Solved: how to display a cell value in a userform
  42. Solved: Copy data into next empty cell
  43. Solved: Delete specific cells not entire row
  44. A question on User defined function
  45. Userform Opacity
  46. Solved: New to VBA - Help me in making this code shorter and better
  47. Solved: Need some help with coding
  48. Solved: Check Box
  49. Solved: Need to insert formula using macro
  50. Workbook Path - minus one folder
  51. Solved: Count rows which are identical with a cell
  52. very simple but stumping me big time
  53. Solved: Fonts to shapes? Possible?
  54. In need of a test vba to insert a value based on a date
  55. Solved: simple Instr doesn't work properly
  56. A toggle button to highlight/unhighlight cells with formulas
  57. Collection
  58. file created date
  59. Solved: Probably So Easy It's Embarassing!
  60. Solved: Clear content of a merged cell
  61. Correct workbook name
  62. Solved: VLOOKUP in VBA not working
  63. List tabs
  64. How To Program Excel VBA code using VB.Net???
  65. Code Tweak - PivotTable, Find
  66. Agents sheets
  67. Solved: How can I copy a UserForm (and Module)?
  68. unhiding all rows in all worksheets
  69. Solved: Force shape to be inserted in middle of cell
  70. Loop Help for Newbie
  71. Copying using a loop
  72. CONSOLIDATION Formula Challenge
  73. Solved: Count non-identical codenumbers in big file
  74. Solved: Cross-Reference Two Cells Using Userform with RefEdit and Hyperlink
  75. Solved: Setting Variable Equal to Cell Value
  76. Macro to show shape based on adjacent cell outcome
  77. Solved: Rearrange elements within 2D array randomly
  78. Solved: I need somebody to fill in the missing part in this code
  79. vba copy
  80. Solved: Date picker userform - the size is changed
  81. Solved: Changing rows to columns????
  82. Solved: Copying a cells "formating" into text
  83. Help with Finance calculation please
  84. Find Record
  85. Vlookup formula entry
  86. Solved: how to search cells in a column for a text string
  87. sum with several matches
  88. Loop to create number thru all sheet
  89. Solved: Error in sequence of data in treeview
  90. Read Only file - Stop from asking for Save
  91. Solved: Sumproduct Text Value
  92. Solved: How to selct sheets starting with certain word
  93. Solved: time1 < time2 + 30?
  94. Hide rows based on particular cell value
  95. macro triggered by row insertion
  96. Macro to copy value in another sheet in certain manner.
  97. Solved: Cell Color change Vlookup
  98. Solved: Trigger a Validation based upon a cell value
  99. Solved: Countblank Named Ranges
  100. make list by using countif
  101. Solved: Forms in VBA
  102. Solved: Opening form
  103. Solved: Preventing Workbook & Sheet Protect
  104. Solved: Request simple test in Excel 2000
  105. Values as per the combination
  106. Working with more than 65000 rows and Pivot Tables
  107. sendkeys question
  108. Solved: Find a cell, copy, paste and delete
  109. Solved: Tree Nodes as links
  110. code not working
  111. Get value of FillColour button
  112. Solved: Copy & Paste data between 2 workbooks
  113. ControlProperty
  114. Find and replace
  115. Solved: Find a cell with date<actual and delete row.
  116. Migrating Excel Table to SQL Server 2005
  117. Solved: AutoPrint a worksheet
  118. Solved: VBA Excel Question
  119. use code on a new workbook
  120. userform problem
  121. Is it posible to use range("CR:CR").Find(value) to find a value between two numbers
  122. Copy and Paste from other Workbooks with conditions
  123. Solved: Populating a Listbox (ADO method Access '97 into Excel '97)
  124. Error: The subject is not trusted for the...
  125. Solved: A basic script going wrong
  126. Solved: Will there be VBA in Excel 2009
  127. Passing data from VBE to a range of cells
  128. Solved: Referencing a Name Range with VBA
  129. republish sheets to html
  130. VBA to open excel file one sharepoint, copy the info and move to another work book
  131. Dynamically adding Calendar dates to table
  132. Excel VBA/Email help
  133. Solved: Compare Column Data
  134. open form according to active workbook
  135. Automate Data Entry with Excel
  136. How to sign digital certification by script or code?
  137. Solved: LOAD/UNLOAD Pictures from/to Excel <> Access database
  138. Solved: VBA to search then copy found data
  139. Solved: Transfer separate ranges to one range
  140. Quick CountA question
  141. Report Generation
  142. hyperlinks in excel
  143. Pass User defined Type between two open Excel workbooks
  144. Help with a matching code
  145. Solved: Some Sort of Lookup?
  146. Solved: creating pie chart with data from Access
  147. Solved: The Dreaded #REF!
  148. Copy and Paste from worksheets within Workbook
  149. Losing datagrid and flexgrid
  150. Sorting in a Protected Worksheet
  151. How to clear repeating attachments
  152. deactivate macro after "save as"
  153. copy imported data into other sheet
  154. Subtotal or pivot table using date fields
  155. Macro with sum formula
  156. Solved: Problem using PDFcreator 0.9.7 with Excel 2007
  157. Solved: lookup for part of a cell
  158. Solved: MOD formula
  159. Data Types in Cells
  160. [SOLVED] Solved: vlookup error 2042
  161. Solved: help with excel vba...
  162. Copy String up to the 3rd Space
  163. SOLVED: Run macro all all open workbooks with one exception
  164. Solved: Run a program from VBA, and capture output
  165. Exploring Userform Capabilities
  166. Solved: Unique Defined Named Range and Validation List
  167. Solved: How to find/calculate height & width of chart title in Excel VBA?
  168. Run macro on cell text change
  169. Solved: Ungrouping Columns if the exsist
  170. Solved: with named range conditional format
  171. Solved: Date not updated from the calendar popup
  172. Merging 2 identical tables - Access 03
  173. OLAP cubes and Pivot Tables
  174. Date Format Issue from Input Box
  175. Solved: wkb.close
  176. Solved: UserForm Checkboxes
  177. average letter grades forumula
  178. Where's the Bug
  179. help with listbox columns...
  180. Importing External Data with new DB query
  181. Solved: = <> vba case sensitive
  182. Running specific line of macro
  183. calculating std deviation with blank cells
  184. Automatically updating into next cell below
  185. Solved: Why does this code increase the height of chart when copied as picture?
  186. Solved: How to add textbox to a chart on a worksheet?
  187. Solved: Formatting of a cell
  188. Solved: uCase, cut and paste
  189. Solved: Colour cell based on range value
  190. Copy filtered data in new sheet and name it after criteria
  191. word to Excel or Access
  192. Solved: R1C1 AND Letters - is there a way to see both
  193. Conditional Formatting
  194. Adding checkboxes to forms at runtime
  195. Solved: Copy/Paste cells into new sheet based on value list in 3rd sheet
  196. Trying to write to embedded OLE Excel sheet in VB6
  197. Delete formulas when unprotect
  198. Solved: rand numbers
  199. Solved: Faster way to Trim() ???
  200. Solved: Error Handling Question
  201. Solved: Use named range with combobox
  202. Solved: 12 month Update Code
  203. Using refedit in named range
  204. Copy Code from Module2 to Module1
  205. sound with vba
  206. Copying data from a series of Excel files.
  207. Solved: Why does this not add borders to the textbox added on the active chart?
  208. Solved: How do I run a macro in a form module from a class module
  209. Copying from one sheet to another and choose samples
  210. Solved: Group Data to another Cell
  211. personal.xls
  212. conditional formatting by text colour
  213. Solved: Saving single page from multiple workbook
  214. Big IF Loop Question
  215. Using a Range name as part of a function
  216. Button Extraordinaire
  217. Solved: Macro Help
  218. Simple date validation
  219. Copy and paste after looping
  220. Solved: If formula result is Zero then Blank
  221. New Instance of InternetExplorer
  222. Solved: create multiple folders from worksheet
  223. refedit range comparison
  224. Convert Cols into Rows
  225. Substitute Macro using a lookup column
  226. SOLVED: simultaneous searching
  227. Error 2147417848 (80010108)
  228. PDF Printing
  229. Count rows which meet three conditions ???
  230. Solved: VLOOKUP Problem formula not vba
  231. Solved: Format Cell Question
  232. Multipage Control in UserForm
  233. Solved: UserForm Entry Cell to Change Colour
  234. Worksheet macro
  235. UserForm within procedure - help
  236. UserForm ComboBox
  237. Very Beginner Question Excel 2003 or 2007
  238. cell within range reference
  239. Solved: Help with For Each...Next please
  240. Solved: Summary using VBA
  241. Align shapes within cells and fix their position
  242. Please help - writing simple formula in VBA
  243. Paste Screenhots
  244. Solved: Finish Data update before rest of macro runs
  245. Select a record from a combobox and add data to to the selected record row.
  246. Error when file to save is already opened.
  247. userform
  248. 1000 row filter
  249. How to hide the sub popup menu
  250. Solved: Indirect using row numbers.