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

  1. Keeping data the way it should be...
  2. Customising Comments
  3. Vlookup or Match? Copying data from one sheet to another.
  4. looking up text and cell fomat?
  5. Solved: IF...Then...Else
  6. Pivot Table Drilldown
  7. Solved: Startup template not used after 2007 Install
  8. Adding and removing Excel menu buttons
  9. Solved: working with Dates
  10. i have a problem with my user defined class
  11. combobox in an addin
  12. Arrays, searches, and replacement
  13. Solved: charts
  14. Variable Filename in Macro to SaveAs
  15. Solved: VBA Sort using the Left 7 Charaters
  16. Put code WS modules not a General module??
  17. Command Button to extract data from UserForm
  18. Using VBA to sort data
  19. Solved: too many buttons
  20. Timeout
  21. sheet and workbook called "ii????.tmp"
  22. sh.Name
  23. Solved: VBA VLookup Help (Excel '97)
  24. Combining IF criteria in DO LOOP
  25. objIE.Document.all("btnEmailConfirmation").Click , 1
  26. Vlookup result into a textbox - Help!!
  27. MsgBox and Input Box Macro
  28. Rename multiple files (add datestamp)?
  29. Solved: Subtotal Method of Range Class Failed
  30. Transfert fron cell with condition
  31. Rich Text
  32. copy contents of each Workbooks with Different data ranges from a Single Folder
  33. How to increase the speed
  34. Challenge manipulate Pivot-table from cell ranges
  35. Solved: Excel 2003 - VBA Userform help
  36. Count occurrences in specific column
  37. Solved: If command
  38. Solved: Different Functions In Same Subtotal Row
  39. Using LOOKUP in VBA
  40. Blank Cells and Filling Down R[-1]C
  41. Solved: Custom Function for Dups
  42. loop through visible pivotfields , copy to new sheet
  43. activeworkbook.name space
  44. Skip Confirmation Prompt while saving Excel file as htm through VBA code
  45. Solved: Emergency...gross margin algorithm!
  46. UserForm:ComboBox1 select show and change data ListBox and ComboBox2
  47. protecting multi shts with separate pwrds
  48. Help to Fix Program in Iraq for Troops
  49. "For Each" an endless loop, any better ideas?
  50. Solved: Active cell highlights row
  51. Use SQL to fill Data Valadation list box
  52. Updating graphs based on choice in drop-down menu:
  53. Controlling where cursor goes to next after using Enter key
  54. Lock OLE Excel object (VB6)
  55. Staff planner- Got more ideas from my employer
  56. Inserting image to Cell from User Form
  57. Automatic alphabetic scrolling in a listbox
  58. Restrict Cell entry to minutes and seconds only
  59. On Key events
  60. Slow Save, and the File Size Kid.
  61. Set the Workbook_SheetChange to False ??
  62. Solved: shortcut assign
  63. Solved: Help with formula please
  64. Solved: User Form question
  65. Unable to register/reference DLL
  66. select column by referencing column title
  67. Inserting Hyperlink Diagbox Value to Text Box
  68. 'Update Values: datasheet.xls' problem
  69. Solved: Reversing the order of rows???
  70. highlighting minimum and maximum values
  71. Speeding Up HTML Table Import
  72. Solved: Excel generate calendar appointments in Outlook.
  73. Solved: Date Formula
  74. Solved: Selecting last row of an active column using a single macro
  75. Fit Table content
  76. Qty and Time based lookup
  77. Solved: Unwanted Events firing
  78. Select Case with multiple dependencies
  79. The code works, but the address is "WEIRD"
  80. macros on web
  81. excel failed to access some objects.
  82. Solved: Linestyle constant values
  83. value for a specific zip code
  84. Addin References
  85. Solved: Compare Cells within same row for whole sheet
  86. Solved: default macro
  87. Solved: Help Matching String Patterns
  88. Solved: UserForm;ComboBox;FilterData
  89. SUMIF or Vlookup - How to use in with Range Offset
  90. row selection
  91. userform toolbox
  92. Conditional colouring
  93. Solved: Finding local maximums in same cells on many sheets
  94. Solved: copying comments
  95. Values used for multiple button clicks
  96. Get a value from a cell
  97. Next With out for error
  98. VBA can not use Mshflexgrid.ocx SP6
  99. Passing a value to another sub routine
  100. CASE Statement type mismatch
  101. Open all files in a directory and merge to one file
  102. Solved: Excel ShapeRange.Align
  103. sum rows based on column criteria
  104. side by side stack charts
  105. Solved: Pagesetup.PaperSize
  106. Phantom MsgBox
  107. Solved: But it was working 5 minutes ago....
  108. Solved: Problems with GetOpenFileName
  109. Solved: Checkbox with userform
  110. Solved: substitute "." with "" and give format
  111. Merging text from selected range of cell
  112. Basic FTP upload problems please help, kinda urgent?
  113. Solved: DAYS360 function within VB
  114. force enable macros
  115. Macro Help
  116. Create a working CommandButton in a Userformusing VBA Code
  117. Worksheet_Calculate() Multiple Ranges
  118. Unhide based on Calculate event
  119. Solved: should work but doesn't - application.inputbox problem?
  120. User Form Looping Problem
  121. UserForm;ListBox Select show Picture
  122. Dynamic Group by, with Subtotal and Grandtotal
  123. Hide/Uhide rows without macro
  124. Updating external reference of a picture
  125. Pop Messag Box required if value is different
  126. Last non-blank cell in a row or column
  127. Solved: Convert number to letter
  128. Deleting all rows of named merged range
  129. Solved: Macro will not save
  130. Solved: Code added by VBA ends up on wrong sheet?
  131. Error: 1004
  132. Export Problem
  133. How to automaticlly disable a spreadsheet after a period of time
  134. Solved: Merge Workbooks
  135. check for the values in the sheet 2 and count the values
  136. Hide / Unhide toolbars for a particular worksheet
  137. Solved: Error '1004' pops up randomly
  138. Solved: Count Files in folder & cell.value=NewFile.Name
  139. Solved: Naming a File
  140. Solved: Clearing Clip Art
  141. how to use vara function in vba
  142. Solved: Only save with a Macro Button
  143. Find function
  144. Solved: Show asterisk(****) in password VBA code
  145. Error Checking for EOF / BOF Debug
  146. code does work at home but not at work ><
  147. days of the week
  148. Formatting of data from text file into Excel File.
  149. counting data
  150. How to find an error in my VBA !!
  151. Solved: How do I copy and insert rows
  152. Replace fonction vba
  153. Solved: Validating entry on a userform (Excel '97)
  154. Trouble Looping to eliminate multiple data
  155. Solved: Shifting rows to the right.
  156. Solved: disable calculation
  157. top 5 and top 10
  158. Solved: Updating an access record from an excel userform (excel '97)
  159. Transferring data from an array to a range - strange error
  160. Solved: Moving data to a Word document
  161. Solved: Loop through sheets
  162. VBA HELP- Opening another file with title equal to a cell entry
  163. Solved: calculation
  164. Solved: Command Button Naming
  165. Insert Photo in Cell, using Userform
  166. Help with macro to copy and paste based on formula result
  167. Solved: Code Select Sheet &amp; Range single step
  168. Lookup Nth occurrence: cells formats
  169. Solved: Get values from cell with VBA
  170. Error when Export data into Excel
  171. Loop into Excel
  172. Solved: Where to put additional code
  173. Apply macros on filtered columns
  174. Need help clearing (removing) buttons
  175. Macros match / Lookup
  176. Solved: Unusual Error Trap
  177. Word frm to Excel
  178. open/activate book and edit without readonly -query
  179. Solved: Copying Formula Results
  180. Solved: Selecting subtotal and grand total cells only(not entire row)
  181. Change the Background Color of button added to worksheet using vba
  182. Solved: paste from multi sheets to 1
  183. Inserting, Renaming and Moving/Sorting Worksheets
  184. Solved: find blanks= 0
  185. Apply only the Font part of a Style
  186. Solved: VBA code to copy rows from one sheet to another based on 2 criteria?
  187. Solved: more efective sumproduct
  188. Solved: Need help with Click Event of OptionButton / CheckBox
  189. Copy to closed wbk
  190. ReadOnly Column
  191. Solved: Subsciprt out of Range Error with Mulitple Workbooks
  192. listBox Issues
  193. Run Time Error 13 Message, very strange !
  194. Compare Numbers Strings Using VBA (multiple criteria)
  195. range to array
  196. Solved: Help w/ simple 'For-Next' loop
  197. Solved: How to subtract cell values
  198. Help W/AutoFilter
  199. Download a txt file from Website using excel
  200. Simple VBA question
  201. Newbie needs help with "slideshow" macro
  202. How to pass an Array in a Class Module?
  203. Solved: Merging columns
  204. Solved: Insert URL Image
  205. Extract all workbooks cell names and formulas in a spreadsheet
  206. Inserting Pic with other Data Entry Field.
  207. Solved: Shifting cells to the right????
  208. Update data from text file in worksheet starting at particualr cell.
  209. "Enter" textbox upon UF initialize
  210. How to use IsMissing when the optional parameter is integer?
  211. Help tidying up some current code that causes errors
  212. Solved: OLEObject Click Event
  213. Please Help W/Conflicting Codes
  214. Solved: CSV Files
  215. Solved: Universal error trap
  216. Solved: AutoFill Macro
  217. like comparason
  218. Passing variables not working
  219. Import the text file data into different worksheet of xls based on certain value.
  220. Dim array in userform
  221. Empty cell in a selection
  222. Showing and Hiding a picture
  223. running a macro on an otherwise protected workbook
  224. Color Rows or Colums
  225. Solved: Comma Delimited Data Arranging
  226. Modify "Errors
  227. excel add-in document properties
  228. Solved: DSUM
  229. Solved: If Question
  230. Delete an Access table using vba
  231. Solved: Column Values Duplicate
  232. Method 'Select' of object '_Worksheet' failed
  233. MultiSheet Print Preview not including Charts
  234. Moving data from rows to adjacent columns
  235. Solved: Secure workbook by finding a file
  236. Solved: Merge rows with same Info in to one
  237. isnull problems
  238. Solved: Cut and paste into new sheet
  239. problem comparing rows and copying result to another sheet
  240. Solved: “Move Select After Enter” Problem
  241. Solved: Add Sub-Folders
  242. Solved: Macro to make duplicates to be displayed in one row
  243. I need help referring to last and first sheets
  244. Solved: Shifting rows????
  245. Solved: VBA not reading .Value
  246. Solved: in Excel 2007, pasting to visible cells only
  247. progress box
  248. ComboBox;Filter value
  249. Vlookup in vba
  250. Solved: Create button which is always shown in excel