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

  1. Macro code only working on first 2 pages of Worksheet
  2. Solved: Adding same items to combo boxes on multiple sheets
  3. error help
  4. lookup
  5. Solved: Insert text from last row
  6. External File Processor
  7. link excel to word letter
  8. Getting time-stamp every 5 seconds
  9. Solved: 2007 Menus
  10. Solved: Testing or Case of String
  11. Solved: simple problem, please help
  12. Solved: range areas limit in 2003
  13. If...Then...Else Loop Error
  14. Editing Formula Macro
  15. How to store large complex data in array
  16. choose folder with restrictions
  17. Search all worksheets within a spreadsheet for a value and copy data to another sheet
  18. Search for value and map data
  19. Solved: Max / Min Userform
  20. Solved: Automatic concatenate
  21. msgbox content redirect
  22. Encryption - v2007
  23. Solved: non standard list comparing
  24. Look up values
  25. FUNCRES.XLAM? Why is this file in my VB Editor?
  26. Creating E-mail in Outlook using VBA Excel
  27. Converting x y values from a chart mousedown_event to cooridinates in side chart
  28. State/county combo box
  29. create hyperlink using macro
  30. ODBC Connect Help
  31. Solved: How to format workday end date with 17:00
  32. SQL ROUND function work in VBA not VB6
  33. not allow copy
  34. Rename before moving a file
  35. Is it possible to print pages based on time in a column
  36. Vlookup multiple worksheets between two workbook
  37. Solved: Treeview
  38. Solved: open, save files
  39. Refresh Worksheet
  40. SUMIF by year and also grade
  41. Solved: Can vba code create and Activex CommandButton and set its properties
  42. Read pdf scan
  43. Bug in excel sheet
  44. toolbar question
  45. Solved: Need help with copying data from another workbook
  46. Auto fit cell without using MACRO
  47. Is there a way to shorten these codes?
  48. Solved: AutoFilter question
  49. Select a cell in sheet2 when I'm on sheet1?
  50. Open file prompt then click cancel button
  51. Separate text
  52. Create Multiple Workbooks with multiple worksheets from master workbook
  53. class module
  54. Spreadsheet Control changing its size at runtime
  55. Color text in textbox?
  56. Solved: Transfer Variable Wbk to Wbk?
  57. Use variable with Sheet Codenames
  58. Solved: if & for statement
  59. using MODI with Excel
  60. Solved: Create shortcut
  61. Solved: Loop through and Copy
  62. Sending an email via Outlook from a non-default address
  63. Data connection wizard / Microsoft query
  64. Change Excel icon
  65. Formula/Macro help need for pulling "words" from a cell
  66. IF THEN Macro
  67. correct add method for ovlPointer
  68. Listbox item on click updates the same listbox
  69. email & attachment word doc.
  70. Solved: Charts and Legends
  71. Solved: lookup previous row in a column
  72. VB Userform with combobox help
  73. Solved: Variable address backwards reading
  74. ChartSpace not changing correctly
  75. Creating a dynamic list of sheet names
  76. Solved: Massive size of Excel file
  77. Solved: UserForm ,Vlookup,Validation Combo To TextBox
  78. hiding vba coding
  79. Solved: Creating sub array from a range
  80. Import CSV to Excel problem, paste only to 1 row
  81. Solved: List Box in Excel VBA
  82. Hide Rows Based on Cell Value (formula)
  83. Insert form values.
  84. Solved: Copy data from multiple files to a single worksheet
  85. Solved: If/then help
  86. Pivot table issue
  87. Onkey method to call Label click event
  88. if I input =3000/3 in cell A1, then the value in cell B1 is "/3"
  89. Deleting a chart object in Powerpoint
  90. Macro template in vba
  91. Search and replace VBA help needed
  92. Msg Boxes
  93. Automatically play CD, open it's .xls file & save it in Excel default directory
  94. can a userform be a child object of a chart
  95. Updating macro to Excel 2010
  96. VBA for Printing Sheets
  97. Solved: separate text
  98. VBA to update Database
  99. VBA to open Web page and Enter Data in Text Box on webpage and click on Submit
  100. Solved: Delete range based on cell value
  101. Solved: Find & Replace Macro replacing outside of defined area
  102. External Pivot Data
  103. Solved: Return name of word doc in same folder as excel sheet
  104. Macro that deletes a row based on multiple conditions
  105. Count number of pages in a TIFF file
  106. Reset different data validation cells
  107. Solved: 2 separate Range value inputbox
  108. Solved: List directory contents based on cell value
  109. Feed Listbox from Combo box & List Boxes
  110. Modify code to extract data from a text file
  111. Pivot tables - VBA
  112. Automating Date Change in a macro
  113. Automating Date Change in a macro
  114. External links (defined named) won't delete
  115. Solved: List Separator
  116. Quickly accessing a submenu item
  117. Marco to Average, transpose, paste data into new work book
  118. Excel 2007 gets crashed when trying to save a file.
  119. Get Items in a ComboBox from MSAccess Data
  120. Solved: Format csv Date to xls Date format problems
  121. Archiving Files - Create New Folders and Archive
  122. send mail cc open contacts
  123. Select Dynamic Named Range
  124. Solved: Call .exe file with input file
  125. Solved: Help!My code is find one value not all
  126. Solved: Find Last Comma
  127. Solved: String Division by Index
  128. Portrait and landscape when printing same worksheet
  129. Custom y axis on bar chart
  130. VBA code for macro to create list from various worksheets
  131. Search Date
  132. combining two TOC macros
  133. If?
  134. Solved: HELP!!! Cannot get code to select cells based on specific text within cell.
  135. trouble saving excel to tab delimited text file
  136. Modify macro to import text
  137. Command Button
  138. Solved: set print area
  139. Copy & Concatenate
  140. sumif help please
  141. Checking to see if XLS file is local
  142. Solved: Formatting Edit
  143. [SOLVED] Sort Arrays ...
  144. File name pick- Excel VBA
  145. Solved: How do you obtain the CellColor value?
  146. Solved: If Statement, need help
  147. Open Workbook at Specific Sheet
  148. Place cell content in Web form Text Box
  149. Count the Rows
  150. Extracting a users e-mail address
  151. Open from the default browser
  152. Populate Listbox error
  153. Double save macro help
  154. Copying value from different sheets
  155. Solved: formula to split a cell
  156. If 2D range, do this...
  157. calling sub from module not work
  158. User Defined Function Error
  159. Activate a workbook
  160. ChDrive without mapping
  161. Messages from Excel
  162. Solved: multi dim listbox used to populate cells?
  163. Delete and move records between sheets
  164. VBA code is needed to Do X every 1 hour
  165. Solved: Counting items vs. UBound
  166. Message box if no value.
  167. Hide current cell indicator
  168. Help protecting sensitive data
  169. Extracting Data from a TXT/XML file
  170. Hide worksheets - 2007
  171. macro security levels for a particular macro
  172. Page number in cell
  173. Help with VBA that copies data & creates new file
  174. chart properties in recording macro
  175. VBA Copy Sheet with all Formatting
  176. Add text in cell based on choice from drop down list
  177. Solved: pulling data from different columns based on specific data in one column
  178. Sort by Date column
  179. [SOLVED] Rename embeded Button in a sheet
  180. Copy filtered rows
  181. Supply Windows Username and Password via VBA
  182. Solved: Conditional Output Where Names are the Same
  183. Debugging Userform
  184. KillYourSelf.xls warning message problem
  185. conditional number formats
  186. User Form Drag & Drop
  187. Calling Stored Proc Error
  188. Random function VBA
  189. Delete unwanted Data
  190. Macro to create and export multiple Pivot charts
  191. Find All and Replace Offset Value
  192. Formatting via code
  193. Solved: Kink in AutoFilter
  194. Copying a sheet from 2003 to 2007
  195. Strange VBA Operation Outcome
  196. Count Passes Thru Sub Routine
  197. Solved: prevent msgbox display
  198. Solved: Counting Occurrences by Date and Time
  199. Group by categories VBA
  200. RunningMax
  201. link label (form control) to cell without using vba
  202. Solved: Dynamic Ranges
  203. If statement and Vlookup
  204. Bypass code
  205. Delete cell range not whole row
  206. "Find Next" and reverse concatenating
  207. Define Names inactive worksheet
  208. Search text
  209. Solved: Do something only at opening of workbook
  210. Solved: Hide and shove worksheet depending on if something is true
  211. Return true to a cell if a range has been altered
  212. Set a worksheet to be the worksheet in which a relative range currently is loated in
  213. Solved: Run macro before a worksheet is shown
  214. Import data from SQL
  215. Solved: Scroll columns and rows
  216. Rows count
  217. Solved: Createobject("outlook.application") ACTVE-X Error....
  218. AutoFilter
  219. copy cell and add extra cells with additional info.
  220. detect if other workbooks are open
  221. macro shortcut runs on other workbook
  222. Basic Vba help
  223. 2D Array of Arrays with User Defined Type
  224. Solved: Put borders around selected range
  225. Get PercentRank of a selected range?
  226. Solved: Compile Error loop without do
  227. CountIf with variable Range
  228. The Fastest VBA?
  229. Code to Remove file password
  230. Bat file to enable 2003 and disable 2007
  231. Select Entire column of a cell
  232. Solved: Right double-click listbox
  233. excel can't complete this task with available resources.
  234. copy web data help
  235. Force tabbing through an multiple cell/matrix range
  236. Loop through cells and delete matching
  237. Record time and date
  238. Solved: Triggering a sub with a change in a range
  239. need help creating highlight macro based on range of values
  240. Dynamically Pulling data from other workbooks in folders
  241. highlight cells based on various criteria and the calculate the number of cells highl
  242. Compare two workbooks sheet1 column A
  243. QueryTable ... destination memory
  244. Column compare
  245. How to read read data in from the worksheet?
  246. Edit code
  247. Apply theme colors
  248. Excel Find and Replace paste in multiple cells
  249. Excel 2007 Comment Help
  250. Sorting, even-odd