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