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