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