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

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