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

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