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

  1. Fill Column According to 2 Criteria
  2. Solved: MsgBox appears only once
  3. Install addin through code
  4. How to separate words in a cell
  5. Solved:Error when no comments found
  6. Sum
  7. Solved: Make range dynamic?!
  8. Solved: Compare multple value
  9. Solved: Vlookup returning all but one value??
  10. how to change column width
  11. If Loop to paste
  12. Open a file
  13. Need macro to delete module content
  14. Copy / Paste down
  15. Solved: User form numeric value
  16. User Form HELP
  17. Grocery lists
  18. Solved: Input box - force certain no of characters?
  19. How make ?hint? to every picture (as button) on Sheet?
  20. make the characters in password entry "*"
  21. Options for triggering macro?
  22. Solved: Delete row if object NOT found
  23. Solved: Put cell values into array
  24. Solved: File Property
  25. Transforming a doc content to Excel Table??!!Help!
  26. Solved: User form problem
  27. Solved: User Form
  28. Solved: Another userform problem - frames
  29. VBA Code for Excel sheet access denied
  30. Solved: Range autofill
  31. Count Values in List, Display Top x
  32. Trouble Closing File
  33. Delete duplicates and sum values macro
  34. select issue
  35. Solved: Transparent Toggle Button
  36. Solved: Code location issues
  37. Solved: User Id And Time Of Data Entry
  38. Solved: Run-time error 1004 ... What am I missing?
  39. Solved: Error Message
  40. Passing a Parameter from Word to Excel
  41. Select duplicates rows in a new sheet
  42. How to specify a formula for a cell?
  43. Comboboxes and VBA i excel
  44. Solved: Lookup in VBA creating Errors
  45. sever all ties & links
  46. How to tell when the 'Notify' option is selected?
  47. NEWBIE TO EXCEL FORMATTING
  48. Solved: Trying to set a cell color from a UDF _not_ a sub()
  49. Solved: Date/time format change with macro...
  50. Solved: Error on opening workbook on another computer.
  51. Word doc embedded object
  52. Solved: Excel Range for Chart
  53. Create on the fly goto sheet form
  54. Solved: Formula in whole column
  55. Can AutoFilter work with Colour based selection in Excel 2002?
  56. Is it possible to create linked cells/aliases for cells?
  57. MSFlexgrid merge cells
  58. Userform auto-size
  59. Draw a line
  60. force excel to autosave
  61. Solved: Find by cell format
  62. Reading data from a database without putting the value to any cell
  63. Open Print Properties using VBA
  64. Solved: Do not paste information on hidden row
  65. Solved: Add extra characters in all cells in column
  66. Solved: Opening a file via macro
  67. Solved: Version control woes
  68. Solved: Runtime Error 9 - Subscript Out of Range - I must be missing something...
  69. Why my Excel program doesn't work on other computer? Why?
  70. Email and Font and color issue
  71. Solved: Multiple Users input updating Master
  72. Solved: Finding date in a range
  73. Formating range of cells
  74. macro & vlookup
  75. VBA Converters for Excel 95
  76. Solved: optionbutton to set commandbutton focus
  77. Adding a menu to 2007
  78. Excel VBA
  79. Compile Error in MS Excel 2007
  80. Solved: How To Find Text In Excel 2007 Binary Saved Workbooks...
  81. Solved: Loop to check numeric in userform textbox
  82. Losing last line when readig ASCII file into Array
  83. how to copy 2 sheets from a ws to another ws
  84. Calculation based on 2 different columns and 3 different rows
  85. Continually check for next row, or check once & increment?
  86. code for inserting & Copying rows
  87. file rename in vba
  88. Solved: Fill Color issues
  89. Help needed with excel macro problem!
  90. Use of Randomize statement
  91. Solved: Group rows
  92. shift on copy or paste
  93. Excel Outlook Files
  94. Overcome Excel "Save as"
  95. Clear protected cells
  96. Solved: Skip Missing Worksheets
  97. Closing Excel
  98. Solved: Structure Suggestions?
  99. Copy Named Range
  100. find, copy, delete, paste
  101. Protection - Trial Version
  102. Import data from selected sheets of other wb
  103. Problem launching Excel using code
  104. Solved: (c) copyright - anyway to stop this
  105. Solved: Generating Payslip
  106. Solved: re-using macros and pivotTables
  107. Pivot table Refresh
  108. I want 'sum', not 'count'...
  109. Duplicate or EXTRA rows
  110. Solved: Can I select a Range of Sheets
  111. Solved: Increasing column width
  112. Macro to display who has Spreadsheet open in 'Read Write' mode?
  113. MSFlexgrid alternative
  114. Solved: Quick Question - Easy, but not for me!
  115. SOLVED: Finding #VALUE! as a value
  116. Solved: Quick Newb Question
  117. Comparing data in 2 worksheets & marking them if the respective cells donot match
  118. MS graph question
  119. Dynamic charts
  120. Copy data to Excel
  121. Validation Based On Another Column
  122. Solved: what's wrong with ActiveChart.Export code
  123. Solved: Printing Settings
  124. Open a file from ftp site
  125. Solved: display time
  126. Problem Between Test and Physical Run
  127. Solved: find match copy cells to offset
  128. Solved: Recycle UserForm
  129. Excel VBA - Allow users to choose folder to save file
  130. Importing a CSV and via Userform
  131. Solved: VBA Excel 2003 escape listbox control on worksheet
  132. Solved: Hiding and unhiding rows
  133. Hiding/unhiding worksheets with option buttons
  134. combo boxes pile up when hiding rows
  135. set the security level to "Medium" through vba code
  136. Workign with Image - Should be Simple?
  137. Password entry
  138. How to hide VBA combobox on Excel Sheet when it?s drop down?
  139. INPUT AND RESULT
  140. Solved: Print to non-default printer
  141. Default Number Format for Pivot Table
  142. Pass a variable to a user form
  143. Simple vba for tagging colored cells
  144. Solved: Registration/ Clocking system
  145. Indexing of custom - type properties
  146. Solved: Cell address : loop till 2006 data
  147. VBA Error Message
  148. Extract Unique Records & Copy to New Worksheets
  149. Solved: codename donot work
  150. Using Sheet1 and Sheet2
  151. Activate a worksheet
  152. Create a control dynamically with an event and progressbar
  153. Name a range with For
  154. Solved: Transpose in diffrent rows
  155. Find lowest bit in an integer
  156. ForcePasteSpecial: getting an error...
  157. Solved: How to align selected embedded chart?
  158. Solved: Workbook open problem
  159. Looking up Access database
  160. Solved: keeping format when copying
  161. emulate the satuesbar
  162. Run Time Error 1004 Select method of range class failed
  163. Not able to assign a whole range as a series to a chart
  164. seek help for VLOOKUP
  165. Renaming excel files which have embedded macros
  166. Pivot table in VB
  167. Solved: If duplicate count is
  168. Solved: Problems with my Combo Boxes
  169. Setting a filename as a variable
  170. Solved: Minimizing Excel
  171. Solved: Look-up table: Please help me
  172. Excel and Outlook Global Address List
  173. Solved: Generating Payslip 2
  174. 2-D Vlookup?
  175. Text to column macro
  176. Solved: auto email 2 sheets on workbook close, timing problem
  177. Problem with TxtBoxs and MsgBoxes
  178. Always On Top
  179. Multiple CSV Import
  180. Solved: Setting criteria field on autofilter
  181. Inputbox & Time
  182. Solved: Specifying column width in sheet
  183. Help: How to lock sheet but still let macro edit cell
  184. Solved: Vlookup returning reference values - but only one??
  185. Solved: How To Convert A Date/Time Serial Number
  186. Solved: Month building code issue
  187. Quick Vlookup Theory Question
  188. Solved: Just a bit stuck
  189. active box on a userform
  190. For Next loop error
  191. holiday form for employees
  192. Solved: Offset help
  193. Input specific data into word
  194. Indexing Class Module Properties
  195. Printing different files from a Folder in Excel
  196. VBA Excel Solver
  197. Solved: Can you 'export' a macro?
  198. Solved: Timer
  199. Solved: Can I 'pull in' a worksheet from one excel file into another one?
  200. Solved: How do I?
  201. Click The hyperlink provided in a cell of a table
  202. Solved: Automatically start the macro in 15mins
  203. Checking to see if other sheets are open
  204. UDTs and Collections
  205. Solved: How to password protect the VBA Code
  206. unable to fetch the data from excel sheet based on a given condition.
  207. Auto sorting validation list
  208. Read a Text file with delimiter as comma and import the infor into excel sheet
  209. Returning value needs to be changed.
  210. How do I best integrate and Excel workbook with a website for data capture?
  211. Copy cells from Excel and Paste Special in Word (Clipboard problems)
  212. Do not know how to use "Findnext" command
  213. Solved: Can I 'pull in' a worksheet
  214. Run Time Error 91
  215. Solved: Run-time error 1004 (macro export/import?)
  216. Solved: delete everything other than
  217. Solved: transfer jpg file to Excel
  218. Solved: Help in tabbing
  219. Unlist Table
  220. Restore "lost" custom menus?
  221. Solved: Set range variable to cell above hidden rows
  222. Private ComboBox Event Subs NOT staying private?
  223. finding the Index value
  224. speeding up the code
  225. need to find the cell which intersets the fixed row and a variable column
  226. Solved: GetSaveAs not actually saving?
  227. Time calculation on specific days
  228. Solved: How to run a marquee text in Excel
  229. Creating employee schedules using preferences
  230. Solved: Viewing a text file from within Excel
  231. Text Edit Mode
  232. Solved: automatic convert to upper case
  233. auto add column
  234. Syntax for 'LookUp' command? Help...
  235. Solved: Run Macro When Worksheet Is Selected
  236. Solved: VBA Character colour change
  237. Solved: Macro to match name & date and move info
  238. Solved: Toolbar has no label
  239. Solved: Numpty question, but I'm not too proud to ask for help...
  240. how to find the first date?
  241. Solved: Print Multiple Pivot Charts on Single Sheet
  242. Code goes into a infinite loop
  243. Excel UK Conference 2007
  244. Fetching excel data based on a given contd.
  245. Solved: Count Data Then Send To Correct List
  246. Question re Form option/UserForm
  247. multicolumn combobox range
  248. Update records from user form
  249. Copy cell format, formulas, and insert new row
  250. offical excel vba tutorials?