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. countif in the last 5 sheets
  2. creating/putting the same macro in multiple cells with independent function
  3. Merging All Spreadsheet within a Folder
  4. Transferring data to specific area based on date
  5. Problem with conditional formatting
  6. Updating a cell value by appending with a -1...
  7. Updation of UDF (User Defined Function)
  8. Auto change colour of cell when text / letter entered into cell
  9. Stuck with a new Object Creation Process.
  10. Macro to recognise no. of rows after deletion
  11. Append data in foxPro table
  12. String manipulation tutorial?
  13. How to stop Macro from looping
  14. Retaining leading zeros in text cell problem
  15. How to avoid 're-open' alert while opening file
  16. PivotTable Filter Update
  17. Add name to list, not in a drop down box.
  18. change all to number 3
  19. unlimited arguments
  20. Show a userform
  21. Check if contact excists in outlook and export to outlook
  22. Can VBA override the standard color pallet?
  23. Wrap ControlTipText
  24. Making third new dictionary out of two exisitng ones
  25. assign macro to checkbox placed on worksheet
  26. Run Macro in Arabic
  27. splitting one Column into many other columns
  28. Value From TextBox
  29. Worksheet properties
  30. VB "Show" command
  31. modify worksheet based on data from another
  32. How can I Run a VB Script when a Worksheet becomes Active
  33. Dialogue Box?
  34. Merge cells with values only
  35. Pause In Mid Macro To Modify Data
  36. Lookup values from a VBA form
  37. VBA Sheets Function
  38. Running pivot macro/1004
  39. Extension of previous coding
  40. TAB Color Conditional Change
  41. Auto Save As no promt
  42. VBA hide code
  43. Bringing fields from different files onto one row
  44. Checking if there's any charts in a worksheet
  45. Pivot table giving 'runtime error 1004'
  46. Multiple pivot tables based on one page field
  47. For loop error
  48. Comparing type double variables of different lengths
  49. Concatenate Rows
  50. Adding wildcards to Workbook.open filenames
  51. VBA to add highlighted cells?
  52. Alarm alert (Excel)
  53. working with row and column numbers
  54. print
  55. Delete all #VALUE! errors & cells populated with "0"
  56. userform only works on my PC
  57. Limit to number of objects
  58. A tricky search and populate question
  59. Text Only Validation
  60. Delete rows above a certain format's first occurence
  61. Reversing List in a Combo Box
  62. Help Required on VB Macro ????
  63. adding charts within a worksheet
  64. Trying to understand Worksheet_Change event.
  65. baseball program on excel
  66. Howto create a macro to generate this trivial result?
  67. eliminate empty cells in Range
  68. Absolute reference with VBA
  69. macro, if content is X replace with Y
  70. Personal Macro issue - 2 x macros
  71. Find Cell using a value from another sheet
  72. Range of one cell to the end data of a column
  73. How do you allow hide/unhide or group/ungroup features while protected
  74. what Event is triggered when user adds/deletes rows?
  75. Auto Filling
  76. Compute Month Based on Cell Content
  77. Macro to format a document
  78. Splitting Cells every time a number is found
  79. Macro to wait for Userform entry
  80. InputBox String Conversion
  81. If Statement - marco modification
  82. confining a search to 2 columns
  83. Script to auto-adjust y-axis min
  84. Protected Sheet & Allow Use Of Autofilter
  85. Password in Workbook open VBA code?
  86. excel 4 macro - page.setup
  87. Change Object Colour
  88. Initialising Arrays
  89. Table Functionality on Protected Sheet
  90. How can I use the .value code?
  91. refresh
  92. Replace Duplicates With Whitespace
  93. found and insert
  94. using excel functions (concatenate and mid) in VBA
  95. Date Macro
  96. Trouble with Dynamic Range
  97. accessing array of an userform from a Sheet/module macro code
  98. Name coding
  99. cell entry restricted to text, 2-3 letters & uppercase
  100. Large SumProduct Array -- original title:Loop Function
  101. consecutive sheet name/numbering
  102. Protect specific sheets from deletion
  103. Creating custom page numbers in a footer
  104. How do I get difference between hours worked vs. required number
  105. Change the targets of many cells at once
  106. email a user form?
  107. running total of from copied cells
  108. Replace Add-In suddenly not working
  109. Sort using column number (3 instead of "C1")
  110. Disable menus
  111. convert whole number into hours and min.
  112. VB code to spreadsheet application
  113. Convert txt to xls
  114. Focus
  115. convert "november" to "11"
  116. Advice on how to input VBA code into a spreadsheet
  117. ActiveSheet change form VB.NET
  118. Virgin programer needs help
  119. Notifing user while macro works
  120. Using Dynamic Arrays
  121. macro to generate a list of dates down a column
  122. Open workbook to a specific worksheet
  123. How do I change equations for macros
  124. macro to delete the second occurence
  125. Find similarities in cells and copy from 3rd cell
  126. tying to code as msgbox if date is older than 30 days
  127. Delete all cells on a sheet?
  128. Copy & paste from cells below named ranges
  129. Array variables in classes
  130. Insert a static version of today's date that doesn't update itself
  131. Bug in Excel 2003 Application.Run with dashes in filenames
  132. Getting to Start on a New Line
  133. Drag random Cell formula to other cells
  134. Named arguments
  135. Autofilter & Macro
  136. On Cell change, execute macro
  137. Saving file to same path as open file
  138. Multicolumn listbox and display options
  139. Increase by percentage macro to filtered items only
  140. traversing file system vba
  141. Macro to manipulate graph axis title?
  142. hiding rows based on color of row cells
  143. Copy/paste charts into word
  144. string manipulation
  145. macro to populate a table
  146. application or object defined error
  147. macro to paste special values
  148. MAX entry into a Dynamic Range
  149. Convert Charts to PDF
  150. Create a public constant that defines a specific RGB color
  151. Macro for consolidating
  152. how to make a macor for calculating values
  153. macro to run every hour
  154. Text Color
  155. Opening a file with CommandButton without specifying full path
  156. Excel VBA export to sharepoint
  157. change the number
  158. Trouble Setting a cell to a value
  159. Excel restrictions while embedded in IE
  160. Automatic numbering in VBA etc
  161. Copy tick from checkbox to another checkbox
  162. Duplicate VBA Code
  163. building an if statemet with a string.
  164. Change background colour using a tickbox
  165. select and copy
  166. If statements that has #NA
  167. Use excel to automatically send emails
  168. renumber worksheets
  169. Problems with reading stuff from closed files
  170. choose 1 options then 1 cell hidden
  171. Count and insert rows
  172. Object does not support this property or method
  173. Determining relative file path macro
  174. Guide for me a code?
  175. hexa code
  176. Target with Range Shorthand
  177. Excel help
  178. Query closed Excel Workbook
  179. Insert cells based on test
  180. Problem with macro adding rows
  181. Interesting discovery with Alt+Enter and UserForms
  182. Worksheet_Change
  183. Forced Tab event on close or save UserForm
  184. VBScript to Change Chart Title Within Worksheet
  185. Dots, instead of characters in InputBox
  186. Right-To-Left sheets
  187. Macro to email contents of cell line by line
  188. Removing duplicate names
  189. simplyfy number formats
  190. stored procedure
  191. macro that would erase part of data in a cell?
  192. Set background colour depending on variants
  193. mkdir - Create folders from Excel list
  194. form won't initialize
  195. Insert Current date
  196. Macro to format numerous sheets into one
  197. edit all sheets
  198. Retrieve Data from Protected and Closed workbook
  199. Design Table for CAD Program
  200. Finding/moving duplicate entries across multiple sheets
  201. Rip Data From Outlook to Excel
  202. Complete the project of Posting VBA Code
  203. macro and pivottable
  204. Incrementing a number as string prefixed with zero's
  205. Writing a function in .xla file
  206. Form Images
  207. Adding worksheets to my macro formula
  208. Counting number of occurences in column
  209. inserting cells into a hyperlink, inserting link via macro
  210. Call macro using a data list
  211. Excel Import Help
  212. closing only one workbook when multiple open
  213. Opening file with application+prevent dos window.
  214. Delete Row from User Form in Excel
  215. finding the first cell in a certain range
  216. macro to remind doing some task before exiting file.
  217. VBA row color
  218. Use a macro within an if statement
  219. Hyperlink to Web Excel File
  220. Locate Member, Change Information
  221. Filename for Macro
  222. Macro Merge Cells with Values
  223. Retaining focus on non-modal form
  224. using part of a string from a combobox to fill textbox value
  225. VBA - Add Font Bold
  226. Replace Text from Text Box Using Replace Buton
  227. create a custom formula
  228. Macro Merge Workbooks
  229. Cell value dependent on another cell value range
  230. Can a program be written to this type of chart
  231. Setting validation rule using code
  232. macro to find copy and paste
  233. Copying Varying Data as Static Data
  234. macro for excel and powerpoint
  235. Macro to apply Borders.
  236. Weekdayname function
  237. Need help with a macro to format rows and columns
  238. Code only works when stopped??
  239. Trapping errors of =Largest()
  240. Excel 2007 macros have stopped working
  241. Password Breaker Code
  242. worksheet manipulation in excel 2007 and 2003
  243. copy > paste value as macro?
  244. macros not updating in real time on LAN
  245. Counting Satisfied Conditional Formatting
  246. Grouping Shapes
  247. How to split the lines in a cell into multiple rows.
  248. Compare 2 Strings and Bold the Result
  249. Today + 45 days
  250. plot x, y graph with cells