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. Help urgently required
  2. Completely disable ctrl key?
  3. How to input quotation marks within a cell using VBA
  4. Compare common variables across two worksheets
  5. Macro to find multiple results
  6. Use Excel VBA to populate Powerpoint
  7. Variable in VLOOKUP statement
  8. automating invoices?
  9. emailing spreadsheet with hyperlinks
  10. How do i incorporate a progress bar.....
  11. reading in ascii files
  12. Save As Using Variable Data
  13. Need 1 cell to be manual & calc'd
  14. Personal.xls does not open-download into excel
  15. Running Macros
  16. Define Variable in Excel VBA
  17. copy new data using VBA
  18. Color Coding Cell
  19. Problem with shape nodes in Excel 2007
  20. text format - so cant use match function
  21. Merge multiple workbook and serperate data according to account
  22. i need some kind of loop...
  23. Ultimate add on
  24. VBA to count number of columns
  25. referencing different sheet in code
  26. Lookup & Pull multiple rows from one sheet to another
  27. True Or And statement
  28. Open workbook based on value found in range
  29. Is there an easier way to do this if_else_then statement
  30. Clearing contents of cell by cell refererance in other sheet
  31. Excel macro that uses Lotus 1-2-3 file?
  32. Comparing data accross two worksheets..
  33. Copy Header and footer from sheet1 to Pivottable
  34. SQL Select SUM() from Access
  35. Question regarding evaluating cells
  36. Filter Shows Blank Rows in Selection
  37. Connection with SAP
  38. Tab Order in Excel Forms
  39. hide the sheets by option box & check box and help for creating the message box
  40. Tab Order in Excel Forms
  41. Start search from row 2 and on...
  42. how to make a function defined in one workbook being called by other workbooks
  43. How to make a cell a variable
  44. Subtraction formula for macro
  45. Exclude rows from loop
  46. Using VB to upload to an FTP
  47. LOOPING appx 500 ++ million times, how to fasten this program?
  48. run macros on calculation
  49. Increasing Processing Speed
  50. Hide Sheets
  51. "transform-column-into-a-row" macro
  52. Search for variable and copy row
  53. Solver not running when prompted by VB code
  54. Locate a max from range defined in other sheet in workbook
  55. How can I populate the combobox from cells in an xl sheet
  56. Updating a Excel Sheet
  57. Embedd startup module in application
  58. Barcode reading program
  59. Protecting a worksheet or not
  60. Comparing to Ranges and delete the same entires
  61. Check to see if Sheet is Modified?
  62. Need Help!!!!
  63. Quick find in a sheet and table population
  64. Protection Stops Macro From Running
  65. Copy and paste variables using a macro
  66. establishing last row populated and selecting cells between first and last
  67. Create a command button to format a group of worksheets
  68. Would a VBA macro be faster?
  69. Message Box Exclamation
  70. Macro - Number as Text
  71. Use Checkbox to hide rows
  72. Is there a better way to run these IF Statements?
  73. Opening workbooks in a folder
  74. Inserting Worksheets and alligning two tables in one worksheet
  75. Bringing data from mulitple worksheets to a master sheet
  76. Parameter Query
  77. User form connectivity with excel sheet
  78. Copy range to worksheet - 1004 Run Time error
  79. Max & Min of a single auto updating cell
  80. CustomDocument Properties
  81. Stop Double Entries
  82. Macro message yet no macros running....
  83. having trouble in executing macro from other workbook
  84. Added Security to xls file in server
  85. transfer data from excel to powerpoint database chart
  86. Hiding Cells
  87. Show date recurring frequency for each week.
  88. Return MP3 files bitrate?
  89. Baffling Error during email Sub
  90. Display calculations in a message box
  91. Adding Checkboxes to Form based on how many names in column?
  92. Compare 2 columns from diff worksheets..
  93. Excel Dropdown Boxes.
  94. Opening workbook with "read-only recommended" checked
  95. How to view function result in a msgbox ?
  96. Lookup Adjacent Cell Values based on Newest and Oldest Date
  97. Locked For Editing
  98. Edit Ranges with UserForm open?
  99. Get data loop?
  100. Average with Non-Zero Value
  101. can not run my Macro total in sheets
  102. Macro to copy data from worksheet (name changes daily) to master workbook
  103. Command Button 1 code in personal VBA Project
  104. Autofill error. Quick fix needed.
  105. Extracting summary to raw data
  106. Changing / Masking Category Names on a PivotChart
  107. Get cell value from another cell based on "id".
  108. Copying data from spreadsheet to spreadsheet
  109. Using a string variable in data validation formula
  110. Message Box On Top
  111. unselect shape
  112. 4 Conditional formats
  113. Running Macros from a separate Workbook
  114. Timer Control
  115. Merge Table from serveral Files to create a new table
  116. ProgressBar
  117. macro that runs at set timings..
  118. how to execute .bas file in MS Excel
  119. Using Ranges...
  120. CDO Mail Worksheet
  121. I need to format various strings (numbers, dates) precisely
  122. Find and Replace Macro
  123. UserForm to select Row and Column from 2 prompts
  124. Number of filtered rows
  125. Code that adds new rows to a protected sheet
  126. Very slow excution time of VBA code
  127. Calender Macro in a 5 different cells or more
  128. How to order members of all cells in a column alphabetically?
  129. copy copy row of data to empty row in sheet2
  130. How to stop macro flashing sheets
  131. No Cell Selected
  132. Attendance Tracking/Time Differences
  133. Resizing Multiple Images
  134. VBA: forms and checkbox
  135. update or amend worksheet
  136. if condition
  137. Highlight Cell per Condition
  138. time difference
  139. Up date very huge data sheet every day
  140. Highlight Cell per Condition
  141. Object as variable
  142. setting parameters for a textbox? (no. of characters in each row, no. of rows)
  143. Macro To Close
  144. Run filter text file using excel vba
  145. Retrieve Weekday from String
  146. Extract first row of totals to new sheet
  147. Rename Command Button
  148. Save as file to share drive folder
  149. Limit macro conversion to only .txt files or delete existing .xls files
  150. Closing inactive workbook - without saving
  151. Excel Pivot Tables
  152. Overwrite protected files from macro?
  153. msg box to display if date expired
  154. Generate two new columns from one (no duplicates)
  155. Finding next empty column
  156. Search for a file and bring back data to a master workbook – PART 2
  157. language translation problem?
  158. code optimization for Pivot Tables
  159. test the 3rd digit over from the dot for the number 2 or 7
  160. Localising external references in Excel. Possible?
  161. Excel Forms
  162. Format Macro - apply to all worksheets
  163. Self Incrementing Macro
  164. range selection for autofill
  165. Copy specific detail from one spreadsheet to another
  166. Log updates in second spreadsheet (with date stamp)
  167. Command for Batch File (Dos)
  168. VBA link to Database help
  169. VB References help appreciated
  170. Macro for "Database Sheet"
  171. vlookup problem
  172. Pivot Table drop down change vba
  173. How to count the members of highlighted area?
  174. Turning WorkSheet Protection On
  175. Macro to copy data from one sheet to another and add date stamp
  176. Highlight Cells Containing Duplicate Document Codes In Commaed Lists
  177. Macro for grouping & consecutively numbering groups
  178. Where does the Add-in toolbox pull the name from?
  179. Compile error: Ambiguous name detected
  180. Importing multiple text files.
  181. Userform field to show existing string with ability to change.
  182. Select Case Statement
  183. Work around for .Activate?
  184. Search, Copy, Insert row and Paste
  185. macro help please
  186. Determine cell/range names
  187. If/Or function always returns "True"
  188. Macro to automatically rename row headers
  189. Leading zero problem
  190. Finding x in y=x^3+x^2+x
  191. Inhibit "File Exist" Message
  192. Comparing two columns
  193. Macro Help required
  194. Macro in loop through
  195. Comparing data.
  196. Copying dynamically from one sheet to another without blanks
  197. Help With Date Calculation Function
  198. BeforeClose macro
  199. Shared Workbook Access issue
  200. Boolean Flags - How to Set?
  201. Copying Row According to Date
  202. Separating Data
  203. Delete Rows
  204. Sum Rows without coloured filled
  205. Looping Find
  206. match like rows IF ___-and highlight them
  207. Return to User Form.
  208. big time help Need for Excel Whizzes
  209. For Loop Help.
  210. Permanent macro unspecific to workbook?
  211. function w/ dynamic inputs
  212. Consolidate data from rows in many sheets to summary sheet?
  213. Text Recognition
  214. Mouseover picture
  215. Macro / AddIn Troubles 3
  216. Executing a macro within a macro
  217. Exporting from Excel to Access
  218. More Macro / Addin Troubles
  219. Code for summing between workbooks
  220. Cleaning up code/avoid selecting
  221. Creating Backup
  222. Trouble distributing macro in addon
  223. What is the separator for VBA codes?
  224. Creating a workbook using Excel and VBA
  225. Executing without selecting
  226. MS query
  227. copy and pasting in hidden sheets
  228. use combo box to select pivot table page fields
  229. Using a list box or other control form to activate different macros
  230. Loop Through Code
  231. Radio Button assistance
  232. Using a control's name dynamically in a piece of code
  233. Splitting Date & Time Into 24 Hour Time
  234. filtering using VBA
  235. Help with Excel & Mail Merge
  236. Split text string to different columns
  237. Vlookup error
  238. Help making a "quantity updater" macro
  239. ontime function queries
  240. Working with an embedded Word object?
  241. List Horizontal
  242. Streamlining settings...by array?
  243. Need help on macro
  244. Form Wizard and Validation List
  245. IsFileOpen function not working correctly
  246. Check for Newest Revision
  247. Developing tables from data
  248. speed - variables vs copy paste
  249. Cycle through Choices as Variant
  250. Merging, sum, and compare