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