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

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