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