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

  1. Pulling data from other excel file
  2. Solved: User Defined Function
  3. String to Date problem with VBA / Excel
  4. What is the mistake in this code ..
  5. Solved: make all backcolor white before print
  6. RAND function recalculating
  7. Partial Match
  8. EXCEL Macro+POWERPOINT:PLEASE HELP
  9. Expanding IF formula
  10. Solved: Delete all records in Access using Excel VBA
  11. EXCEL VBA DOUBT
  12. Date format problem
  13. sending rows to a list box
  14. Caller Userform (xld - question about your code)
  15. Exporting Excel Data to Word Using VBA
  16. Help - Reddim Preserve
  17. Excel Cell Color
  18. Solved: CopyFromRecordset issues
  19. Solved: setting the scroll area
  20. Solved: selecting columns using a variable
  21. How to change macro?
  22. Solved: Where to start with multiple conditions
  23. How to protect a workbook?
  24. Call upon excel functions?
  25. Solved: Error in macro - FIND function
  26. How do I make a Pivot Table query in VBA code
  27. Solved: Delete number of characters from string
  28. Solved: open event code for a Work sheet with varible name
  29. Solved: PublishObjects
  30. Saving A Form As an Image
  31. Tweaking the "Combine all Worksheets in One" VBA
  32. Solved: alpha-numeric parse
  33. Transfer named cell values between workbooks
  34. Save Workbook
  35. Solved: Missing Component(s) ??
  36. Solved: Adding select rows to a listbox in a form
  37. Creating dates
  38. Solved: filling a column with formulae
  39. Solved: unique values with sumif
  40. Don't print the data have same address
  41. Solved: Extract number after text from each cell of a column
  42. How to define my own standard colors?
  43. Doing subtotals in Excel
  44. Checking if date is weekend
  45. Simple Password Generator
  46. Copy paste
  47. Solved: Menu items created twice, but not when manually going through code
  48. Sumif , between to sheets
  49. Store date in file into another work book
  50. Solved: looping through check boxes on a form
  51. Solved: reading pdf files
  52. Basic variable type question (and maybe more)...
  53. sumproduct and abs value
  54. stop formulae from updating
  55. CounIFS with Month Criteria
  56. Interview question
  57. delete numerical values only
  58. Linking cells from separate *.xls files into a Workbook
  59. Sum bold cells rows based on below non bold cells
  60. VBA Auditting Macro
  61. Row color based on result of a vlookup?
  62. Solved: If Subtotal equal to zero delete that paticular group.
  63. Solved: finding the difference in time
  64. Copy AutoFilter Results
  65. Insert Symbol made easy... a toolbar?
  66. Make excel pause
  67. Call upon different procedures?
  68. The Excel Object Model
  69. Solved: Userform Calendar Control
  70. visible sheets count
  71. Solved: Protect Column if it is not equal to today's date
  72. Move data one spreadsheet to another
  73. print data
  74. ListBox formatting
  75. Solved: File Naming Convention
  76. Using Access for my data
  77. Solved: stop macro and restore password
  78. Solved: Delete row based on first cells contents?
  79. How to poulate listbox with data from the row?
  80. checking if sheet updated
  81. Editing decimals :)
  82. Solved: Insert Formula via macro
  83. Solved: .Find won't work!!!
  84. Excel help please.
  85. Solved: please check second part of mu code
  86. help with variable row size selection
  87. create a .txt file
  88. Opening a template in VBA
  89. User Form Invalid Property Error
  90. Solved: Numeric Time Values in VBA - Reference?
  91. Sum with multiple criteria across multiple sheets
  92. Add features to userform
  93. folder into listbox
  94. Delete all Conditional Formats but still retain all formats.
  95. Why does this code move rather than copy files?
  96. Solved: FileDialogFilePicker
  97. FIND Function Issue
  98. Solved: Find TExt in a column and give result from the next column
  99. Solved: find code alteration to search column c &D
  100. Forward thinking obstacle
  101. Solved: Set worksheet Target
  102. Userform select and copy
  103. Get row from Sheet 2 if date between certain values
  104. code to change text colour
  105. Copy from one, Paste to another, Then Save As..
  106. Solved: Date & Excel
  107. Solved: VBA code not working
  108. Solved: Formatting multiple textboxes on a UserForm
  109. cant edit cells from vba
  110. Solved: conditional formatting
  111. Solved: conditional formatting
  112. If cells have figures already then don't fill
  113. How to change the position of item in the coulmn of listbox
  114. Form Populate unique Totals
  115. Userform load not working
  116. Solved: Compare two spreadsheets and seperate the unique ones
  117. Solved: Shapes OnAction
  118. Solved: looping between named ranges
  119. Identifying textboxes with a certain text font color
  120. Forms Object Library
  121. Update spreadsheet via Form
  122. edit links & open new source file
  123. if problem
  124. How to save the item in the listbox
  125. Protection on a shared workbook
  126. Excel Regresssion Model
  127. Solved: Macro to delete the row
  128. Assigning OPtion/Radio buttons a value to use in a calculation
  129. Solved: Call Form After Cell Update
  130. Solved: easiest fastest way to copy entire rows
  131. Solved: set scroll area in copied book
  132. Solved: system primitive failed
  133. Solved: GetSaveAsFilename
  134. Solved: Userform Calendar Control
  135. Solved: object models for non-MS apps
  136. Name VB not working
  137. Excel Backend Information
  138. Solved: Only unique items
  139. Link and Calculate
  140. Copy and Paste Worksheet (+ Macro) in other workbooks
  141. Solved: ANother copy/paste query
  142. Solved: How Do I Convert Excel Row Height to mm?
  143. Solved: UserForm Refresh?
  144. Solved: Enter will run click function
  145. May you fix this code ?
  146. One VBA disables another, how to correct
  147. Using VBA to detect a specific System Process
  148. Autofilter count
  149. Excel 2007 Plotarea.Height issue
  150. To arrange macros in folders.
  151. Solved: Hide/Disable Macro Coding
  152. Opening Workbooks and Running a macro from them
  153. Data Trucation
  154. VBA code for transposing
  155. Update worksheet footer on save Excel 2003
  156. Solved: Ado connection, SQL String error
  157. Solved: Concatenate / Join two text variables in two cells
  158. Solved: List of Functions in Excel VBA
  159. Solved: Userform in system tray
  160. Solved: Text box
  161. Web Query Help
  162. Email Hyperlink Help
  163. Solved: Need to have GetOpenFilename( to work in code.
  164. Solved: format row with random selection
  165. Capturing the Undo Stack
  166. Associate 1 workbook with another to copy columns
  167. Link Outlook & excel to get date/time and subject
  168. Solved: auto data entry based on a cell value
  169. Solved: Excel Multiple Goal Seek Code.
  170. dividing numbers & blank rows
  171. Solved: VBA and Check Boxes
  172. Solved: ComboBoxes
  173. Dynamic range to account for blank cells
  174. IE Control: Switch on
  175. conditionally return number of Unique entries
  176. Solved: VB module to convert absolute references to relative
  177. Subtotal unique values
  178. Calculate based on logic of surrounding cells
  179. Problem with three ComboBox including Date item
  180. Macro that creates duplicates of a master sheet
  181. Option button properties
  182. changing imported file type
  183. IE VBA controls
  184. Solved: Transparent UserForm
  185. Check the active workbook
  186. Any way to enforce incremental numbering in columns?
  187. Inputbox STATEMENT
  188. Solved: Process All Workbooks in a Given Directory Folder
  189. A Solution To Digital Cert Not Working
  190. Solved: unique items into a 2d array
  191. Solved: Close on ESC
  192. How can I make this work
  193. append variable to file path???
  194. convert excel if condition to vba code
  195. Compile error when clicking inside a userform
  196. Disable Cut, Copy, Paste
  197. Macro to calculate values based on a column
  198. Solved: macro to change NAMED formulas
  199. Loop through a Pivot to create Charts
  200. Solved: Macro works on my PC but not on another PC
  201. Solved: VBA To Access taking too long
  202. Chart's size and border color?
  203. Problem with frame tool
  204. Working with merged cells
  205. Job Search - UK
  206. Solved: Help in handling excel sheets with data
  207. expiration date and Kill
  208. VBA Help - Looping Tweak Needed
  209. Solved: Lost folders in VBA Project window - How to get them back?
  210. Missing RowSource
  211. open url page in vba?
  212. Save workbook without macro
  213. Invalid Password
  214. Adding to existing comments
  215. Open, save and close Notepad file from Excel
  216. Solved: duplicating formats
  217. 2 dec. places becomes more than 2 dec. places!
  218. Solved: Compare Column data
  219. Problem with palcing controls on image
  220. control box: how to change the size of the font
  221. Help with "StartBlink"
  222. Solved: Cell Value Validation
  223. Solved: cancel on inputbox
  224. Solved: check if variables released
  225. Solved: print area
  226. Object required error
  227. Solved: key already associated with element of collection
  228. Create password for permanent access
  229. How to declare Namespace
  230. Using Namespace and Objects
  231. Solved: Modify code to only save one worksheet in workbook
  232. How to move the controls from sheet to userform
  233. Numbering rows
  234. Solved: Create folders in vba
  235. Help with "StartBlink"
  236. Embed Charts on MultiPage
  237. Getting information from excel
  238. Delete then Insert Procedure
  239. Remove Spaces after update
  240. Simple Macro to add Comments
  241. Solved: text in autoshape not refreshing
  242. Solved: Baseball Pitch Counter
  243. Solved: select case problem
  244. vba webqueries (?)
  245. macro required
  246. mouse over cell -> listbox
  247. List Box
  248. Solved: assign macro to toolbar button using code
  249. Solved: Auto-Macro based on Cell Change in Column
  250. runtime error 438