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. Understand code
  2. Error on copy and paste to powerpoint
  3. Need help to create an Excel Function
  4. Solved: Selecting Noncontiguous Cells
  5. Solved: Force lower case
  6. Sum $ within a cell
  7. Solved: conditions for multiplecomboboxes
  8. Solved: Problem when Excel function RAND() is triggered by a macro
  9. Return email from textbox
  10. Calculating Working hours in a Week
  11. Solved: Excel VBA - Linkg a TextBox to a TXT File
  12. How to name a chart that is not a chart sheet?
  13. Go to top of sheet
  14. Menus in foreign language versions
  15. Solved: count a specific text value in a column
  16. Solved: Ending Macro
  17. VBA HELP
  18. Fill row to coulmn
  19. Macro to remove duplicates
  20. What are the Units for width and height for charts to powerpoint
  21. My scripts are stored in different modules
  22. Solved: Copy and paste only visible characters
  23. Highlighting max numbers
  24. Solved: Msgbox for if beginning letter of word a "M"
  25. Workbooks comparison
  26. Solved: PageSetup
  27. Print Macro
  28. Solved: infinite paste!!!!
  29. Automatically defining cell background color via system date
  30. To Access and Back
  31. Converting number stored as text VBA problem
  32. Solved: Sendmail bugging
  33. 2 Date Time Difference
  34. excel 2007 patch?
  35. Solved: Runtime Error '-2147352000b)': Specified dimension not valid for current chart type
  36. Need a code replies to an outlook message
  37. Solved: Default rgb for buttons
  38. Solved: Active cell color change
  39. Solved: Exporting text of cell into input box
  40. Function parameters won't work correctly
  41. Check Column w Criteria
  42. Cell to Cell comparison and color coding
  43. Solved: Trimming multiple blanks
  44. Solved: Open URL that includes string picked up from cell
  45. Check an ActiveX control is installed
  46. Solved: EXCEL 2003 Changing row colour based on drop-down selection - more than 3 conditions
  47. Macro to select unknown, named table
  48. Custom Msgbox
  49. How to embed mp3 in excel sheet?
  50. help
  51. Solved: Breaking out of Loop with Keyboard
  52. 64 bit version
  53. How to get the value of a checkbox when...
  54. Solved: Find files in folder that have not been saved in x days
  55. Find - Copy - and Paste
  56. custom sorting a group of data
  57. Pivot Table
  58. Hightlighting duplicates by comparing multiple columns
  59. Solved: For Each Loop Only Loops Once...
  60. calc sales within x-mile radius using trig function - lat and long
  61. Data from Access through network
  62. Lookup values AND Subtotal
  63. Simple Floating Toolbar
  64. Get folder names in different columns excel
  65. Solved: Build table in 2010
  66. Form Control - Checkbox - Background changes colour when clicked
  67. Solved: Another 2010 problem
  68. Solved: Determine previous quarters from today
  69. Determine if folder is Recycle Bin
  70. Updating Access From Excel VBA
  71. Excessively slow script (Update wanted)
  72. Prevent duplicate but for one cell only
  73. Solved: populate column with array values
  74. Create a Macro to add to an existing Macro
  75. Solved: Link text box to a file size ?
  76. How convert this code to a macro?
  77. Solved: File name compiling via Userform data help!
  78. rotate label from user form
  79. Solved: Close a UserForm and open another
  80. How can I make a PasteSpecial from Excel to Outlook?
  81. Multiple Column Validation List
  82. Solved: assigning a formula to a cell
  83. Can I enter a value in the prompt of a password-protected workbook?
  84. Searching entire phrases for one or two words that contain many words
  85. Solved: Complex code needed (Seperate words)
  86. use VBA to capture screenshot of a form
  87. Solved: Delete duplicates
  88. VBA Change the Default SaveAs Location?
  89. Directly Access Streaming Live Data
  90. Prevent Size Increase With Formulas
  91. Lookup vba
  92. Solved: Calendar Control 11 - Open on today
  93. PRECEDENTS property not working in a UDF
  94. Solved: Webbrowser Frames
  95. selected cells in yellow
  96. Paste Values
  97. Grouped Controls
  98. Problems in looping through charts
  99. ChartType property changes for no reason
  100. Open Office excel issue
  101. How to format a part of the imported table from Web
  102. Project - Build Football (Soccer) Results, Table and Stats spreadsheet
  103. Importing Pictures
  104. Solved: trying to copy and paste too much data!
  105. Importing Pictures
  106. Sum up formula
  107. Excel Userform that is published in Word
  108. Solved: Disabling Worksheet Change while macro is running
  109. Help update code
  110. Conditional Formatting on computed field
  111. Appending Multiple Workbooks to Master Workbook
  112. saved colour
  113. PDF multiple sheets
  114. copy date to another workbook's month tab and day cell
  115. Solved: comparing ranges
  116. Rowsource for a combo box
  117. Macro that compares directory contents to...
  118. The triple loop....
  119. Solved: Create a .txt file
  120. Solved: Open file .xls or .xlsm, or xlsm
  121. Run Macro From User Form
  122. run time error 438, but method DOES exist!!!!
  123. How to search within a text box?
  124. Help Needed (LookUp or Match)
  125. Solved: delete sheets between two dummy sheets vba
  126. How can VBA recognize the contents of an HTML <a href> tag?
  127. Counting data in 2 dimentional tables
  128. VBA code for pivot table
  129. Listbox Values from VBA, not from worksheet
  130. Solved: Eliminating a Line or cell from code
  131. Drag&Drop CSV onto Image Control
  132. Solved: Creat Macro
  133. Verifying "free text"
  134. Active cell font color change
  135. Solved: Check if file is Open ?
  136. Looking for a solution.
  137. Add cells until adjacent cell is not blank
  138. Call Method Remove Duplicates from VBA
  139. Input Box Help
  140. Dates and Times in an Array
  141. Why cant i get the contents of the title tag ?
  142. Copying and pasting from multiple workbooks
  143. Using Userform Input to Run a certain command
  144. For each worksheet in active workbook, the name will be shown on ...
  145. Delete files from a list in excel
  146. Moving pictures 2003 vs 2007
  147. Add new row,copy only formulas&formats, when reached last used row
  148. prevent multiple instances of excel
  149. Does anyone use a digital pen with Excel?
  150. Solved: Always open in new excel
  151. Solved: Find unique records
  152. check if in wkbk1 then delete in wkbk2 if 5 fields match
  153. exclude some worksheets according to a list of the name of worksheet
  154. Validation list from multiple dynamic ranges
  155. Solved: Multi-page Form
  156. Compare 2 workbooks and delete duplicates
  157. Index and Match across multiple work sheets.
  158. Solved: paste to offset cell not working
  159. Reading values from different excel files
  160. GetObject to open Word File
  161. Object Variable Not Set
  162. macro one sheet to multiple-need adjustment w/ input boxes
  163. Copy textbox from Excel to Powerpoint
  164. Solved: 2010 application.filesearch
  165. Need to copy data excel
  166. Need Macro Unique based Max and Min time
  167. Create a Access table using Excel
  168. Solved: changing lines that transfer
  169. Solved: How to custom format my cell so that decimal my 0s appear
  170. Solved: How to populate a column up until the next column is populated
  171. Solved: Autofilter in reverse
  172. VBA for Latitude and Longitude from 5 digit Postal Code
  173. How to stop date format changing when copied by macro to new file
  174. comparing to excel files
  175. Need help with Auto Comment macro
  176. Opening multiple excel instances
  177. personal.xlsb
  178. Solved: Micrsoft office excel is wating for another application to complete an OLE action
  179. How to pass a normal datatype argument to an array parameter?
  180. Solved: Copying values into range
  181. Solved: New to VBA, a simple question
  182. formula to macro
  183. auto sum data above
  184. Compare two sheets
  185. Multiple search parameter boxes
  186. Solved: Removing duplicates
  187. Solved: Conditional Worksheet Column Comparison and Text Insert
  188. Trouble with Range objects in For Each...Next loops
  189. problem in copy and pasting data due to column limit
  190. Trying to "Line up" rows across sheets.
  191. Macro Optimization
  192. Find Function
  193. Solved: custom format Required in a cell by code
  194. Solved: Need help with combining 2 VBA Worksheet_Change Codes
  195. Calculation based on cell reference
  196. Solved: Shorten code
  197. exporting to csv
  198. Solved: Macro for write value without duplicate
  199. Excel Add-inn Password Recover/Remover
  200. copy workbooks to different folder
  201. Copy from above cell
  202. Search for Certain Part of String
  203. Call a sub from another open workbook
  204. Solved: VBA Move Files to Sub Folder
  205. Solved: Sort Help VBA
  206. IF and Offset Macro
  207. need sort data
  208. simple problem
  209. Solved: filter by month
  210. Conditional Formatting using VBA
  211. Acomplex export from Excel to Powerpoint
  212. Change value of Cell to the integer in VBA
  213. Solved: Assigning formula to cell glitch?
  214. Anyone In Auckland?
  215. Funky Character in CVS - Text To Columns
  216. Need help on Sumif formula
  217. Conditional macros
  218. Calendar without add-ins
  219. input the names of all MS Word file in an Excel file.
  220. CommandBarControl error
  221. Solved: part of Dir string vba
  222. need help writing a program...
  223. Solved: force a refresh to workbook shared on network
  224. takefocusonclick checkbox
  225. Alternative of .SearchSubFolders = False for 2010
  226. Looping through commands
  227. Solved: open macro security setting dialogue box
  228. Solved: Copy unknown range size
  229. How to apply Average formula with multiple criterias
  230. Stable progress bar
  231. Function as Argument
  232. Code interrupted after running another workbook
  233. type mismatch on application.run
  234. how to sum based on data in corresponding rows
  235. Solved: Calculation with an asterisk
  236. Solved: Chart Creation
  237. Solved: formula problem, nested if
  238. How to display values in excel sheet from vba Form.
  239. List out all possible combination in the sheet
  240. Selecting Rows with More than one Constant
  241. application.match type mismatch
  242. Users Help
  243. Solved: Sort will not work ...
  244. Excel VBA controlling IE confirmation popup box
  245. print rows 2,3, as headers on page if multiple pages
  246. hide the row if the row has nothing or more than 1 cell has things
  247. help with html extraction
  248. Solved: activx component cant create object excel 2007
  249. Delete Row sends Excel into an infinite loop
  250. Maximum size for a typical .xlsm file