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