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 174
  1. Identify the numbers that make up the average
  2. Generating an incremented workbook file & save as variable
  3. Solved: Digital clock within worksheet needed
  4. Solved: delete open workbook
  5. Regex in Excel 2007
  6. export worksheet problem
  7. Solved: VBA code for "or" + "and" functions
  8. Solved: Dynamically hide unused rows
  9. Solved: Open vba file
  10. Solved: Append matched row data from source wsheet back to corresponding row
  11. Enter, Tab and Up/Down Arrows Stop Working
  12. Does visual basic express work with excel?
  13. Downloading data from webpage into Excel
  14. copy values that aren't zero
  15. Solved: Filter & Transfer
  16. Solved: Delete Sheet list
  17. Solved: Get FileNames From Folder Not Using PathName
  18. Solved: Best way to go about?
  19. Solved: Copy a range from the fourth sheet on
  20. Transpose Question
  21. Solved: Minimum Positive value finder using VBA
  22. How can I make CopyPicture show the selected cell
  23. Solved: add leading zeros with a specified length of characters
  24. [SOLVED:] Finding the hour prior to original hour
  25. Summary sheet update keeping set columns in place
  26. [SOLVED:] Search value and insert row under value
  27. From Excel Find Replace in Word 2
  28. Temporarily widen column
  29. help with print, clear and save maros
  30. Solved: Problem with formats
  31. Solved: Add to existing IF formula
  32. Change Drive Letter of Removable Storage
  33. Solved: Charting with labels
  34. Solved: Stumped - formulas required
  35. Copy adjacent cells and paste in non adjacent columns
  36. Solved: Function with multiple exit points
  37. Solved: Major issue blank cells
  38. Solved: VBA for Cell Link to network folder document.
  39. Solved: Excel Macro Not Setting a Cell's Value
  40. Multi Users in Excel
  41. Solved: Loop Until Blank or situation
  42. conditional formatting help
  43. Sorting a range of cells
  44. Delete Empty Sheets
  45. Solved: add headers to print then set page setup settings back.
  46. Replace Combobox with Listbox ...
  47. Solved: Copying between sheets
  48. Solved: checkBox-- Handle Value
  49. Solved: Exclude rows
  50. Solved: Copy specific cell based on date condition paste to specific cell
  51. Is it possible to loop a macro constantly?
  52. Sleeper: Copy rows from worksheet 1 to worksheet 2
  53. Solved: Delete any spaces in cell
  54. Macro to copy, then paste to visible cells
  55. Solved: Copying data onto next empty row, under certain criteria
  56. Determining how a ComboBox was changed ...
  57. Using VB 08 to combine excel files
  58. Solved: SOLVED -- Update cells same sheet based on data changes
  59. Solved: Highlight ROW based on cell value
  60. Selecting a group of cells using the Range.offset syntax
  61. Solved: Printing a *.gif file from a command button depending a cell value
  62. Solved: Userforms created with macro
  63. Solved: Automation error
  64. Solved: Countif formula to be used on a dynamic range to be used on a data table
  65. [SOLVED:] Sum dynamic number of worksheets into one
  66. Solved: Cut entire rows to sheet on condition
  67. Solved: VBA Date Formatting with links
  68. Enter image based on cell value
  69. Solved: How to find the most common numbers?
  70. Solved: FSO Function to get Datelastmodified, DateLastAccessed
  71. Get sub group data based on main group
  72. Solved: MsgBox code to check for Existence of and Opened Files
  73. [SOLVED:] Solved: Autocomplete cells
  74. Solved: need help to create a "database" in excell
  75. Number of sorts allowed in XL2007
  76. Help Needed, E-mailing reports
  77. Solved: IsFileOpen and WorkbookIsOpen giving differing results
  78. Pivot Table data source
  79. Solved: Number Format from access field into excel
  80. Loop through chart and Highlight chart labels based on value
  81. Find number of lines ?
  82. Change to Month Sheet name
  83. Solved: User Defined Function Question
  84. Solved: URL -No Highlight Search Results.
  85. data validation from an add-in
  86. Problem adding References to Excel VBA App
  87. Autofilter Help
  88. Solved: Problem counting decimal places
  89. percentages and comparing two values whats the best way?
  90. [SOLVED:] Sequential Cell Numbering
  91. Database Question
  92. [SOLVED:] Rank Function Question
  93. Delete all characters after a set number in a cell
  94. Sleeper: Find the closest date
  95. Insert sheet
  96. Urgent help Needed <<removing Rows
  97. Solved: Refresh data upon open
  98. Solved: Single member array problem
  99. Combining Project Timesheet Help
  100. Solved: Unprotect Sheets while looping through files
  101. Solved: Unorganized Summing
  102. [SOLVED:] Select A2 through the last used cell in a column
  103. Interrupting a macro
  104. Copy Filenames from Folder
  105. Copy number of rows to formula result
  106. DPercentile
  107. Advanced Filter and Unique Count Code
  108. Using VBA to LOOKUP
  109. Simple VBA-code question
  110. basic unique refs loop
  111. VBA Copy based on offset
  112. Solved: Conditional Formatting Based on Percentage
  113. vlookup help
  114. How do I copy and paste cells that contain "@ml.com"
  115. [SOLVED:] Get absolute address for hyperlinks
  116. If statement not working
  117. Convert row into multiple rows of data (ARRAYS)
  118. Solved: Code to Move to next sheet
  119. Solved: Deleteing indertiminate spaces
  120. how to hide all menus from excel woorkbook?
  121. Solved: Excel Freezing every 30 seconds
  122. Solved: Show custom error message if file already opened by someone else
  123. Color Code row based on cell content
  124. [SLEEPER:] Referencing a named range for a UserForm?
  125. Solved: Finding Last column in Row
  126. Select Case & Data Validation Issues
  127. Transferring data from two dimensional VBA array to Excel range -
  128. A different Change event
  129. Solved: Autofill Cells
  130. Solved: Inserting &amp; Naming New Columns in Multiple Worksheets
  131. got error 1004 when executing this code
  132. Runtime Error - Email Code
  133. Selecting sheets in add-in
  134. FInd Problems
  135. Solved: Deleting Empty Rows
  136. Solved: Cut and Paste macro
  137. SaveAs script
  138. Solved: INDIRECT OR INDEX OR WHAT? I'M LOST
  139. Solved: Strange Excel Error
  140. Solved: Set FollowHyperlink default Web browser
  141. VBA Excel and IE login info "Not Sharing"
  142. bind ListObject to Recordset?
  143. Solved: Pivot Table Update Data Source
  144. Solved: Run code on cell selection
  145. Solved: WorkSheet range Activate issue
  146. Excel form - listbox
  147. WinHttpRequest with HTTPS
  148. Solved: How do I create a range based on a column name?
  149. Click OK on a dialogue popup box
  150. Solved: matching that finds the greatest/least amount
  151. [SOLVED:] Test if an item exists within a collection data type
  152. Solved: Links to other data sources.
  153. Flash the TaskBar
  154. Code for detecting when a Msg box opens
  155. Solved: Convert row into multiple rows of data (ARRAYS)
  156. Solved: Code for printing.
  157. using (iserror) in if statement
  158. Solved: Repeat Column Insertation (It's simple!)
  159. [SLEEPER:] trailing zeroes
  160. Sum for sub total and grand total
  161. Solved: Excel in Parallels Word not... Help
  162. create report for list of numbers
  163. Solved: Stop excel from calculating
  164. For Each-Next code tidying up
  165. [SOLVED:] If a condition is True how to add a number
  166. Solved: Blank cells
  167. Clearing my autofilter
  168. For Input as #1 Question
  169. Solved: AutoFilter macro issues
  170. Polygon's
  171. [SLEEPER:] Backgroundquery:=false seems to fail
  172. Adjusting macro from L.Notes to Outlook
  173. Copy Excel Range Into Outlook Email As Bitmap?
  174. [SLEEPER:] Referencing Other Open Workbooks.
  175. Duplicate names for same range
  176. [SOLVED:] Populate list
  177. Solved: VBA for &quot;IF&quot; function
  178. Solved: Handling large ranges
  179. Solved: Replicating changes to one WS to others
  180. Excel Map gets destroyed when opened
  181. Solved: Transpose selected cells and place result on other sheet
  182. Confused about RefersTo
  183. Solved: IF CASE
  184. List population dependent on another cell
  185. hlookup and vlookup
  186. Workbook_Open Does Not Work
  187. Solved: Create History
  188. Need Help W/Sort
  189. Solved: Help using For loop in a IF then statement
  190. referencing of cells shows formula not values
  191. Solved: SOme one help find out what is happening
  192. VLOOKUP MACRO NOT WORKING PROPERLY
  193. Option Buttons
  194. "yyyymmdd_hhmm" change to Date, Time format
  195. need a code.....
  196. Solved: Display items of a collection in a message box?
  197. Solved: Inrease a number in a column basd on condition
  198. Macros in personal.xls execution based on different file names
  199. X-Y scatter graph refering a series of data log
  200. How to retrieve DataSource of chart
  201. macro to delete files - three days later
  202. Complex workbook_open solution needed
  203. Solved: Row to hide on drop down selection
  204. chasing ranges that move
  205. Ignore Hidden Sheets in vlookup macro
  206. Solved: Worksheets name
  207. Transfer items from list to textbox
  208. Solved: Create a rolling reference number
  209. Solved: macro for every cell on the sheet
  210. Solved: Counting number of pages in word
  211. Solved: file name extensions
  212. Solved: Email through Outlook contacts
  213. help with: suming only colour filled cells in a column
  214. Solved: Big Automation Question with Pivot Tables and Graphs
  215. Solved: VBA strangeness, need help please
  216. Solved: Listbox with data from other sheet problem
  217. VBA help - Vlookup
  218. Solved: Button to insert row in multiple worksheets and update
  219. Solved: ComboBox won't respond to repeat of previous selection
  220. Solved: Cmd Button Caption
  221. Solved: data validation question
  222. Solved: Find String and Merge Cells
  223. Solved: Disable Cmd Button
  224. Solved: Performing a task in vba if time is between 2 times?
  225. Solved: Limit Entries
  226. Open and refresh
  227. Autofilling a formulae to lastrow
  228. Sub reference as Cell
  229. Solved: XLD - Chart Help
  230. Saving a screen capture ~ PrintScreen (Excel '97)
  231. Help W/Small Code . .
  232. Help with Function
  233. Check Box Click()
  234. Copy Workbook, Saveas NewFile, Edit NewFile
  235. Help W/UserForm
  236. Funtions: For non-english Excel users
  237. Solved: Make NewWebQuery with URL-variable.
  238. exporting excel charts to Word
  239. Solved: extract a column to 5 column
  240. Loading Reference aborts Sub
  241. Solved: listbox little bug
  242. VBA Splitting the text 1-8 to (1,2,3,4,5,6,7,8)
  243. AutoCAD referencefiles?
  244. Solved: Copy images with VBA
  245. UserInterfaceOnly problem
  246. default text in
  247. IF Statement on Cell Format
  248. Adding Criteria to UDF functions
  249. Solved: Change value of one cell based on another cell (Tree logic)
  250. Solved: VBA create hyperlink