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

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