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