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