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. automatically running a macro by selecting a worksheet
  2. What's the Difference?
  3. Starting a Macro After Another
  4. Button on toolbar
  5. Move data to column A
  6. Copy highlight cell to another worksheet
  7. range of cells
  8. Basic Information
  9. assign a shift a specific value
  10. Error 91, Object Variable or With Block variable not set.
  11. Count by Color and Text in a cell
  12. Userform drawing tools
  13. Sort a row
  14. Sortering & transfer rows
  15. need scripting help, dont kn ow anything
  16. VBA Code for Comparing Entry to Range
  17. variables
  18. DDERequest DataType
  19. Summary Sheet from Data Sheet
  20. DialogSendMail not working abroad
  21. Calendar Control Problems
  22. how to create a excel sheet from excel programming
  23. Count worksheets
  24. Getting values from function to stay on reload
  25. extraction
  26. combo box
  27. Corolate data across multiple worksheets
  28. Formula in variable
  29. Macro
  30. Move values from column A to B
  31. Cancel VBA if WorkSheet name changes ( gets saved as )
  32. I need to change positive values to negatives
  33. Problem with Form
  34. Array of Controls
  35. Userform question?
  36. button colour
  37. Combo Box listing external filenames
  38. Customizing Imported Text
  39. Newbie with problem (duh!)
  40. variable fill range
  41. Unable to get the pivotfields property of the pivot table class
  42. Adjusting formulae when copying down?
  43. Working out the number of items in =1+2+3+4
  44. hide sheet
  45. Protection
  46. group rows
  47. Dim an excel table as a HTML object
  48. Save to folder defined by cell
  49. My code crashes excel
  50. Workbook help
  51. create a form that allows selection of a range
  52. Looping through rows in range AND comparing range cells
  53. Hyperlink on a label on a form
  54. How to enter an array formula?
  55. Highlight Part Of Cell Based On Input
  56. Loop Without Do Error
  57. photoshop manual?
  58. Using a macro to search for text within a cell and then add more text to that cell
  59. Change Chart Series values in VBA
  60. Declaring
  61. search a column knowing a cell
  62. Window Date Format
  63. Compress files without WinZip
  64. Command Buttons in Cell
  65. data position
  66. Find and Replace text
  67. VBA conditional formating
  68. Setting variables based on controls
  69. Macro to find dates past due in a column
  70. Searching Based On Contents Of Changeable Cell
  71. check if a cell is a number
  72. Quick delete row question
  73. Data transfer and save
  74. 1904 vs 1900 time systems
  75. find function in macro
  76. Protect worksheet Message
  77. Trouble closing a workbook
  78. Passing the name of an array
  79. Hash (#) Key and other function pieces
  80. Conditional select and save rows
  81. Run Time error 1004 in Excel Macro
  82. Macro to create new sheets from master data sheet
  83. Copying workbook without saveas
  84. "READ-ONLY" Message
  85. Opening a Long URL
  86. Macro - VBA
  87. program running too slow
  88. vlookup worksheetfunction call from VBA not working
  89. Establish cell contents
  90. login form
  91. runtime error 9 problem with this code
  92. IF statement
  93. Data Analysis Plus
  94. Custom Buttons from 2000 to 2003
  95. Custom Menu - Shared
  96. list of excel files
  97. create a function
  98. multiple sheets to on
  99. Running Macro after Pivot Event
  100. x = a cell in a closed workbook
  101. Faster way to search for dups?
  102. Macro to remove rows
  103. Finding the sum of Duplicate Rows
  104. multiline Input Box
  105. Populating a list box or combo box on a User Form
  106. Null Statement
  107. Looping Problem
  108. Chart Drawing with Combos
  109. Autofiltering on date
  110. Unable to get the RowRange property of the PivotTable class
  111. Converting Columns to Rows
  112. Formula for changing a cell based on a filter.
  113. Pulling Apart Rows - Part 2
  114. Hidden Sheet with Password
  115. Run time error - 1004
  116. Timestamping
  117. Wierd Problem with select
  118. help on excel using vba
  119. Variable not defined error only on exit from Excel
  120. Highlight cells as cursor passes over them
  121. OMG! Why Wont Value Change!
  122. instal add-in excel
  123. Somehow complicated forumla
  124. Why cannot I search threads older than 11.09.2006
  125. Echoing row data to next worksheet
  126. file name
  127. Refering to a Dynamic Range in a different Worksheet
  128. Sort Ascending Cell
  129. Opening Multiple Linked Sheets
  130. duplicate pop up?
  131. excel validation lists
  132. Date Time Picker in User Form
  133. Sorting Cell with Merged Cells
  134. Date format problem!
  135. Add today's date to tab name?
  136. Returning a combo box to its uppermost value
  137. auto dates?
  138. Solver question
  139. Nasty 400 when running web query macro
  140. Macro to copy some columns to newly inserted sheets
  141. how to refer to cell with variable in a formula?
  142. Storing Web Query Data.
  143. Can a variable be used across different Sub Functions?
  144. Hiding rows depending on data
  145. search function on forum
  146. Simplifying VB code
  147. Date Input from Pop up calendar
  148. mouse controle
  149. Merging Cell
  150. issues about excel drop-down list
  151. Multiple Userforms - Avoid code duplication
  152. VBA code & Rows or Columns insert
  153. lookup & return closest match
  154. advanced replace macro
  155. Need something like an InputBox, but only allow the user a couple of choices
  156. Help with vlookup
  157. importing text file to EXCEL
  158. Right click in listbox - special handling
  159. controls
  160. Putting Links in Email from Attached Excel File ?
  161. Is there any way to get around the long filenames error?
  162. Text Limit
  163. error handling when creating a file
  164. Changing font colour
  165. Tape Calendar
  166. calling another macro
  167. Macro Question
  168. Recursively matching sums?
  169. Help with adding to code...
  170. VBA not working correctly
  171. Move macro to next column
  172. Collection Persistance
  173. Creating a filter interface
  174. Chart X Axis Scaling
  175. Open workbook in the same directory using workbooks.open
  176. vba so I don't have to close wkbk and re-open to have it work
  177. Using input box to specify first cell in range
  178. VB delete Access rows from table on condition
  179. VB Len
  180. Code Error
  181. Open Access database using VBA
  182. print a specified range
  183. Macro to break links
  184. Select Case Statement Help
  185. Help with a Macro (MS Word)
  186. VB DDE Macro?
  187. Copy row data & formatting to a different sheet
  188. Setting Font Style in Header Macro
  189. File does not exist - error handler
  190. Displaying images controlled by combobox
  191. Deleting entire row.
  192. macro help
  193. macro to unmerge cells
  194. Correct invalid data
  195. emailing from excel via lotus notes
  196. Dynamic Chart
  197. Color cell if "Error 2042" in array
  198. Saving as a pdf macro
  199. OpenText ,What is wrong?
  200. Create Comment for arguments of Userdefined Funtions?
  201. Working with Ranges
  202. Calculating Cell Averages Based upon conditions
  203. Ranges in Macro
  204. Macro for addition
  205. countA in VB
  206. Select cell with mouse while running macro
  207. Insert Row after every week?
  208. Trigger left-click from right-click
  209. Microsoft Visual Basic For Applications Extensibility Library
  210. removing an inserted object
  211. VB Program
  212. OpenText into an Existing Worksheet
  213. specialcells(xlcelltypevisible): same code, different results?
  214. Macros to transfer specific data to another sheet?
  215. Zip file and attach to email automatically
  216. **Preventing Movement in Protected Areas in Microsoft Excel - Help **
  217. Triming data in a cell?
  218. You must enter vlaue in this cell
  219. Extract data from table and paste toappropriate column
  220. Need help for creating a list box / drop down box
  221. Easy one
  222. Convert string to range
  223. Concatenate from columns of dynamic data
  224. AllowFormattingCells
  225. Open "ANY" excel files in a particular folder
  226. HTML encoding
  227. reboot windows
  228. open and close form
  229. Appending to an access table
  230. Directory Search
  231. Using a vlookup in VBA
  232. Creating an updated work completed sheet?
  233. Part Code + part no combination for list box
  234. Specifying email address
  235. Macro to Automate Creation of a chart
  236. Saving in wrong location
  237. Need macro to move down & select next visible row
  238. Rotate and import data into SQL
  239. help finding single names from large list
  240. Create buttons to sort
  241. Copy object by value
  242. close
  243. Search - Find - Replace Macro UDM
  244. VBA Function to SUM fields in different sheets
  245. close forme
  246. range variable
  247. last record
  248. Vlookup In Vba
  249. Progress Bar
  250. data library help