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 168 169 170 171 172 173 174

  1. Solved: Unwanted Connection to Macros in Another WB
  2. [SOLVED:] ShowDataForm and data validation
  3. How to make Hyperlink which will change with cell number?
  4. Solved: userform error 424
  5. Conditional formatting
  6. setting "trust access to visual basic project" programmatically?
  7. [SOLVED:] Showing Male and Female Ages on the same chart
  8. Changing Date Format
  9. macro to copy and past into mulitple worksheets
  10. Solved: Using forms and form data
  11. Get value from workbook closed
  12. Solved: Macro is really slow
  13. Sleeper: Chart title as grid
  14. [SOLVED:] dynamic chart layout
  15. Sleeper: Excel 2003 Convert to 2007 xlsm file
  16. Solved: Lookup Dates & Times
  17. Solved: Multiple replace slowing macro
  18. Chart multiple ranges from userform dropdown
  19. [SOLVED:] Spreadsheet inside a Userform
  20. Solved: Making a Collection of some Form Controls
  21. [SOLVED:] Popup Window
  22. [SOLVED:] Maximum size of String Variable
  23. Sleeper: Calculating automatically with matrix
  24. [SOLVED:] Disabling a button for specific worksheets
  25. [SOLVED:] Excel to Access Database
  26. [SOLVED:] How can I simplify my pivot tables
  27. Sleeper: Case Statement?
  28. Advice: Not filtering by given criteria
  29. Solved: Web page closes itself then opens a new IE... How can I track?
  30. How to add paste special in contex menu and make Hotkey on it?
  31. Solved: Compare Values from two sheets
  32. Can VBA do = camera to scan paper image:check marks ABCD = auto grading in classroom
  33. [SOLVED:] A command that clears all data stored??
  34. Chage background colour
  35. Scan lists and shade row with lowest number
  36. Solved: set print area problem
  37. [SOLVED:] How do i access Excel training?
  38. [SOLVED:] Save excel in temp
  39. vba with web application
  40. Solved: help in indirect function
  41. Error while sending mail
  42. Solved: Cells format
  43. Delete invalid filename characters
  44. Solved: Change background colour if cell is blank
  45. Solved: Review Code
  46. "Save As" for Excel file with Internet Explorer
  47. Solved: links in formulas to other files problem
  48. Solved: SOS !!! File/Send To
  49. Solved: Protect based on cell colour
  50. Solved: colorIndex change event
  51. Correspondance search between sheets
  52. Excel and Mainframe apps
  53. Solved: Coverting table data to flat data & delete empty rows
  54. Solved: How to correct hide sheets when more than one workbook is closed?
  55. Using Excel to Tab through IE
  56. Center Userform/splash son monitor
  57. "Application OnTime" Questions
  58. Solved: Take time difference
  59. Correlation Matrix through relative refrances
  60. Solved: Opening the Edit Links Dialog
  61. Procedure needed to group sections of data?
  62. Sum of column
  63. Formatting text cells to use in a formula
  64. Solved: deleting rows matching criteria from a column
  65. Change picture based on cell value
  66. Print tables with variable height and same heading
  67. Calculate Retirement Age: I Failed!
  68. Solved: Changes in all Workbooks in One Time
  69. Solved: Speeding up routine
  70. Solved: Splitting all addresses in a formula
  71. Solved: Alphabetically reverse text in cell
  72. Solved: Select case for conditional formatting to build heat chart?
  73. Pausing a macro...
  74. Solved: how to protect/unprotect column depending on cell value?
  75. Help to populate listbox via vba
  76. Solved: How to Chart two different data ranges
  77. Solved: Join Two Codes Together
  78. Solved: How to automate Excel Tools-> Options
  79. Solved: copying rows matching criteria from a column
  80. Solved: Need to add a sort command to macro
  81. Opening Excel from Powerpoint
  82. Snap view upon cell click
  83. Solved: Offset Macro Needed...I think
  84. Jumble Word Game
  85. Alternative to late Binding?
  86. Sleeper: Copying single values instead of range
  87. Solved: Amend vba code to add and extra step
  88. [SOLVED:] Changing Names to Numbers
  89. [SLEEPER:] Fill PDF form from Excel
  90. VLookup and column indicator
  91. Solved: Calendar
  92. Pull Access cells into Excel
  93. Solved: using a worksheet function in VBA
  94. Want to have a static column referring to a dynamic range of data
  95. Creating a lagged correlation matrix
  96. Solved: Textbox formatting question
  97. Solved: Excel Macro Help - Hyperlinking
  98. [SOLVED:] Disable Cut, Copy, Paste Macro for One Column
  99. Deleting headers between two found variables?
  100. Solved: Macros men?
  101. Array Formula (sum of ranges)
  102. [SOLVED:] Can't Find Project or Library
  103. Solved: getting rid of a "If" + improving my code
  104. Solved: Create folders and filename
  105. Solved: Check conditional format colour?
  106. Solved: Autofilter for multiple condition
  107. Solved: Add a count variable & increment it appropriately in this code
  108. Data update does not work from VBS initiated open
  109. VBA search through workbooks to return answer help
  110. How can I disable the links and query alerts
  111. Solved: Need someone to discreetly look at my code
  112. Pivot table to NOT summarize data?
  113. Multi Text Criteria
  114. Solved: how to copy value with criteria to other worksheet?
  115. Solved: ActiveSheet Printing
  116. Looping and shaking
  117. Solved: UserForm turtorial
  118. Movies and scales
  119. Solved: Loop to Get and put values
  120. [SOLVED:] Get Tenor - Bucket Function
  121. Solved: Locking Merged Cells
  122. Solved: Time and Date log using VBA
  123. [SOLVED:] Autofilter OR function
  124. Solved: xlCellTypeVisible question
  125. How to Parse a string with VBA
  126. Deselect range after Macro runs
  127. Compare two columns to two other columns
  128. Solved: Pie chart data labels percent formatting
  129. Help with ADSI spreadsheet
  130. Solved: Merged Cells Null Value
  131. Solved: To copy part of the table data
  132. Solved: deleting an asterik
  133. Saving
  134. Can you help me?I want code
  135. Solved: What to do when executing a code freezes Excel?
  136. How to close the dialog with Excel VBA
  137. Solved: Deleting Unwanted Rows
  138. Email several sheets in one workbook password protected
  139. Solved: Add sheet & name
  140. Find Major Lows and Highs in Series
  141. Solved: Search through range and fill corresponding offset?
  142. [SOLVED:] Getting Month and Year from a date cell
  143. Solved: double case statement
  144. Internet Explorer dialog pop-up from Excel
  145. Error Popup
  146. Solved: Copy only filtered rows
  147. Solved: unchecking checkboxes
  148. Solved: Textbox format
  149. Solved: column loop
  150. Scripting.FileSystemObject
  151. Solved: Choosing random samples
  152. How Can I save data in incremental way-Help needed
  153. Saving data in incremental way in dat format-Help Needed.
  154. Solved: conditional formatting by color
  155. Regular Express
  156. Solved: Insert comment pictures fill down.
  157. Spreadsheet maintainance automation required?
  158. Solved: Formula help for odd money calculation?
  159. User Defined Function - Write value to a range
  160. Delete row if cell does not contain a particular value
  161. MS Excel 2007: what is wrong with standard colors when constructing a chart?
  162. When to Use "Application.CutCopyMode" Statement
  163. Solved: Single click on cell should store value in another cell
  164. Help to Modify An macros to compare
  165. Add another call function to an exiting macro button
  166. Solved: Prevent numeric or symbol and if function in userform
  167. Remove Duplicates in ComboBox
  168. Solved: Open User Form in specified range
  169. Saving Excell Data to File (More complicated then the title says)
  170. Solved: Amend vba code to apply same font and styling
  171. Excel VBA Variant Variable Assigned a Number Tests as Number when assigned to ??
  172. Solved: Redirect save when given drive is not accessible
  173. Solved: Convert a number into a string with a leading zero
  174. Solved: Display if Found, if not edit???
  175. How add new table ellement faster?
  176. Solved: Adding Second Symbol
  177. generating emails from excel fields
  178. Challenging Macro
  179. Range copying issues
  180. Solved: Define Name from a function
  181. Illegal Characters in Excel File Name
  182. Solved: Adding More Cell Ranges to BeforeDoubleClick and BeforeRightClick Macro
  183. Sorting - data in columns - arranged finally in one column
  184. How do i add the custom toolbars programmatically
  185. Solved: Delete row if meet the criteria
  186. Transpose Row into Combobox
  187. Accessing Web page from Excel
  188. Unknown Symbols keep appearing!!
  189. Improuvement af this macros
  190. Solved: Glitch in Macro
  191. Combobox.value reference
  192. change the defined name range names to correspond to workbook (book1.xls) -
  193. To show multiple contacts pick one
  194. Permutation with a handicap
  195. Solved: Filtering Pivot Items by value
  196. Solved: Copy format Range into another Range
  197. UserForm
  198. Multiformat Lookup
  199. View/Print Non-empty columns only
  200. Error when deleting
  201. saving changes to xlt doc
  202. Excel bug?
  203. Solved: Print information from rows
  204. compare records
  205. Print selected rows to labels
  206. Solved: how to use variables with rows selection
  207. How to do Unit testing in Excel as part of Test Driven Development?
  208. Data Validation: Listbox
  209. Autorun externally held macro without opening external file
  210. Combobox Selection Problem
  211. Solved: Trying to work out which userform has been opened
  212. Problems with calculating hours worked
  213. Solved: eliminating blank spaces inside string
  214. Solved: Dollar symbol in formula
  215. Swapping multiple cells accross a row
  216. Problems grabbing hrefs in HTML docs
  217. [SOLVED:] non-modal userform to reflect values with Worksheet_SelectionChange
  218. Copy between Excel applications
  219. Solved: Add a extra step to current macro button
  220. Range assignment in chart
  221. Solved: selecting and copying a range where a variable is found
  222. Grouping Cells + Printing
  223. Solved: A function as a variable? Pass function as parameter? function pointer?
  224. Solved: VBA Hyperlink from a Cell ?
  225. Solved: Conditional Print Preview
  226. Solved: Sheet name in formula instead of caption
  227. [SOLVED:] How to skip no dates data in chart
  228. Solved: VBA VLOOKUP error
  229. Solved: Getting 2 pieces of data from one source (cell)
  230. remove corrupt excel names - programmatically?
  231. Solved: Macro hangs and need an extra step add to the macro
  232. Solved: Code to automatically enter data update date
  233. Solved: Condition with StatusBar based on Row number
  234. Solved: Painfully slow Copy & Paste from Web onto a sheet.
  235. Solved: DTPicker1 in Userform help
  236. Solved: Matching two sheets help needed
  237. Solved: combine mulitple columns
  238. [SOLVED:] Disable 'Save As' dialog
  239. Test if vba password is set.
  240. [SOLVED:] How find the empty column immediately after the data column???
  241. Solved: How to insert values in rows through for loop
  242. [SLEEPER:] Set trial time limit on workbook?
  243. Solved: If value in a row = value in another column store in another cell
  244. [SOLVED:] Macro can only be executed if specific cells are selected
  245. Solved: Tricky formula help?
  246. Solved: Mandatory fields
  247. Solved: VBA help... Gaining access to training or information
  248. Code to match two sheets and display differences
  249. Undo option
  250. How to hide the workbook while exeuting macro?