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

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