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

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