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