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