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