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

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