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

  1. Solved: Prevent Function calls in worksheet when running macro
  2. Solved: Open and Close File
  3. Solved: Looping with textboxes
  4. Form Button Font Keeps getting smaller
  5. XP Visual Styles to Excel UserForm
  6. Solved: Macro for printing
  7. Macro to save file with active cell value with 3 date options
  8. Method to merge two excel files without links
  9. Solved: Working with CutCopyPaste Mode
  10. Dynamic hyperlink that can survive sorting
  11. Wildcard character for VBA
  12. Solved: email from within excel using outlook
  13. Macro to Group columns on the basis of criteria
  14. Filter Rows with Duplicate values.
  15. Solved: Using InputBox to select Range
  16. Help with a couple lines of code please...
  17. Entering cell comments using VBA
  18. Looping Ranges
  19. Protected Sheet Allows Macro to Execute
  20. Create Pivot table from multiple worksheet
  21. Conditional Drop-Down lists + auto filling
  22. formula/code cleanup
  23. Workbook to track changes in other workbooks
  24. Nested Loops-In What Sequence?
  25. Solved: Find Text Position
  26. Solved: Separated tables in one page
  27. Solved: Run Macro on Specified File and Worksheet
  28. Get MS Word ActiveX Control values from Excel VBA
  29. RefEdit control to clear contents
  30. Resize JPG files to consistent size
  31. Read fr Open File > if not open > open file > and read cells
  32. Solved: Matching 2 customer record sheets
  33. Click Event
  34. Solved: Turning ScreenUpdating On and Off
  35. Solved: How can I have a nested IF-function combined with an OR and AND-fun
  36. Solved: Tracking Comments
  37. ask permission
  38. Need Help for WEB PAGE TextBox
  39. Solved: Is there a shorter way to write my VBA code?
  40. Column counting and Loop
  41. Solved: Performing a Successive Filter
  42. [SOLVED] Automate Chart with filtered values
  43. Count Half of the Visible Rows
  44. VBA If statements Variable help!
  45. Beginner
  46. VBA Code for pivot table from multiple worksheet
  47. Solved: Excel 2003 end(xlup) problem
  48. Automatic Directory File List
  49. Inserting Flash in Office2007
  50. Not sure if possible..brackets issue
  51. Extract Data from Outlook and populate it into Excel
  52. Solved: daylight savings time
  53. Solved: Rename "Microsoft Excel Objects"
  54. Pulling Information from a String
  55. VBA Macro - Automating Web Querie
  56. Solved: Conditional Numbering
  57. Solved: Vba Automate Emailer for Lotus 6.5.3
  58. Subscript out of range for importing files
  59. How to Save File & Overwrite Original??
  60. Oorang: A query about your GUID program
  61. Prevent Worksheet Deletion
  62. Default Messages
  63. Solved: log only once per 5 sec. - only fix code
  64. Solved: Multiple logical tests
  65. Solved: Splitting data from one column into multiple columns in excel
  66. How to Delete Visible Rows in VBA?
  67. Solved: Delete multiple rows & Unhide hidden rows
  68. Solved: Web Query...creating data crawler
  69. Solved: Custom Classes and Collections
  70. Filtering using a listbox across multiple columns
  71. Save file as excel through xl macro from web- in existing code
  72. Need help with delete
  73. Mesage box in VBA
  74. Parse Text
  75. Dynamically allowing/disallowing user sheet insert.
  76. Extract text from multiple text files
  77. Bar chart help any example or sample file ?
  78. Converting manual chart to bar chart?
  79. Solved: Skip blank cells
  80. Solved: Copy text from shapes
  81. VBA: embedded excel chart
  82. Solved: Excel 2010-Run VBA code pressing a sheet button
  83. Solved: how can i add "count" and "Sum" in existing code
  84. Solved: Calculate age from row eleven
  85. Solved: Ribbon management in Excel-2007
  86. Changing default field "All" in pivot table
  87. Sending email without using outlook
  88. Button to interrupt subroutine
  89. Solved: KB entry "Reduce Excel File Size "give run time error 1004
  90. Microsoft Speech Object Library
  91. trigger proc. with a date
  92. copy data
  93. Solved: to extend the coloring
  94. Automatically split a large text file in separate worksheets on import
  95. CALCULATE
  96. Solved: To Auto Populate Value
  97. One message box in a for loop
  98. trouble with .Resize
  99. Print_Area Formula
  100. Record Formula Evaluation Steps
  101. copy filter cells
  102. Conditional formating
  103. Solved: Count according to date
  104. explanation
  105. Random
  106. Solved: Having trouble with "Offset" or the equivilent
  107. To get specific part of filename from a folder
  108. Run process at set time
  109. Mesage box - Conditional formating
  110. Solved: Another Query question
  111. Solved: vb conditional formatting
  112. test of CF
  113. Solved: DropDown Question
  114. Creating a TOC for only visible tabs? Excel VBA
  115. Solved: Count number of files in a folder
  116. Printing solution request
  117. Open csv file using VBA
  118. Solved: Track Changes in Excel Feature
  119. Auto Email
  120. rc
  121. Protect workbook, save and close
  122. Unable to record
  123. Using Macro to Add Code
  124. Filter Pivot table by Month & Year
  125. Solved: Export from Word form to Excel
  126. Solved: Self Destruct file
  127. pdf price lists to excel
  128. copy data from other sheets into another sheet
  129. Solved: loop help please and thank you!
  130. macro to convert all word files to excel from a folder
  131. Solved: Using Range Names with a multiple IF Formula
  132. combine a single sheet in 100 workbooks to another workbook and then summarize
  133. Hide Workbook Title Bar
  134. Naming sheets in "Combine All Workbooks from One Folder Skipping Blank Sheets"
  135. Solved: Auto text-ellipse macro. Is it possible?
  136. Solved: Msg Box code for a RANGE
  137. Find a word
  138. Solved: How to use replace function in VBA?
  139. Solved: How do you convert negative number to positive?
  140. search value in entire wb - only fixing code
  141. use if else loop
  142. Working with vba in two excel workbooks
  143. How do I add the red triangle in the right hand corner in Excel?
  144. VBA Lookup
  145. Displaying a UDF within insertFunction
  146. Performing calculations using VBA
  147. How to loop a date
  148. userform displaying table data
  149. Solved: Using Select Case
  150. VBA macro simple adjust
  151. how to find the value and replace with diff value
  152. Solved: Help with Find function VBA
  153. Change days each time
  154. Sending Multiple Emails via VBA
  155. Solved: filter
  156. Solved: Using one Calendar in multiple userform textboxes
  157. Sort 2 Columns Code Needed
  158. Solved: How to use str?
  159. Copy & paste based on value after stripping characters
  160. Creating a Simple Array
  161. Copy the data of one cell to three Rows in excel sheet
  162. Combine all sheets to Master sheet
  163. Open file with datestamp in filename
  164. Solved: Time Difference between two dates
  165. Solved: Calculate Number of pages
  166. Solved: Dynamic File Path - Code Tweak?!
  167. Looping copy and paste macro
  168. Importing text file -
  169. Macro/VBA find/copy/paste question
  170. Writing data to chart/graph with a variable data range
  171. Cascading ComboBoxes
  172. How to Adjust Column Target
  173. copy range with cell link
  174. search
  175. Mailing PDF from EXCEL
  176. Range.Formula for A1-ref.style notation goes wrong
  177. Solved: Userform ListBox Row selection
  178. Excel Dashboard
  179. Macro to provide count of results
  180. Is it possible to export to html without using save as?
  181. Solved: vba for playing sound effect!
  182. Passing Variable with .OnAction
  183. Copying Values Down or Across
  184. Solved: VBA and HTML help make them talk.
  185. Solved: PivotTable Name issue
  186. Solved: A question about code finding a certain text
  187. Solved: change variable ; from 2000000 to $2,000,000
  188. Reading a text file by column in to an array?
  189. Solved: How do I create an add in that automatically adds a new menu to the toolbar?
  190. Solved: Search for value in columns and display results of the relevant rows
  191. Solved: Hyperlink to PDF file gives error 432
  192. Solved: Alternative to RICI notation in formula
  193. Solved: Copy Paste non-adjacent cells in a range
  194. Solved: Help Identifying Empty Cells
  195. Solved: Escape from Edit Mode
  196. Solved: Compare two sheets semi-manually
  197. Solved: Dir Function - Sequential files
  198. Solved: Removing Noncontiguous DropDown Arrows
  199. gif animated picture on a user form !!!
  200. manage datas from a multilection rows
  201. Display label results in a texbox
  202. Userform Search help!
  203. Auto Import Text file GetOpenFilename no dialog
  204. Solved: copy the formula or address
  205. copy cells from excel table into a pre-formatted table in word
  206. Not sure what to do.
  207. Pulling data according to a cell value
  208. Average of n elements in an array
  209. Formating lines in table/pivot table
  210. VBA code to open an Excel workbook readonly
  211. Solved: Save chart as image plus refresh
  212. Pivot Table Show All
  213. Solved: Copying comments from one workbook to another
  214. Loop but Subscript out of Range
  215. Solved: label caption
  216. Extract Data to Excel from a Website.
  217. Solved: Calling a Function, of Sorts
  218. Using arrays in vba excell
  219. Remove duplication and fill a form
  220. Macro to return picture in a cell?
  221. How to Modify Userform?
  222. Solved: On open excel
  223. Solved: Error on Insert Picture code...
  224. Pick a Workbook and mail its worksheets
  225. Userform Activate not firing in Excel 97
  226. picking range from "A1" to variable
  227. Need help on VBA coding....
  228. Solved: Scroll worksheet when userform is present
  229. Multiselection areas: how to manage?
  230. delete duplicate text
  231. Creating sub-blocks within a large data-block
  232. Is it possible to ask vba to write html code in to an html file?
  233. Changing AutoFilter Range
  234. Excel 2007-UPDATE Links ISSUE with excel 2003 file
  235. Dynamic Formula put in formula with VBA
  236. Save Excel Userform as a Web Page
  237. Solved: If else doesn't work the way I expected
  238. Solved: Date picker 2003
  239. Assigning a cell to a row that has a cell with a similar value
  240. Solved: Formula help
  241. Using Custom Views
  242. Color Banding Rows
  243. Way to get innertext of all childnodes of a node?
  244. Solved: Find,MatchCase PROBLEM
  245. Solved: Alignment on coding page
  246. Solved: Count Business Days Between 2 Dates
  247. Can I run an executable within my VBA?
  248. Solved: load a one dimensional array from non-contiguo
  249. Return Row info based on Column dates
  250. Question on insert Object