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