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