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

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