PDA

View Full Version : Excel Programming


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 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309

  1. How do I search down column to find first and last date before "Week Total"?
  2. text to coloum
  3. Displaying Cells Automatically?
  4. row pushing macro
  5. Combo Box Form
  6. Deleting contents of a cell based on colour of the cell
  7. XML Schema problem
  8. make me less ugly please
  9. how to skip #N/A
  10. Combining multi-rowed data into 1 row
  11. Scraping Data from Web Into Excel Using VBA
  12. ComboBox
  13. Type Mismatch
  14. Findnext not working
  15. subtotals in a sheet
  16. Import Data from Foxpro
  17. Excel displays dotted lines.
  18. Moving opyion button values??
  19. Pasting Content, Format, Col Wdth In One Click
  20. Save file to different location
  21. Best way to do the following
  22. pulling my hair out!!! page layout?????
  23. HELP: Extract x data from 1 sheet to another
  24. Multiple Criteria
  25. help!! block if without end if.
  26. Userforms - 2 questions
  27. macro opens directly
  28. Page Layouts
  29. Left-click when right-clicking
  30. Recorded Macro with Pivot table
  31. Make a MsgBox show the value of a cell in a closed workbook
  32. DDE link to Excel
  33. data conversion from month to weeks
  34. Read text from a file with out importing?
  35. Specific cell value from web table
  36. I'm missing something in this code.
  37. Excel to Access: Updating records
  38. Find within a Find - Tough one... for me.
  39. Save workbook name then clear when finish.
  40. Sum totals according to font colour
  41. a macro question
  42. Loop Macro
  43. finding a workbook path
  44. Inserting text into part of another cell's text
  45. switching to landscape
  46. Window count
  47. Spyware?
  48. List all available printers
  49. Dates back to front - how to control Date format?
  50. Macro to read all data
  51. print area???
  52. Auto sort
  53. Do...Loop
  54. Importing multiple fields from different excel spreadsheets
  55. using evaluate with today()
  56. Excel chart and VB2005
  57. Need some code help please.
  58. Hiding and unhiding column automaticaly when a cell value changes
  59. Validation List VBA
  60. GetOpenfileName use?
  61. Excel and Word Relationship
  62. Selecting Range
  63. Convert Capitalization?
  64. Passing Datepicker info
  65. Building table
  66. Find and copy fields from worksheets.
  67. Userform
  68. Sorting Program
  69. Problems Selecting End Range.
  70. VBA + PDF open
  71. Thanks To All
  72. select row range????
  73. Input info if cell doesn't start with "G"
  74. Change color if wrong
  75. US to UK date??
  76. I have a Saveas problem with code
  77. Date detect
  78. ComboBox_Change Event in Controls.add
  79. Need help with a link to another workbook
  80. DateDiff
  81. hiding columns using macro
  82. Macro - Move information from Sheet 1 to Sheet 2
  83. get list of all files in folder, perform action on each
  84. problem with different Excel installation Languages
  85. Switching Forms
  86. Excel to Access
  87. insert row every nth row
  88. Run Macro from Conditional Cell Change?
  89. Changing to network folders?
  90. Excel to HTML problem...
  91. Ambiguous name detected - please help
  92. Simple cell.text question
  93. Generating an Identification number
  94. To Call 2 macros
  95. Saving worksheet to Word doc
  96. Help w/ Battleship Multimedia Project
  97. Unprotecting sheet w/ workbook shared & Protected
  98. Sumproduct with Greater Than Less Than
  99. Macro
  100. Extending Column Structure
  101. Change Base/Radix
  102. Deleting every row that doesn't contain certain values
  103. Changing values in a formula
  104. Excel format - put quotation marks in cell
  105. Simple Macro Stuff - changing autofill
  106. Delete Entire Row If...
  107. Data Sort
  108. Macros with WordArt
  109. reading range n storing data in Access
  110. user form help
  111. UserForm on Sheet1
  112. Inserting a UserForm inside a Worksheet
  113. selecting the last used cell & listing
  114. Not Actual Values
  115. import with blank rows
  116. fade in/out
  117. Completely Removeing Columns and Rows from A Sheet
  118. Running Macros Automatically
  119. Copy data from one sheet and paste in new row on another sheet
  120. ERROR: Could not load an object because it is not available on this machine
  121. Require formula for week ending calculations
  122. Why is my UDF called
  123. Conditional Formating?
  124. Excel Macro help needed!
  125. SendKeys ??
  126. Option button Problem
  127. Saving a spread sheet for a different date through a macro
  128. forms dont work in vba help :)
  129. The "=" character ban
  130. Setting a default format for controls
  131. Cell Input Restrictions
  132. Delete rows from another workbook
  133. Simple concatenation problem
  134. To Irhodes
  135. Varient-Length String
  136. Format Decimal Place
  137. Quick Question On Offsets
  138. Disable or lock columns
  139. Vlookup Help? Please!
  140. Sheet Protection & Insertion.
  141. OnClick A Certain Cell Subroutine
  142. More Than One Data validation For the Same Cell
  143. Highlighting the contents of a cell
  144. caption + 1
  145. VBA Code for Invoicing
  146. How to automatically delete rows which dont match criteria
  147. Help with Option Buttons Please
  148. Please help...Assigning Macros to command buttons
  149. Activating worksheet after pressing button on userform
  150. Alarm Clock or reinventing the wheel
  151. Another Question
  152. Easy one I think?
  153. Display a message while a macro is running
  154. Error Massage If Time Already Assigned
  155. Seletion Division
  156. Space Problem
  157. this is a tough one; experts only ;>]
  158. Stock List
  159. This is probably an easy one
  160. test file
  161. Serialized Form with default saveas name
  162. Moving Data
  163. freezing forms
  164. Whats Wrong With My Code Please?
  165. Excel 2003 to 2000 Equivalent
  166. remove items from list box (sorry it`s a bit long)
  167. combo box???
  168. Run-time Error 1004
  169. Listbox Items
  170. Restricting data input in multiple textboxes
  171. Running a macro every 15 mins
  172. Stumped on formatting textbox
  173. Command button Enable using VBA
  174. Create private macro/function
  175. Adding a header with a macro is really, really slow
  176. applying formula to the cells
  177. inserting random numbers
  178. Select & Delete text in TextBox1 also deletes text in TextBox2
  179. Need a section on a form with a scroll bar!!
  180. Problem where MS VB editor loads
  181. Making a procedure "undoable"
  182. For next loop
  183. Code help pls.
  184. vba
  185. get values & set cells
  186. Deal with foldernames
  187. WSH in VBA
  188. VBA function not working once excel file is shared
  189. How to Kill Hidden Instances of Excel
  190. BeforeClose Macro
  191. Hidden WS
  192. Cell check
  193. Sheet titles from the colomn data
  194. How to memorize subtotal variables?
  195. How to get cell name in VBA?
  196. Access control on Button in Excel form
  197. Vlookup
  198. [SOLVED] Hundreths
  199. vba and microsoft word!
  200. How to get pivot cell source range?
  201. Locking a Date/Time Format
  202. Refresh Pivot Tables
  203. Need Help Please
  204. Exit Do While
  205. VBA/Macro Copy and Paste from one sheet to another
  206. VBA to write Auto_Open sub into existing workbook
  207. remove files and folders in windows
  208. Comparing two sheets of data for changes.
  209. dependent validation lists; changes to one does not prompt error mssg for other
  210. Run a Macro by clicking a cell
  211. auto copying from one sheet to another
  212. copy and paste entire row in excel using vba
  213. Mcro help and suggestion for refenence manuals
  214. Offset
  215. Inexplicable 400 error
  216. Date workbook changed
  217. button with a counter
  218. Finding Records
  219. copying entire row from one sheet to another
  220. remove item from listbox
  221. Prompting on due dates
  222. Data Grid control
  223. switching between workbooks
  224. Help with compare formula
  225. Selecting a Folder or Subfolder
  226. Error
  227. Excel Macro Help
  228. formula
  229. Need Help Please
  230. Works in Excel2003 -doesnt on older Excel Ver. How to fix this code?
  231. Help protecting Multiple Excel 2003 WB with filtering enabled
  232. Hard Code Formatting
  233. quit excel
  234. replacing values in a variable number of columns
  235. Descending Picture
  236. Can someone pls help me with this code
  237. Command Button Password
  238. Select.Insert
  239. Error Handler for Run-time error '9'
  240. List box control in cell +
  241. Chart and groups
  242. This Should be Easy - Little Help
  243. Formatting help
  244. Date displayed in regards to last save
  245. Can someone help me with my task?
  246. Worksheet updates
  247. Variable name for workbook
  248. default property of a built-in class
  249. Sheet Tab Color - Finally
  250. checking cells in a range