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. average over several columns/spreadsheets
  2. Solved: VBA : multidimensional arrays to fill from a worksheet
  3. Solved: VBA: Extract Number from Cell
  4. Solved: VBA: Find next empty cell in a certain range
  5. Solved: How to find broken links
  6. Transfer zip code to another column
  7. Need Help: Updating dates monthly
  8. [SOLVED:] Split cell based on a multiple delimiters list
  9. Solved: How to draw following plot is excel?
  10. Formula and Insert the Column problem
  11. ListView .finditem syntax
  12. Solved: Userform writing to worksheet
  13. [SOLVED:] Value Matching Validation
  14. Extract Application information
  15. Treat Several Columns as one in Pivot Report
  16. Solved: Shift rows to columns by condition
  17. Solved: If range has values then.....
  18. [SLEEPER:] Test for Parenthesis at end of string
  19. Compiling Multiple XML Workbooks
  20. "Should Cost" Model template in Excel
  21. Trying to create a chart without a Legend
  22. sum then devide by a hundred
  23. basic syntax query
  24. [SOLVED:] Multiple nested arrays to fill from a worksheet
  25. VBA to extract information from Pivot Table
  26. SpaceChart plot does not show up
  27. Convert Sheet To PDF Before Emailing
  28. Solved: Can macro let user click to choose workbook
  29. vba open workbooks
  30. Solved: Lost Workbook
  31. Design of set up
  32. Solved: Simple error message
  33. vlookup probs
  34. VB Stopwatch Code
  35. For a website, are Excel scripts better than other programming language scripts?
  36. VBA to adjust print area based on UsedRange
  37. Solved: Excel chart
  38. VB Formula Assistance needed
  39. [SLEEPER:] Okay, here is a wierd one for you!!!
  40. Run code when cell changes
  41. need VB solution for comparing trendlines
  42. Embeding HTML in Excel
  43. VB Button Code, HELP
  44. Controlling powerpoint from excel
  45. Solved: Getb Special Folders with Enums
  46. Solved: Correct method for a second FindThis criteria
  47. excel to powerpoint
  48. Drop down validation using array
  49. Excel VB Programing
  50. selecting a range from a user defined reference in another sheet
  51. VBA to perform specific instruction upon identification of duplicate entries
  52. anchor picture to cell
  53. Saving an activeworkbook as a time stamp
  54. Add dynamic subtotals and then hide all blank rows
  55. Moving files from one folder to another
  56. SPLIT TEXT BY MACROS
  57. VBA issue exporting Chart to Word
  58. Solved: changing cell value/mapping
  59. Input Line
  60. Data number, symbols, sectors
  61. Detect Change in Row . .
  62. Tough VBA data pulling from IE to Excel coding question
  63. Solved: ADO Assistance (Excel into Access) ('97 versions)
  64. Probably simple VBA issue
  65. Force users to enable macros in a workbook
  66. Solved: Filtering multiple worksheets based on master worksheet
  67. Time Out and auto close after expired time
  68. Solved: Creating directories from within excel?
  69. VBA to click OK in Javascript popup box?
  70. Solved: color code range
  71. List File Attributes of Directory and Sub-directories
  72. Conditional formatting question
  73. [SOLVED:] Problem with deleting empty cells
  74. Disable Cut, Copy, Paste
  75. Any way to prevent deleting a specific WS?
  76. VBA code to use a hyperlink to email file
  77. Vlookup problem
  78. Solved: ListFillRange from another workbook
  79. Solved: Adding a button to a commandbar (Excel '97)
  80. Solved: move cursor to row X in active column
  81. Solved: VLOOKUP problem
  82. test of KB code on Disable Cut, Copy, Paste
  83. Solved: Identify column or number
  84. Solved: Insert Image from Userform Commandbutton.
  85. Solved: Find Value in Column And Paste data into it
  86. Advice: Redefine type of variable
  87. refresh all on protected sheet
  88. dates in columns
  89. redefinition type in VBA
  90. Solved: Problem in personal worksheet
  91. Solved: Avoiding a <type mismatch> error using IsError ?
  92. Find maximum and minimum values each day
  93. [SOLVED:] Prevent variable from being initialized
  94. [SOLVED:] sumifs in VBA
  95. vlookup and hlookup on multiple criteria
  96. Write to text file question
  97. IF Formula
  98. [SOLVED:] Excel to World find Wholeword
  99. Two add-ins for one custom ribbon tab
  100. How to write a click event from a list box???
  101. Solved: Excel 2003: Disable screen refresh during intensive chart updating
  102. Excel Visible/Invisible
  103. Excel Chart
  104. Solved: Rearranging data
  105. Excel 2003 Query Sharepoint List
  106. Cycle thru worksheets and import shape according to dynamic values
  107. Excel Print Specific word document page
  108. Solved: How get TargetPath of .lnk or .url shortcut files?
  109. Solved: Protect UserForm but not module
  110. Help with USerForm Contain MultiPages
  111. Solved: Load IE to Excel Sheet
  112. Solved: 6 dependant drop down boxes
  113. [SLEEPER:] Prevent user from viewing the code
  114. Solved: make sure 2 values always equal
  115. Problem with hyperlink
  116. PDF all worksheets and print
  117. Using NORMSDIST() Function in VBA
  118. [SLEEPER:] Adhoc SumIf on variable criteria
  119. Code help
  120. Solved: Can I insert a copied row with a macro?
  121. Solved: Test before paste special
  122. Solved: public functions
  123. [SOLVED:] Grey out menu item
  124. Solved: creating new workbook/searching for wkbook
  125. change code help
  126. [SOLVED:] Sort Sheets in ascending order
  127. VBA Project Password
  128. Solved: Visible Range after AutoFilter
  129. Strange problem with excel chart
  130. Solved: Soap: need refresher
  131. auto-complete scroll bar
  132. Converting number to text
  133. Solved: How can I return cell value via worksheet name
  134. Solved: Generate a random string of letters
  135. Dynamic Validation Not working?
  136. Solved: Macros across workbboks
  137. Solved: Setting Dynamic Print Range
  138. Solved: Fade Away Userform doesnt work properly when closing userform
  139. Clean the working mess
  140. Sleeper: Multiple pictures in one section in the header
  141. enter seperate cells in chart
  142. Opening File in VBA code
  143. Viewing VBA when passwd protected
  144. Referring to pasted shapes / pictures
  145. Read a Mainframe Dataset (PDS) using VBA
  146. Macro to Loop Through a Repetitive Task?
  147. Solved: 2007 Application.Quit
  148. Solved: Sheet Code is not working correctly
  149. Object-oriented programming in VBA
  150. Printing time period based on usr input.
  151. Solved: What formula or vba code for this case
  152. Solved: External Data Requery
  153. Solved: Extend range of cells from active cells
  154. VBA Running Excel 2003 when you have 2007 Installed
  155. Derived classes in VBA
  156. IMPORT *.LOG file into textbox + autosize
  157. Solved: Find, Cut, Move & Copy issue
  158. Solved: Prevent the user from bypassing Data Validation
  159. Folder/Subfolder list help.
  160. Solved: Prevent the user from seing some worksheets
  161. Solved: Subtracting Numbers with Sheets 1/2 data
  162. VBA help needed :(
  163. Solved: insert rows based on cell value
  164. A special calculation
  165. Enter seperate cells in chart
  166. Global Error Handling
  167. Solved: Highlight the line when certain cell is selected
  168. How to end unlimited cycle?
  169. Find last row, insert row retaining format of last line and repeat for named tabs
  170. Solved: Check if cell has data validation
  171. Print Multiple Sheets as Word Docs
  172. Functions can change some properties?
  173. Parse SAS LOG using RegExp
  174. Counting Data between Decades
  175. [SOLVED:] SOAP Action fails
  176. How to put together caption
  177. Sleeper: Distribution of data among employees
  178. How to construct VLOOKUP in VBA?
  179. help with "select method of range class failed"
  180. VBA userForm: changing images
  181. Excel VBA to check if multiple worksheets exist
  182. Solved: Run an access macro thru excel
  183. Solved: VBA to identify duplicate entry and insert row to other worksheet
  184. Sleeper: Using a UDF in Multiple Worksheets
  185. color grid
  186. Report to show >2 Instances of an Absence
  187. Hlookup
  188. What is the VBA code to enter text from a cell into a website's form?
  189. Solved: Text boxes
  190. How do I launch a program from Excel?
  191. Solved: How to copy only formats and formulas, not values
  192. Automatic Reconciliation
  193. Solved: Format code for multiple areas
  194. multiply value with 1 - optimization
  195. Formatting TextBox
  196. Solved: Problems converting date into required format
  197. Match function
  198. Solved: filtering on named ranges.
  199. Delete blank series from a XY Scatter Chart
  200. Solved: Insert set parts in list
  201. Combo Box question
  202. Worksheet_change
  203. Solved: Sort Data Help
  204. Solved: Excel Charts - Naming
  205. Solved: Array Help!
  206. Need help writing an Input Function
  207. Solved: Forms
  208. Solved: Solved Zoom in if specific cells are selected
  209. Solved: If Not fso.FileExists ?
  210. Solved: Hide button with associated row
  211. Solved: identify last row and change formula accordingly
  212. Solved: Delete a Worksheet Command Button
  213. Adding controls to a form at runtime
  214. Solved: Save changes to Add-in on application close
  215. Solved: save sheet to desktop with name from cell
  216. Solved: Combobox Colors
  217. Solved: Change based upon a cell value
  218. Solved: multiply values from a textbox and combobox in a userform
  219. Solved: Excel does not allow importing* accdb files
  220. Solved: Converting 3 Rows to 8 columns
  221. [SOLVED:] Code works without proper Dims, why?
  222. Soap Action Fails: redux and challenge
  223. Linking cells to sheets & Duplicate W/Sheets
  224. Could you give me an example of a VBA script that automates writing scripts?
  225. Solved: Where can I find some VBA scripts or related scripts such as VB & VBS?
  226. Solved: Looking for VBA resources?
  227. Solved: Macro is off... need help with copy & paste function
  228. how to count items in a column
  229. Questioner Form
  230. Excel and Bloomberg
  231. Solved: Coloring sheet tab conditionnally
  232. Solved: Move row to correct sheet if column V = "Y"
  233. How Sheet formulae is called
  234. [SOLVED:] Exporting data to Word
  235. FollowHyperlink
  236. Solved: Using Countif with multiple criteria
  237. Solved: dateserial format
  238. Solved: Minimize/Maximize Userform
  239. Solved: TextBox display columA & B
  240. Userform runs ok in VBA Editor, but not when started from macro in workbook
  241. Solved: Manipulate String based on Carriage Return
  242. Cost Forecast spreadsheet
  243. Solved: File IO low level functions -- not working
  244. Solved: Noob question
  245. Solved: Increment offset
  246. Solved: Creating a name range in one column
  247. Update Links in multiple workbooks
  248. Solved: create a named range with a changing area
  249. Solved: want to remove #div/0 error by vbnull string
  250. [SOLVED:] Counting Cells Where Formula Does Not Return ""