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