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